AEP Queries using API

[sheejo]

Hello

Good evening. Is there any way to query to AEP using API calls? Is there any way to export the queried dataset from AEP to csv files/.txt files?  What will be the max limit to display in UI?

[Avinash_Gupta_ · Accepted solution]

Hi @sheejo 

Yes, it's possible to query to AEP using API calls. Refer to the following documentation that will guide you in using the query service.

https://developer.adobe.com/experience-platform-apis/references/query-service/ 

https://experienceleague.adobe.com/docs/experience-platform/query/api/getting-started.html?lang=en 

You can export the queried data from AEP to CSV file. 

There are two ways to save the results of a query when using a PSQL client. You can use the Copy To command or create a statement using the following format:

SELECT column1, column2
FROM <table_name>
\g <table_name>.out

Query Service internally applies a limit of 50,000 rows unless an explicit limit is specified externally. There is no limit on data size, but there is a query timeout limit of 10 minutes from an interactive session. 

Refer to the this link that provides answers to frequently asked questions about Query Service 

https://experienceleague.adobe.com/docs/experience-platform/query/troubleshooting-guide.html?lang=en 

Hope this helps.