Method Community

Hi, Per discusson offline which is caused by a known issue, just want to know any progress/solution to this? It is really annoying to remove those extra ID column daily. Thanks. Alex

Hi wayneteng, To retrieve, you can use the following calls from the API MethodAPISelect_DatasetV2 MethodAPISelect_XMLV2 Also, please see this related post for additional implementation details. 

The Sales Order table requires the Customer and TxnDate fields - have you supplied these in your original call? If you post up the parameters passed for you original call, I might be able to shed some light as to what caused the error.  The 'Ref' portion is added to the field name in this case because the Customer field is ...

{ MethodAPIInsertV2Result: '<?xml version="1.0" encoding="windows-1252" ?><MethodAPI response = "Not all required fields are present. Required field CustomerRef is not passed for the table SalesOrder" ></MethodAPI>' } CustomerRef is not an existing field in SalesOrder.

I am referring to an actaul file. This is more of a general question: what api can I use to retrieve a file.

Hi Wayneteng, Can you be more specific around which table & field you are retrieving from?  Are you referring to an actual 'File' (e.g. a document) or a 'record' (e.g. a customer record in the customer table).

Hi Wayneteng, Can you provide more details to help us identify the problem- What table are you inserting record into? Can you post up an example of the parameters you are passing so that we can validate the call? Thanks

I used field list and found 2 required fields on my table. When i try to insert passing in those 2 required fields I get a response that says there is a required "CustomerRef" field. This field does not exist in my table. How can I get insert into this table?

It would be great to have an action that would expand or collapse a section. For example, clicking a grid row expands a section below it. Currently the only way to do something like this is through show and hide, but then there is no header for the user to click on to get it back.

I see both apis for update and delete file. Is there a way to retrieve a file that is already in Quickbooks?