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 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.