Pipeline Jinja Issues
Hello Quickbase Community!
I'm having issues with a pipeline.
Step A: Quickbase Channel - Quickbase API - Make a Request
Essentially, I query data in a table and get back some JSON data....
Forum Discussion
Dwight,
I am no Jinja or Python expert, however I remember reading somewhere in a Python resource about declaring variables inside and outside of a loop. You have defined Running Total twice and there is a voice in my head saying that your problem lies there.
The two best resources for Jinja here are @Doug Henning or @Prashant Maheshwari
------------------------------
Don Larson
------------------------------
This worked for me for the running total. Now I'm trying to figure out a while loop for it to only iterate up to the myTimeStop.
{
{% set myDataSet = "myTableID" %}
{% set myTimeStop = 5.0 %}
{% set runningTotal = namespace(val=0.0) %}
"to": "{{myDataSet}}",
"data":[
{% for row in (a.json.data) %}
{
{% set runningTotal.val = runningTotal.val + row['33'].value %}
"6":{
"value": "{{row['36'].value}}"
},
"7":{
"value": "{{row['8'].value}}"
},
"8":{
"value": "{{row['13'].value}}"
},
"9":{
"value": "{{row['33'].value}}"
},
"10":{
"value": "{{runningTotal.val}}"
}
}
{% if loop.last == false %},{% endif %}
{%- endfor %}
]
}
------------------------------
Dwight Munson
------------------------------
In the AM I'm going to try something like this:
{
{% set myDataSet = "myTableID" %}
{% set myTimeStop = 5.0 %}
{% set runningTotal = namespace(val=0.0) %}
"to": "{{myDataSet}}",
"data":[
{% set i = 0 %}
{% while runningTotal.val <= myTimeStop and i < a.json.total_records %}
{% set row = a.json.data %}
{% set remainingTime = myTimeStop - runningTotal.val %}
{% set currentValue = row['33'].value if row['33'].value <= remainingTime else remainingTime %}
{% set runningTotal.val = runningTotal.val + currentValue %}
{
"6":{
"value": "{{row['36'].value}}"
},
"7":{
"value": "{{row['8'].value}}"
},
"8":{
"value": "{{row['13'].value}}"
},
"9":{
"value": "{{currentValue}}"
},
"10":{
"value": "{{runningTotal.val}}"
}
}
{% set i = i + 1 %}
{% if loop.last == false and runningTotal.val <= myTimeStop %},{% endif %}
{%- endwhile %}
]
}
------------------------------
Dwight Munson
------------------------------