Method Community

 

how to increase Maximum limit of 100 records?

Last post 06-04-2024 9:11 AM by Method_Inderdeep. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 05-22-2024 9:14 AM

    how to increase Maximum limit of 100 records?

    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.

  • 06-03-2024 4:34 PM In reply to

    Re: how to increase Maximum limit of 100 records?

    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.

  • 06-03-2024 11:08 PM In reply to

    Re: how to increase Maximum limit of 100 records?



    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. 

  • 06-03-2024 11:09 PM In reply to

    Re: how to increase Maximum limit of 100 records?

    I am using Salesorderline  table

  • 06-03-2024 11:10 PM In reply to

    Re: how to increase Maximum limit of 100 records?

    and SalesOrder as well 

  • 06-04-2024 12:24 AM In reply to

    Re: how to increase Maximum limit of 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?"

    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')
    }
  • 06-04-2024 9:11 AM In reply to

    Re: how to increase Maximum limit of 100 records?

    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.
Page 1 of 1 (7 items)