Method:API Q&A

Re: how to increase Maximum limit of 100 records?

Method_Inderdeep — Wed, 26 Jun 2024 18:16:54 GMT

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

Re: how to increase Maximum limit of 100 records?

athakur@amlongroup.com — Mon, 24 Jun 2024 17:27:51 GMT

"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 :

@{concat('https://rest.method.me/api/v1/tables/SalesOrderLine?filter=SORecordIDTxnDate le ''', '2024-05-30T18:00:00', '''&orderby=SORecordIDTxnDate desc&$top=1')

}

Re: how to increase Maximum limit of 100 records?

Method_Inderdeep — Tue, 04 Jun 2024 14:11:43 GMT

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.

Re: how to increase Maximum limit of 100 records?

athakur@amlongroup.com — Tue, 04 Jun 2024 05:24:32 GMT

here is api URL request :

@{concat('https://rest.method.me/api/v1/tables/SalesOrderLine?filter=SORecordIDTxnDate le ''', '2024-05-30T18:00:00', '''&orderby=SORecordIDTxnDate desc&$top=1')

}

Re: how to increase Maximum limit of 100 records?

athakur@amlongroup.com — Tue, 04 Jun 2024 04:10:17 GMT

and SalesOrder as well

Re: how to increase Maximum limit of 100 records?

athakur@amlongroup.com — Tue, 04 Jun 2024 04:09:58 GMT

I am using Salesorderline table

Re: how to increase Maximum limit of 100 records?

Method_Inderdeep — Tue, 04 Jun 2024 04:08:11 GMT

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.

Re: how to increase Maximum limit of 100 records?

athakur@amlongroup.com — Mon, 03 Jun 2024 21:34:44 GMT

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.

how to increase Maximum limit of 100 records?

athakur@amlongroup.com — Wed, 22 May 2024 14:14:14 GMT

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.

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.

Method:API Q&A

Re: how to increase Maximum limit of 100 records﻿?

Re: how to increase Maximum limit of 100 records﻿?

Re: how to increase Maximum limit of 100 records﻿?

Re: how to increase Maximum limit of 100 records﻿?

Re: how to increase Maximum limit of 100 records﻿?

Re: how to increase Maximum limit of 100 records﻿?

Re: how to increase Maximum limit of 100 records﻿?

Re: how to increase Maximum limit of 100 records﻿?

how to increase Maximum limit of 100 records﻿?

Re: how to increase Maximum limit of 100 records?

Re: how to increase Maximum limit of 100 records?

Re: how to increase Maximum limit of 100 records?

Re: how to increase Maximum limit of 100 records?

Re: how to increase Maximum limit of 100 records?

Re: how to increase Maximum limit of 100 records?

Re: how to increase Maximum limit of 100 records?

Re: how to increase Maximum limit of 100 records?

how to increase Maximum limit of 100 records?