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.
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.