Forum Discussion
BrianSeymour
11 months agoQrew Cadet
Are you able to use the Incoming Request Channel to define an endpoint which may be used to listen and parse JSON?
For example, create https://www.pipelines.quickbase.com/hooks/webhooks/you-webhook-id that listens for JSON. Then, I'd suggest storing the raw JSON as a record (into Text - Multi-line field) in a "Responses" table for debugging and tracking down any discrepancies. In other words, track the response history.
Then, in a subsequent Pipeline step, you can pull values from the received JSON via Jinja, for example {{ a.body_json.data.your_field }}. But I don't have an example of how you'd loop through your JSON's nested objects to create multiple records … so, perhaps someone else can chime in with a snippet!
------------------------------
Brian Seymour
------------------------------