Method:API Q&A

Re: MethodAPISelect_DataSetV2 - Partial Results

Method_David — Wed, 23 May 2012 15:53:37 GMT

Warren_nickus,

Do the transactions show up in regular method? The api queries your method account, it does not query quickbooks. If the transactions are not in your method account then the api cannot return them.

If the transactions do not show up in regular method. Take a look at your synchronization settings under Quickbooks-->Synchronize in method. You may have it set to maintain transactions for a shorter time range than you are querying. Be careful when changing these settings since best practice is to pull only the necessary transactions, as pulling more than necessary can have quite the drag on the performance of QuickBooks (limitation of the QuickBooks SDK).

Re: MethodAPISelect_DataSetV2 - Partial Results

warren_nickus — Wed, 23 May 2012 13:39:43 GMT

Formatting the query using your suggested format didn't help. I used, 2012/Apr/01 and 2012/Apr/23 and still getting partial results. 3 Transactions out of 30 or so.

Re: MethodAPISelect_DataSetV2 - Partial Results

Method_David — Wed, 23 May 2012 13:08:52 GMT

Warren_nickus

How are you formatting the dates? Try formatting them as 'yyyy/MMM/dd' or 'yyyy/MMM/dd hh:mm:ss tt'

So for example 'April 12, 2012' would be formatted as '2012/Apr/12'

And 'April 12, 2012, 10am' would be formatted as '2012/Apr/12 10:00:00 AM'

The way you are formatting them....'05/01/2012'....what date is that? May 1, 2012 or Jan 5, 2012? It's ambigous so sql server tries to interpret it in a way that may not be what you mean.

Dave

MethodAPISelect_DataSetV2 - Partial Results

warren_nickus — Wed, 23 May 2012 08:32:24 GMT

Using the following method we're only getting partial results. The table result should only consist roughly 100 entries.

Suggestions?

wbsMethodAPI.MethodAPISelect_DataSetV2(Me.CompanyName, Me.Username, Me.Password, "", dsItem, "SalesOrder", "TxnDate, RefNumber, TotalAmount", "TxnDate >= '05/01/2012' AND TxnDate < '05/22/2012'", "", "", "")