Solved
AEP Queries using API
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?
Community Advisor and Adobe Champion
November 29, 2022
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.