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?