Finance | Project Operations, Human Resources, ...

OData Pagination

(0) Share

Report

Posted on by Johnny_321

Hi - I'm looking to bring Odata feeds into a Bi tool.

I'm able to pull in the first page of 1000 records but no additional pages.

I'm a newbie to this and can reduce the data set with the $top instruction in the URL but I'm unable to pull in further pages.

How am I able to bring in all data from the set?

Thanks in advance

John

All responses (3)

Answers (0)

Suggested answer

Mea_ 60,278 on at

Like (0)

Report

RE: OData Pagination

As Sergei mentioned, OData supports pagination, if you look at response in the end of it you will see

"@odata.nextLink": https://*****.operations.dynamics.com/data/CustomersV3?$skip=10000&$top=10000"

using it you can get next 10000 records. However, as Sergei mentioned, BYOD or Data Lake could be better approach for reporting and high volumes of data. Here is compassion between DMF and OData and common usage scenarios docs.microsoft.com/.../integration-overview
Johnny_321 5 on at

Like (0)

Report

RE: OData Pagination

Morning Sergei,

Thanks for taking the time to respond :-)

The BYOD link looks like that could be incredibly helpful.

All the Best

Johnny
Suggested answer

Sergei Minozhenko 23,089 on at

Like (0)

Report

RE: OData Pagination

Hi Johnny_321,

I think pagination can be achieved by using skip option. But it's not a good idea to query a lot of data through oData.

Take a look at BYOD docs.microsoft.com/.../export-entities-to-your-own-database

data/CustomersV3?$top=1000 - First page

data/CustomersV3?$top=1000&$skip=1000 - Seconds page

data/CustomersV3?$top=1000&$skip=2000 - Third page