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)

Folayinka 5 on at

Like (0)

Report

RE: ODATA Web Services

$top=200000 didn't work, it ran into error of long response time.

I'm trying the limit and offset method.

I also saw that I could use 'start' instead of offset. So I'm trying both simultaneously

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,347 on at

Like (0)

Report

RE: ODATA Web Services

check my answer if it helped you, thanks

DANiele

Was this reply helpful? Yes No
Folayinka 5 on at

Like (0)

Report

RE: ODATA Web Services

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
Folayinka 5 on at

Like (0)

Report

RE: ODATA Web Services

Trying this approach now

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,347 on at

Like (0)

Report

RE: ODATA Web Services

CIao

However, I recommend you read this

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

DAniele

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,347 on at

Like (0)

Report

RE: ODATA Web Services

hello

or try

?limit=0&offset=5000

?limit=5000&offset=10000

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,347 on at

Like (0)

Report

RE: ODATA Web Services

try ?$top=200000

Was this reply helpful? Yes No
Folayinka 5 on at

Like (0)

Report

RE: ODATA Web Services

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,347 on at

Like (0)

Report

RE: ODATA Web Services

hi

look this also

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

check my answer if it helped you, thanks

DANiele

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,347 on at

Like (1)

Report

RE: ODATA Web Services

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