ContributionsMost RecentMost LikesSolutionsRe: Variable assignment in PipelinesJessica, I have not tried to do this exact variable (increment by 1) but you may be able to use the 'loop.index' variable to add the increment in each loop as this will increment by 1 each time through. I'm not sure if the syntax is correct but you could try something like {% set Variable = {"value" : "[your variable] + loop.index"} %} inside the 'for' loop. Then to user the variable is just {{Variable.value}}... I have used similar to set a field from an outer loop as a variable that can then be used in each inner loop to get child data for each parent record in a single request body. Cheers, ------------------------------ Roger Dartnell ------------------------------ Re: Pipeline perform action when record is NOT foundMike, I'm not sure if this is the best practice way of doing it but it works for me... I add an IF statement in the pipeline after the Search step and set it to 'List of records' (from the search step above) 'is not empty'. That way in the 'Then' branch I can add the steps I want it to undertake on each record from the search but if there a no records the pipeline continues to the next step. Hope this helps, Roger ------------------------------ Roger Dartnell ------------------------------ Re: How do you loop through an array on a query JSON object item in a PipelineHi 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 ------------------------------ Re: Pipelines - Adding child data to Json Request using Webhooks ChannelThe short answer is No I haven't, although I have someone in QB following up on it. ------------------------------ Roger Dartnell ------------------------------ Pipelines - Adding child data to Json Request using Webhooks ChannelHello! I have been using the Webhooks Channel in Pipelines to send data to a 3rd party app when a record is updated with the Make Request step and it works well. However, now I need to send a data package that uses fields from a record in the parent table (Sales) and its related children (Line Items) in the same request such that the values from each related Line Item are included within an array in the body of the Json. How can I get Pipelines to populate the array in the body of the Json request with data from the child records (the number of which can vary)? ------------------------------ Roger Dartnell ------------------------------