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.  I can connect to the Quickbooks payment table but it looks like you can't add records to a connected table

Sign up

Login to the community