API to query "select * from datasetName" or any other complex query to get the SQL response in the result ?

Question

is there an API to query "select * from datasetName" or any other complex query to get the response of SQL result ?

Pradeep-Jaiswal · Accepted Answer

Further investigation shows that this API is only to submit the query and view the status of query, but doesnt return the actual result. To grt the actual results, we need to use external databse connection such as postgress.

Devyendar · Answer

Yes @pradeep-jaiswal, Adobe Experience Platform provides an API for executing SQL queries (including SELECT * FROM datasetName or more complex joins, filters, and aggregations) through the Query Service API.

Here is a detailed document on Query Service API: https://experienceleague.adobe.com/en/docs/experience-platform/query/api/queries

Sign up

Login with SSO

Login to the community

Login with SSO