Restructure JSON array of objects in Zapier to access object key data

Posted on June 3, 2019June 3, 2019 by Steven Fies

Let’s explore how to restructure a JSON array of objects in Zapier to access object key data. More specifically, how to reduce a JSON array to make the values for each object key available in subsequent zap steps. Notably, this is designed to “solve” the issue of Zapier grouping object key values into a comma-separated list (frustrating[…]

Find records in TrackVia API without the Record ID

Posted on April 4, 2018June 19, 2018 by Steven Fies

TrackVia should really improve their API As of the writing of this article, they don’t provide a means of looking up: Records by Field within a View Records by exact match query string The search functionality they do provide (GET /openapi/views/{viewId}/find) is difficult at best, because this (inconsistently) returns partial matches and close variants. For example,[…]