Running a Query from the sandbox using Python API Call | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

V
Vikashyadav
Level 3
February 27, 2023

Hi @gugun ,

Following query service end point submit your query to AEP and return query id with status code "202 Submitted". Upon successful submission, your query went through multiple phases like "In-Progress/Success/Failed/Killed/Timeout".

1] Query Submission end point (No need to trigger, it automatically queued for execution)

https://platform.adobe.io/data/foundation/query/queries

payload : 

{
        "dbName": "<dbname>",
        "sql": "<Query>",
        "name": "Test Query",
        "description": "Test Query Description"
 }
Response :

 


2] Check Status of Query with Query Id after some interval

End Point : https://<domain>/data/foundation/query/queries/c055faa5-87be-44ec-a240-44e572296aa3

Iteration Response1 : 

 

Iteration 2 Response: In my case, query got failed and it return "Failed" status.

 

 if you're accessing these api from Python, it would be good to allow some time to finish the query execution to get the query result. or you can also use polling feature. Hope this helps:)

Thanks.

    Terms & ConditionsAccessibility statement

    Loading footer...