queryService run output in the API | Community
Skip to main content
Pradeep-Jaiswal
Level 5
February 24, 2026
Question

queryService run output in the API

  • February 24, 2026
  • 3 replies
  • 25 views

we have APIs to submit the sql query using queryService API. The other APIs then allows to check the status of queryService run. https://platform.adobe.io/data/foundation/query/queries

But how do we get the result of that sql query using the API method ?

3 replies

DavidRoss91
Community Advisor
Community Advisor
February 26, 2026

hi ​@Pradeep-Jaiswal  are you trying to use this from like a reporting perspective? Just trying to understand the ask.

Sukrity_Wadhwa
Community Manager
Community Manager
March 9, 2026

Hi ​@Pradeep-Jaiswal,

Could you please share a bit more detail so ​@DavidRoss91 can better assist with your question?

Thanks!

Sukrity Wadhwa
Level 3
March 11, 2026

According to the documentation, after obtaining your query ID, there is no API available to execute the query on demand. You can only schedule the query and monitor its execution status, but you cannot directly trigger it through an API call.
It is worth mentioning that all data is stored in datasets, and query results are usually placed in temporary datasets.
If you wish to access the data via the API, you should explore how to read datasets using the API. You can schedule your query to load the data into datasets, and then retrieve the data from those datasets using the Dataset API, or use the postgres client or the aepp python wrapper. 

Level 2
March 15, 2026

You can submit and monitor queries through Adobe Experience Platform Query Service APIs, but the results are not returned directly through the same endpoint that runs the query.

When a query finishes, the results are usually written to a dataset in Adobe Experience Platform. To access the output, you typically specify a target dataset in the query (for example using CREATE TABLE AS SELECT or INSERT INTO). Once the query completes, you can retrieve the resulting data by querying that dataset again or exporting it through the platform’s dataset APIs.

Another option is to check the query execution details using the Query Service API to identify the output dataset or result location, then read the data from that dataset using the data access APIs.

Adobe’s Query Service API documentation explains the workflow for submitting and managing queries here:
https://platform.adobe.io/data/foundation/query/queries