Method Community

 

MethodAPISelect_XML limit question

Last post 08-24-2009 1:11 PM by Method_Paul. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-24-2009 1:06 PM

    • paul
    • Top 500 Contributor
    • Joined on 08-21-2009
    • Posts 11

    MethodAPISelect_XML limit question

    Hello,

    I'm experimenting with the API and wanted to just browse some of the data in some of tables. To put it more simply, I'd like to run the equivalent of this SQL query over the API.

    Select Name from Customers limit 5;

    It looks like I should be using the MethodAPISelect_XML to accomplish this. In the documentation I see some flags for manipulating the query such as 'Having','GroupBy' and 'OrderBy'. I was wondering if there was a flag for limiting the number of elements in the response document?

    Gracias!

  • 08-24-2009 1:11 PM In reply to

    Re: MethodAPISelect_XML limit question

    Nothing in there right now that could limit the response by an exact number of records.....

    You could try "RecordID < 101" to grab the first 100 (assuming no deletions).  Not really what you are looking for, but might solve the problem for now.

    Paul

Page 1 of 1 (2 items)