Getting invoice data from Quickbooks

Question

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 using the Quickbooks channel Search Invoices step, and the 'Lines' list field is shown as one of the fields of the Search Record from that step. See attached screenshot. I can loop through the Invoices to populate the 'Invoices' table but there seems to be no way to iterate through the 'Lines' list of each Invoice to populate the child table. Customer support tried but their suggestions didn't work. The only example I found is to go the other way: creating a Quickbooks invoice from the above mentioned Quickbase tables.

kellison3205 · Answer

I discovered that I can get invoices and their line items using connected tables instead of a pipeline. The only thing I can't seem to do is to post a payment from an external system into Quickbooks using pipeline steps or connected tables.&nbsp; I can connect to the Quickbooks payment table but it looks like you can't add records to a connected table

georgipeev · Answer

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!

kellison3205 · Answer

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.&nbsp; 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.

Forum Discussion