http://forums.method.me/cs/forums/15.aspxAsk questions specific to the MethodAPI from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/1228.aspxMon, 24 Aug 2009 18:11:27 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:1228Method_Paul0http://forums.method.me/cs/forums/thread/1228.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=1228<p>Nothing in there right now that could limit the response by an exact number of records.....</p> <p>You could try &quot;RecordID &lt; 101&quot; to grab the first 100 (assuming no deletions).&nbsp; Not really what you are looking for, but might solve the problem for now.</p> <p>Paul</p>http://forums.method.me/cs/forums/thread/1227.aspxMon, 24 Aug 2009 18:06:24 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:1227paul0http://forums.method.me/cs/forums/thread/1227.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=1227<p>Hello,</p> <p>I&#39;m experimenting with the API and wanted to just browse some of the data in some of tables. To put it more simply, I&#39;d like to run the equivalent of this SQL query over the API.</p> <p>Select Name from Customers limit 5;</p> <p>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 &#39;Having&#39;,&#39;GroupBy&#39; and &#39;OrderBy&#39;. I was wondering if there was a flag for limiting the number of elements in the response document?<br /><br />Gracias!</p>