Method:API Q&A

Re: What table do I have to access with the API to retreive the Line Items of a particular bill?

rmoultrup — Mon, 08 Jul 2013 18:10:49 GMT

Just what I needed! Thank you very much.

Re: What table do I have to access with the API to retreive the Line Items of a particular bill?

LaCrews — Mon, 08 Jul 2013 17:40:59 GMT

BillRecordID is Foreign Key to the Bill table's primary key RecordID. Vendor is a required field in the Bill table.

To execute this you'll need a few separate calls and code to connect the returned datasets

1. Select api call to locate all Bills where vendor equals yourVendor.

2. Query returned dataset for list of RecordIDs

3. Select call to appropriate BillLine Table where BillRecordID is in list of RecordIDs

4. Add the second dataset to first setting keys as appropriate.

5. Query in memory dataset as needed

HTH

Re: What table do I have to access with the API to retreive the Line Items of a particular bill?

rmoultrup — Mon, 08 Jul 2013 17:18:13 GMT

Okay, we have some bills synced with QB as examples. I found the line itmes in BillLineItem and am able to return the dataset with the API. However, the dataset returns all line items. How is the BillRecordID related to the bill or an individual Vendor?

I need to be able to pull all bills related to a Vendor and diplay the line items through the API.

Re: What table do I have to access with the API to retreive the Line Items of a particular bill?

LaCrews — Mon, 08 Jul 2013 16:55:45 GMT

Hi Ryan

Depending on your needs there are 2 different tables where this information is stored, BillLineItem and BillLineExpense. Knowing which one depends on how you are using QuickBooks.

What table do I have to access with the API to retreive the Line Items of a particular bill?

rmoultrup — Mon, 08 Jul 2013 16:41:10 GMT

I need to know where the information that is being displayed as line items in a bill are stored in Method so that I can retrieve that data with the API.

Thanks,

Ryan