Working with JSON Array in Pipelines

Question

I have a pipeline where I send a webhook "Get" request to an endpoint and it responds with an array of JSON records. My question is how do I iterate through those records?

For example, the array contains two values: ID and Name. As the next step in the pipeline I want to search my table to see if the ID already exists and if it does not create a new record.

DougHenning1 · Answer

If you use the "Fetch JSON" step in the "JSON Handler" channel instead, then you can use the "Iterate over JSON records" step to loop the records.

Sign up

Login to the community