How do you loop through an array on a query JSON object item in a Pipeline

Hi Ty,

This one stumped me for a while too but then witht he help of the QB team I have worked out how to use the Webhooks channel and the Jinja2 templating language to do this and other more complex movement of data in and out of QB with Pipelines.  I use the 'Make Request' action in the Webhooks channel to call the QB Insert/Update records API (see https://developer.quickbase.com/operation/upsert) and the 'for' condition in Jinja2 to iterate through each item in the JSON from step A in the request Body.  I also use the 'if' condition with the 'loop.last' function to avoid adding an unwanted comma at the end of the cycle and some of the Jinja2 filters to get me data in the right format for my QB table.  I'm not that good at screenshots so have included a copy of the BODY of my request as follows:

{
"to": "gkp7xfhty",
"data": [ {% for item in a.json.orders %}
{% if loop.last %}
{
"3": {"value": {{item.order_number | int - 10678}}},
"468": {"value": "{{item.shipped_date | truncate(19, true, '')}}"},
"483": {"value": "{{"{:%Y-%m-%dT%H:%M:%S}".format (time.now)}}"},
"528": {"value": "{{item.carrier_name}}"},
"529": {"value": "{{item.tracking_short_status}}"},
"530": {"value": "{{item.tracking_number}}"}
}
{% else %}
{
"3": {"value": {{item.order_number}}},
"468": {"value": "{{item.shipped_date | truncate(19, true, '')}}"},
"483": {"value": "{{"{:%Y-%m-%dT%H:%M:%S}".format (time.now)}}"},
"528": {"value": "{{item.carrier_name}}"},
"529": {"value": "{{item.tracking_short_status}}"},
"530": {"value": "{{item.tracking_number}}"}
},
{% endif %} {% endfor %}
]
}

In this example I am updating records in QB with some shipping information I have requested from our shipping app, so I have my record ID as one of the fields ("3") but if you are adding new records just leave this field out.  For more on Jinja2 templating see https://help.quickbase.com/pipelines/about_jinja.html and http://jinja.octoprint.org/templates.html.

Hope this helps - once you get your head around how to use the Jinja2 templating language and work out the syntax nuances it completely changes what you can acheive with Pipelines!

Cheers

------------------------------
Roger Dartnell
------------------------------