Search results by user ID 4619

Re: MethodAPISelect_XMLV2 strGroupByClause parameter error

MikeC — Wed, 12 Jan 2011 00:47:08 GMT

Sorry for the delayed response. I use Mozilla FireFox 3.6.13 currently as my main browser.

Re: MethodAPISelect_XMLV2 strGroupByClause parameter error

MikeC — Thu, 06 Jan 2011 05:01:48 GMT

Thanks for responding so quickly Victor.

I too had used the browser to manually obtain the records with no errors.

The error you mention makes perfect sense now that you have explained the syntax.

Regarding the other error:
The SQL returned the following error: An expression of non-boolean type specified in a context where a condition is expected, near 'GROUP'.

Any ideas of what that could be?

My intention is to use Method API to obtain data automatically (push of a button or when the program loads) to be used in other independent applications. Currently I want to use it for QReportBuilder, a report writing tool based upon the application development tool I use to create software (Alpha5 from Alpha Software). This report writer is very powerful and many users say it is much better than Crystal Reports even. There are many limits in Method's built-in report writer that QReportBuilder does not have. Although I can currently obtain data directly from a desktop installation of QuickBooks, being able to obtain data from a Method account will give me a much more powerful toolkit which will be able to satisfy almost every client's needs especially in regards to report building.

Re: MethodAPISelect_XMLV2 strGroupByClause parameter error

MikeC — Thu, 06 Jan 2011 00:55:18 GMT

I just spent a half hour replying (with interruptions) and due to what apparently is a timeout for this forum, when I chose to Post, it brought me to the sign in page.....and I lost what I had written....this is the second time this has happened.

This short message is just to let you know I was going to acknowledge your answer but I have to leave now until later tonight so cannot respond again for a while.

Try, try again right!?

MethodAPISelect_XMLV2 strGroupByClause parameter error

MikeC — Wed, 05 Jan 2011 21:35:19 GMT

Hi,

I have successfully used a third party development tool to access the Method API to obtain both the Table and Field Lists. Using the same syntax for obtaining the data, however, gives the errors indicated below. The built in third party function's description can be found via the link below which goes to an online help file. It is designed to access http/https sites and be able to return XML.

http://support.alphasoftware.com/alphafivehelpv8/Functions/HTTP_POST_PAGE2().htm

I do not know whether this is a Method API issue or one that lays within how the third party function sends the information. I have tried all the permutations I can with the strGroupByClause syntax,ie; no quotes, single quotes, double quotes, no field name, field name, ....

dim field_page as c
dim str3 as c
str3=""
str3="strCompanyAccount=AccountName&strLogin=LoginName&strPassword=PasswordName&Length=9000&strSessionID=''&strTable=Customer"
str3=str3+"&strFields=fullname,phone&strWhereClause=''&strGroupByClause=''&strHaving=''&strOrderBy=''"
field_Page=http_post_page2("https://www.methodintegration.com/MethodAPI/service.asmx/MethodAPISelect_XMLV2",str3)

''===================================================================================

Header information received:

HTTP/1.1 200 OK
Cache-Control: private, max-age=0
Content-Type: text/xml; charset=utf-8
ETag: ""
Server: Microsoft-IIS/7.0
X-AspNet-Version: 4.0.30319
X-Powered-By: ASP.NET
Date: Wed, 05 Jan 2011 14:59:43 GMT

Error when strGroupByClause=fullname field:

strGroupByClause=fullname
<?xml version="1.0" encoding="utf-8"?>
<string xmlns="http://tempuri.org/"><?xml version="1.0" encoding="windows-1252" ?>
<MethodAPI response = "Failure. The SQL returned the following error: An expression of non-boolean type specified in a context where a condition is expected, near 'GROUP'." >
</MethodAPI></string>

Error when strGroupByClause=nothing:

strGroupByClause=''
<?xml version="1.0" encoding="utf-8"?>
<string xmlns="http://tempuri.org/"><?xml version="1.0" encoding="windows-1252" ?>
<MethodAPI response = "Please make sure the fields entered in the group by clause is contained in your field list." >
</MethodAPI></string>

Any thoughts?