ODATA Web Services

(0) Share

Report

Posted on by Folayinka

Hi everyone,

our service consumer is trying to read data from our API, but there are too many records of data in one API request.

I have set a dataitem table view in the API design but the records are still too much.

The API response keeps running into an error.

Is there a way I can break the API request into batches?

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

srttel on at

Like (1)

Report

You might think about filtering the data to get the data in several subsets

Like discussed here Business Central API limitations - Microsoft Q&A

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (1)

Report

Hi

After your odata url add this for example:

?$top=5000

where 5000 is the revcord number you want to be returned

DAniele

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

look this also

learn.microsoft.com/.../api-design

check my answer if it helped you, thanks

DANiele

Was this reply helpful? Yes No
Folayinka 5 on at

Like (0)

Report

Okay, I'll try this.

What of the remaining records? I have like 200,000 records.

So after the first 5,000...how do i get the remaining?

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

try ?$top=200000

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hello

or try

?limit=0&offset=5000

?limit=5000&offset=10000

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

CIao

However, I recommend you read this

learn.microsoft.com/.../api-design

DAniele

Was this reply helpful? Yes No
Folayinka 5 on at

Like (0)

Report

Trying this approach now

Was this reply helpful? Yes No
Folayinka 5 on at

Like (0)

Report

This is an amazing article. I've been watching videos on SOAP and REST web services. But this is by far the most informative and relatable I have seen. Thanks.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

check my answer if it helped you, thanks

DANiele

Was this reply helpful? Yes No