Re: Select distinct values with MethodAPISelect_DataSetV2 operation

Method_Jonathan — Fri, 28 Aug 2015 21:07:13 GMT

Hi Salamander,

We are expecting a list of field names here, and do not accept additional SQL clauses such as 'DISTINCT'. You can try using the the strGroupByClause to group your results by the field you are wanting to be DISTINCT in order to return a unique dataset, otherwise you will have to perform processing after retrieving values to derive a unique dataset.

Select distinct values with MethodAPISelect_DataSetV2 operation

Salamander — Thu, 06 Aug 2015 17:06:02 GMT

Hello,

I have using the api to select four columns from a Method table, no problem.

However when I used the DISTINCT keyword in the fields portion of the call, the response was blank instead of success. The response was:
<?xml version="1.0" encoding="windows-1252" ?><MethodAPI response = "" ></MethodAPI>

Since there is no error I'm not sure what my next step is.

Is using DISTINCT allowed with the Method API?
What is the proper way to have the API give you distinct values?

Thanks.

Method:API Q&A

Re: Select distinct values with MethodAPISelect_DataSetV2 operation

Select distinct values with MethodAPISelect_DataSetV2 operation