View/download dataset table with AEP reporting API | Community
Skip to main content
K
kktt-1
Level 2
June 20, 2023
Solved

View/download dataset table with AEP reporting API

  • June 20, 2023
  • 1 reply
  • 1017 views

I am connecting to the AEP API to view/download datasets via Jupyter Notebooks. It seems like the reporting api is working, but I can only view/download the dataset by batch id. Is there a way to simply view/download the current most recent dataset? 


This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by adobechat

Potentially you can use query service, but you have to be careful with performance.

 

Example

SELECT * FROM datasetId ORDER BY yourColumn DESC LIMIT 1;

 Hope this works.

Thanks

Madhan 

1 reply

adobechat
adobechat
Level 5
June 22, 2023

Hi @kktt-1 

In order to access a specific dataset in Adobe Experience Platform (AEP), you typically use the batch id to retrieve the desired dataset as you've stated. However, AEP does not offer a direct way to fetch the most recent dataset through their APIs. Now, to solve this, you could design a workaround by listing all datasets and their associated batch ids, then sort them by time to get the most recent one.
Note that Adobe's APIs may have rate limits depending on your organization's agreement with Adobe. Be mindful of this as you design your solution to avoid hitting those limits.

Hope this was helpful.

Thanks

Madhan

    K
    kktt-1Author
    Level 2
    June 22, 2023

    Thanks Madhan! This was helpful. 
    One follow up question: AEP does not offer a direct way to fetch the most recent dataset through their APIs
    -> Does this require Data Distiller or Query Service for us to fetch the most recent dataset through APIs?




      adobechat
      adobechatAccepted solution
      Level 5
      June 22, 2023

      Potentially you can use query service, but you have to be careful with performance.

       

      Example

      SELECT * FROM datasetId ORDER BY yourColumn DESC LIMIT 1;

       Hope this works.

      Thanks

      Madhan 

        Terms & ConditionsAccessibility statement

        Loading footer...