Method Community

Hello Support ,

We are retrieving records fine when limited to Top 10.

I changed the 10 to 100 and we get 401 unauthorized , can you please advise how we can increase the limit on both Top and skip without being blocked.

From documentation it says ……. The default value of top is 10 and the maximum allowed value of top is 100. i.e Maximum of 100 records can be requested in a single request, use the nextLink to get the next 100 records.

We changed the 10 to 100 and we get 401 unauthorized , can you please advise how we can increase the limit to 100 and to get next hundred also add 100 in skip

We are using Postman to test.

I want to get more than 100 records in single request. let me know the solutions.

it's urgent I need answer for my questions.  please reply me. 

Hello Support ,

We are retrieving records fine when limited to Top 10.

I changed the 10 to 100 and we get 401 unauthorized , can you please advise how we can increase the limit on both Top and skip without being blocked.

From documentation it says ……. The default value of top is 10 and the maximum allowed value of top is 100. i.e Maximum of 100 records can be requested in a single request, use the nextLink to get the next 100 records.

We changed the 10 to 100 and we get 401 unauthorized , can you please advise how we can increase the limit to 100 and to get next hundred also add 100 in skip

We are using Postman to test.

I want to get more than 100 records in single request. let me know the solutions.

Hi athakur,

Apologies for getting back to you late. I tested this on my account and can confirm that you should be ablw to retrieve 100 records. 

Could you please let me know what table are you using in your request? Also, if you can share a little bit more detail about your request, I will be able to point you in the right direction.

So your postman request will help me to look into this futher for you. 

I am using Salesorderline  table

and SalesOrder as well 

"I'm using Azure Data Factory to fetch records. How do I ensure each request retrieves distinct (unique) records? For example, if I have 201 records in SalesOrderLine and want to get all data using an API call without duplicating records each time, how can I ensure it returns the latest data with each request?"

here is api URL  request  : 

Unfortunately, we cannot increase the maximum limit of 100 records in a call. Here is what you can do :

- Carefully apply criteria to only pull just the records he needs, nothing more. https://developer.method.me/#section/Filter-Reference

- Use paging to pull the next set of 100 records. https://developer.method.me/#tag/Tables/operation/tables-query-records

• Skip and top query parameters together allow paginating through the records. The default value of top is 10 and the maximum allowed value of top is 100. i.e Maximum of 100 records can be requested in a single request, use the next link to get the next 100 records.

"I'm using Azure Data Factory to fetch records. How do I ensure each request retrieves distinct (unique) records? For example, if I have 201 records in SalesOrderLine and want to get all data using an API call without duplicating records each time, how can I ensure it returns the latest data with each request?"

let's say:  i have 201 record and i have hit endpoint i will get 100 record but when i request 2nd time it should provide me next 100 unique record . please provide me some example or  url request  sample.

here is api URL  request  : 

Replied on the thread here:
https://forums.method.me/cs/forums/p/13101/37084.aspx#37084