Find Jobs
Hire Freelancers

AWS Lambda Function Connecting Shopify API to Airtable API

$12-30 SGD

Closed
Posted over 4 years ago

$12-30 SGD

Paid on delivery
Hi there, Please start all applications with this phrase – "READ THE REQUIREMENTS" ========================= I'm looking for someone to create the following Lambda function in NodeJS v8.10, to execute every 15 minutes: 1. Connect to a specific table in Airtable, pull up the largest value in a column called order ID. Save this to variable "LastOrder" 2. Connect to Shopify via API (private app) to get all orders since order ID "LastOrder" (using since_id, which is not incremental but gets larger with each new order). Note that Shopify API has a limit of 250 orders per pull – this function must therefore take this into account and loop the necessary times 3. Add these new orders into new rows in Airtable I will also need a second Lamda function derived from the first, but triggered by a webhook (Shopify order creation success) instead of a timer. This function will parse the Shopify new order data into a new row in the same table in Airtable. I have set up my AWS Account, IAM policies, and Severless on a DigitalOcean droplet. I can give you access to my DigitalOcean droplet via your SSH public key for easy AWS working environment. Please read the Airtable and Shopify API documentation before quoting.
Project ID: 20688065

About the project

2 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2 freelancers are bidding on average $26 SGD for this job
User Avatar
For Airtable retrieve: Get the first record ordered by order ID column descending, this will give the largest value (or the last order id) For Shopify: Will be using since_id to get orders after the last sync (as found from Airtble). Will use the limit parameter to limit results to say 50 (can do up to 250, but 50 is optimal) -> Save in Airtable update since_id (from the last iteration) and loop till all are processed I am an AWS certified solution architect and developer associate. Can discuss decoupling as well if you want.
$25 SGD in 3 days
5.0 (4 reviews)
1.5
1.5
User Avatar
Only pay if you're satisfied Relevant Skills and Experience I did many data migration for different apps
$27 SGD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SINGAPORE
#08-80, Singapore
5.0
5
Payment method verified
Member since Aug 29, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.