Skip to main content
Pradeep-Jaiswal
Level 6
Oct 22, 2025 7:40 PM UTC
Solved

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

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Pradeep-Jaiswal
Pradeep-JaiswalAccepted solution
Level 6
Oct 30, 2025 10:50 AM UTC

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.

3 replies

Devyendar
User Group Leader
User Group Leader
Oct 22, 2025 9:44 PM UTC

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

Translate
Pradeep-Jaiswal
Level 6
Oct 22, 2025 10:42 PM UTC

No, this API doesnt return the result of SQL query

Translate
Pradeep-Jaiswal
Pradeep-JaiswalAuthorAccepted solution
Level 6
Oct 30, 2025 10:50 AM UTC

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.

Translate