Get all data in single REST request

[bidya1]

Hi All,

We have a requirement to fetch all data from a table in JSON format. So, we opted for REST web services.

The OOTB Table API returns only 10000 records at max in a single request and gives the links for the pages containing the remaining data.

This does not suit our need. Is there any way to increase this value from 10000 to a larger number.

We also tried achieving this using glide query in a scripted REST API. The scripted method is working fine for less number of records.

But when we tried retrieving more than couple of thousand records, first problem was we got transaction timeout error.

So, we increased the transaction quota to 5000 secs for JSON and REST Catch All. After this error is not coming but we are not getting any response. Status code comes as "0" and response body is blank.

Please advise what could be the issue.

Thanks,

Bidya

[Harsh Vardhan]

have you checked this thread? hope it will help you

How to get more than 10000 records in response of GET method in REST API

[bidya1]

Yes, I have went through the discussion in the thread. What I understood from that is, the link response header will have URLs for different pages of the resultset. So, the consumer needs to send as many requests as the number of pages to get entire data set. This is what is not desirable in our situation.

[Harsh Vardhan]

sysparm_offset

Number of records to exclude from the query. Use this parameter to obtain more records than specified in sysparm_limit. For example, if sysparm_limit is set to 500, but there are additional records you want to query, specify a sysparm_offset value of 500 to get the second set of records. Do not pass a negative number in the sysparm_offset parameter.

have you tried with this one?

Table API - GET /now/table/{tableName}