minhhieu106 wrote:E.g. I have 350 records in Jiwa. By settings, API only returns 100 records, how can i get next records until last record?
Hi minhhieu106,
You have 2 options - either change the default limit from 100 to a desired value via the REST APIP Tab of the System Configuration form in Jiwa (not recommended):
Or (recommended) you can use Skip to read in the "next" n records - like a paging technique. Add Skip = 100 to the query DTO and you'll get records 100 to 200. Make sure you also provide an OrderBy field to get consistent results. If you also add Include = Total the response will provide how many record there are available.
- Code: Select all
https://api.jiwa.com.au/Queries/IN_Main?OrderBy=PartNo&Take=100&Include=Total&format=json
This will return something like:
- Code: Select all
{"Total":272,"Results":[{"InventoryID":"69accccb872e42419ad0","...
Note the Total field at the beginning - that tells me I have 272 total records available. I can count how many that first call returned (the Count of Results) - and using that you can then loop through until you get to the end, setting the Take and Skip DTO fields:
- Code: Select all
// Get records 101 to 200
https://api.jiwa.com.au/Queries/IN_Main?OrderBy=PartNo&Skip=100&Take=100&format=json
- Code: Select all
// Get records 201 to 300
https://api.jiwa.com.au/Queries/IN_Main?OrderBy=PartNo&Skip=200&Take=100&format=json
Mike