Method:API Q&A

Re: Failure. There were problems with running the query. Please try again. If this message continues to appear, please contact support.

Method_David — Wed, 23 May 2012 13:06:03 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'

Dave

Re: Failure. There were problems with running the query. Please try again. If this message continues to appear, please contact support.

warren_nickus — Wed, 23 May 2012 08:22:07 GMT

The error was fixed but still getting partial results. Will post a new entry.

Nick

Failure. There were problems with running the query. Please try again. If this message continues to appear, please contact support.

warren_nickus — Wed, 23 May 2012 08:15:31 GMT

I'm trying to retrieve a sales order table based on TxnDate. This is the exact call of the function:

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

The response is:

Failure. There were problems with running the query. Please try again. If this message continues to appear, please contact support.

Moreover, even if the results are retireved - I'm missing MANY of the entries. I'm only getting a partial list of those Sales Orders.

Suggestions?