Getting invoice data from Quickbooks
I want to get invoice data from Quickbooks and put the invoices and associated line items into a Quickbase tables called 'Invoices' and its child table called 'Line Items'. I can get the invoices usi...
Forum Discussion
Hey folks, I published a blogpost yesterday on dealing with nested arrays/lists. Would be very grateful if you glance over it and check if I'm missing some corner cases.
Thank you!
My use case is slightly different. I use a Quickbooks trigger step to get the invoice data, not a .pdf file. So I don't need the AI step to extract the data. My jinja is therefore slightly different. I used {%- set _src = a|to_json | default({}) -%} to set the source. I made a couple of other minor changes since the array name is different and the line items included a total line. I've attached my jinja. Also,a tip for testing: I used a search as the first step and saved the a|to_json in a temporary table so I could see it.