Skip to main content
Pradeep_Kumar_Srivastav
Pradeep_Kumar_SrivastavAccepted solution
Community Advisor
Aug 7, 2024 11:30 AM UTC

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.
View in thread

3 replies

Pradeep_Kumar_Srivastav
Community Advisor
Pradeep_Kumar_SrivastavCommunity AdvisorAccepted solution
Community Advisor
Aug 7, 2024 11:30 AM UTC

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.
Translate
    GK-007
    GK-007
    Level 9
    Oct 2, 2025 5:43 PM UTC

    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

    Translate
    supratim320
    Level 5
    Aug 14, 2024 4:24 PM UTC

    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

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...