Summary: Insert a JavaScript code into a Zapier step for extracting data (array) from a webhook catch into readable variables
details:
I have integrated our Checkfront Booking system about 95% to export all events booked into google calendar.
My background being SW Integration Engineer for 10 years before turning to Mobile pizza food truck helped me do that. What I now need is a SW Developer capable of helping me out extracting some data through an extra Zapier step (probably inserting a Javascript or Python Code between step 1 & 2).
I’d like to extract some information from the ‘Catch Hook’ called booking__order__items__item
It seems that Zapier can understand correctly if there is only 1 item, but from 2 up (array), it only displays that ugly table (see screenshot)
Please provide me with an email I can use to invite you in Zapier and in Google calendar.
There are a couple of hooks with 1 item and several items which seems to trigger Zapier differently.
Zapier displays them as follow, but that’s not really readable under Google Calendar (see screenshot)
The Description from Checkfront is at:
[login to view URL]
"item": [
{
"@attributes": {
"line_id": "1",
"item_id": "6"
},
"start_date": "1394128800",
"end_date": "1394128800",
"sku": "paddle",
"slip": {},
"package_id": "1",
"status": "HOLD",
"total": "6.30",
"tax_total": "0.30",
"qty": "2"
},
{
"@attributes": {
"line_id": "2",
"item_id": "8"
},
"start_date": "1394092800",
"end_date": "1394092800",
"sku": "paddleboard",
"slip": {},
"package_id": "1",
"status": "HOLD",
"total": "42.00",
"tax_total": "2.00",
"qty": "2"
}
For each item I’d like to extract the sku type and qty if relevant. The rest of the data is irrelevant to me.
I’d also need to manipulate the content of the output suck as:
if sku = ‘allegraairstream’ then return {vehicle: ‘Airstream’};
if sku = ‘extrahourofhire’ then return { extra_service_time: qty};
etc…
Hello,
I am Zied, a software engineer from Tunisia (UTC + 1).
I have several experiences with Zapier Integration mainly linking Slack, Twilio and Recurly. I have also worked with Google Calendar API with a NodeJS project.
I would be more than happy to help you achieve what you need. If you would like, you can add me also on Skype « ziedmahdi ».
Thank you for taking the time to review my application.