3min

Zapier - Formatting arrays correctly

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
Finding an individual user and retrieving their data



Pass that data into a "Run Javascript" action and run the following JavaScript
Pass that data into a "Run Javascript" action and run the following JavaScript



JS
|
Pass the output of the "Run Javascript" action into the "Update User" action
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