XML and JSON parameters
If you try to generate a request that takes longer than 3 minutes the request will be terminated. Please make good use of filters and leverage the different parameters for the XML and JSON feeds as described below To use these options, right-click the XML or JSON feed icon and copy the link into the browser.
Three different parameters can be used together to generate different requests.
TYPE- The “TYPE” parameter controls what type of request you are sending to the server.
By default your request is “TYPE=DEEP” which means that if you have a form that contains sub-forms, the request is going to find all related sub-form records and return them. To change the type, you need to manually pass the parameter and the property into the URL.
When you pass the “TOP” property in the URL, the request will only return the data for the table you are running the request on. No sub-form records will be returned with this request.
Passing the “ID” property will only return the record ID’s. This option is effective for complex data structures, and identifies the records that need to be fetched. Knowing the records that are new, you can now grab each record one at a time. See notes below.
SINCE_DATE- This parameter accepts a value of “yyyy-mm-dd” and will return records that have a CREATED_DATE greater than the date you specify in the URL.
Ex. SINCE_DATE=2011-01-01(Records that were created on or after 2011-01-02 will be returned.)
SINCE_ID – Similar to SINCE_DATE, this parameter accepts a numerical value and returns records that have an ID greater than the one specified.
Ex. SINCE_ID=250 (Records starting from 251 and up will be returned.)