PUBLIC API/ZAPIER
Zapier - Formatting arrays correctly

2min
Background
When working with Zapier, adding data to arrays needs some extra JavaScript to convert the data. Zapier calls arrays "Line Items" and formats them like so, [123,456,789] whereas Siteglide API expects a JavaScript formatted array such as, ["123","456","789"] 
To convert these two data types, use the screenshots and code below.  In this example we are getting a pre-existing user and their Secure Zones, then adding in a new item.
Zapier Setup
Finding an individual user and retrieving their data
﻿
﻿
Pass that data into a "Run Javascript" action and run the following JavaScript
﻿
﻿
JS
let data = inputData.sz.split(','); //Where sz is the name of the input data you picked above
let array = [];

data.forEach(item => array.push(item));
array.push("178375") //The ID of your secure zone

output = {output: JSON.stringify(array)};
let data = inputData.sz.split(','); //Where sz is the name of the input data you picked above
let array = [];

data.forEach(item => array.push(item));
array.push("178375") //The ID of your secure zone

output = {output: JSON.stringify(array)};
﻿
Pass the output of the "Run Javascript" action into the "Update User" action
﻿
The above javascript code and flow can be used for anywhere that you need to add an item to Line Items within Zapier
Updated 06 Apr 2023
Did this page help you?
Site Search
Public API/Zapier Changelog