JessicaFeauto
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Make Request JSON returning blank when only one record returned
I am retrieving data from an external data source using Make Request. I am then using another Make Request to send data to a QB table using the format shown below. It works great when I have 2 or more records in the response. However, when I only have one, then every field ends up being blank, even though I can see data in the response. Any thoughts? {# create records in XXXX table #} "to": "XXXXX", "data": [ {% for rec in f.json.response.xxxxxs.xxxx %} {% if loop.index0<5800 %} { "12":{ "value": "{{rec['@creationdate']}}"}, "6":{ "value": "{{rec['@id']}}"}, "38":{ "value": "{{rec['@status']}}"} } {{ ", " if not loop.last else "" }} {% endif %} {% endfor %} ] }32Views0likes1CommentQuickbooks invoice pipeline issue
Is anyone having trouble with Quickbooks invoice pipelines? I had been using the solution here which had been working correctly in the pipeline since 2020. Now I am getting this error every time I run it: Validation error: Incorrect template "{{b.amount}}". ValueError: invalid literal for int() with base 10: 'amount' . If i try to remove the 'amount' field then I just get the same error for a different field. Quickbase support has not been helpful at this point. Thoughts? ------------------------------ Jessica Feauto ------------------------------46Views0likes1CommentRe: Variable assignment in Pipelines
Thanks Mark! I saw your post after I posted mine. The fact that they run for-each loops asynchronously is really a problem for my use case as well. I've tried chaining Pipelines (ie pipeline 1 performs an action then cues pipeline 2) together to get them to run in sequence but that didn't work either. I sent a support request for Quickbase 2 days ago about this but they have not gotten a solution for me yet. I'll keep you in the loop (pun intended). ------------------------------ Jessica Feauto ------------------------------132Views0likes1CommentVariable assignment in Pipelines
Does anyone have experience with assigning a variable in Pipelines and changing it throughout the pipeline. Basically, I want to assign a variable at the start of the 'for' loop and then increment it by 1 for each part of the loop. Has anyone done this? ------------------------------ Jessica Feauto ------------------------------154Views0likes6Comments