Method:API Q&A

Re: Retrieve File

Method_Jonathan — Fri, 18 Mar 2016 18:10:48 GMT

Hi,

File attachements do not synchronize between QuickBooks Desktop and Method, this is a limitation with the current QuickBooks SDK integration.

If you are in need of accessing QuickBooks files, there are third party products avaialble (such as SmartVault) that integrate with QuickBooks. SmartValut allows you to store documents in the cloud and relate them to QuickBooks entities and transactions. Method has an integration with SmartValut as well.

Re: Retrieve File

wayneteng — Fri, 18 Mar 2016 17:43:02 GMT

I attached a file to SalesOrder in quickbooks. What field can I use MethodAPISelect_XMLV2 on to retreive this file?

Re: Retrieve File

Method_Jonathan — Wed, 09 Mar 2016 23:21:14 GMT

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.

Re: Retrieve File

wayneteng — Wed, 09 Mar 2016 22:11:48 GMT

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

Re: Retrieve File

Method_Jonathan — Wed, 09 Mar 2016 21:34:42 GMT

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

Retrieve File

wayneteng — Wed, 09 Mar 2016 20:06:00 GMT

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