Skip to main content
kktt-1
Level 2
Jun 20, 2023 8:31 PM UTC
Solved

View/download dataset table with AEP reporting API

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.
adobechat
adobechatAccepted solution
Level 5
Jun 22, 2023 7:32 PM UTC

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 

View in thread

3 replies

adobechat
adobechat
Level 5
Jun 22, 2023 6:04 PM UTC

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

Translate
    kktt-1Author
    Level 2
    Jun 22, 2023 6:35 PM UTC

    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?




    Translate
      adobechat
      adobechatAccepted solution
      Level 5
      Jun 22, 2023 7:32 PM UTC

      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 

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...