Increase maximum limit for number of objects fetched for an API call | Community
Skip to main content
Best answer by Pradeep_Kumar_Srivastav

Hi @tapasmahalik ,

You will need to use pagination for such use cases. By default the limit is 100. Please refer below details from Data access API. 

 

Responses within the Data Access API are paginated. By default, the maximum number of entries per page is 100. You can modify the default behavior with paging parameters.

  • limit: You can specify the number of entries per page according to your requirements using the “limit” parameter.
  • start: The offset can be set by the “start” query parameter.
  • &: You can use an ampersand to combine multiple parameters in a single call.

2 replies

Pradeep_Kumar_Srivastav
Community Advisor
Pradeep_Kumar_SrivastavCommunity AdvisorAccepted solution
Community Advisor
August 7, 2024

Hi @tapasmahalik ,

You will need to use pagination for such use cases. By default the limit is 100. Please refer below details from Data access API. 

 

Responses within the Data Access API are paginated. By default, the maximum number of entries per page is 100. You can modify the default behavior with paging parameters.

  • limit: You can specify the number of entries per page according to your requirements using the “limit” parameter.
  • start: The offset can be set by the “start” query parameter.
  • &: You can use an ampersand to combine multiple parameters in a single call.
    GK-007
    GK-007
    Level 9
    October 2, 2025

    Hello,I also come across same situation,am using below query but still getting max 100 rows only.As per written query,results count is max 10000.

     

    select CURRENT_TIMESTAMP,_xxxx.pageAttributes.internalTrackingCode,eventType from xxxx_xxxx_qa where TIMESTAMP >='2025-10-02' ORDER BY TIMESTAMP DESC LIMIT 10000 OFFSET 0

    Please guide me what i am missing ,and also is there any other way to achieve this scenario?

    Thanks,

    Kishore

    S
    supratim320
    Level 5
    August 14, 2024

    There is a python based library aepp, this might be helpful in your case(I think you are looking to fetch all the datasets). This library parses all the records and passes the final result. See if this helps you:

    Github: https://github.com/adobe/aepp/blob/main/aepp/catalog.py

      Terms & ConditionsAccessibility statement

      Loading footer...