News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... ODATA Web Services

Small and medium business | Business Central, N...

Suggested answer

ODATA Web Services

(0) Share

Report

Report

Posted on by Folayinka

5

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?

All responses Img

All responses (11)

Answers Img

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
Suggested answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: ODATA Web Services

check my answer if it helped you, thanks

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

Like (0)

Report

RE: ODATA Web Services

Trying this approach now
Suggested answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: ODATA Web Services

CIao

However, I recommend you read this

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

DAniele
Suggested answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: ODATA Web Services

hello

or try

?limit=0&offset=5000

?limit=5000&offset=10000
Suggested answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: ODATA Web Services

try ?$top=200000
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?
Suggested answer

DAnny3211 9,276 Moderator 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
Suggested answer

DAnny3211 9,276 Moderator 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

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,190 Super User 2025 Season 1

#2

Martin Dráb 232,968 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans