Query Service - Query Execution Fails via API

Forum|Forum|3 years ago
March 13, 2023
1 reply
1182 views

Hi,

I've a simple query which I'm executing from Query Service UI & API.

Query Service UI execution return records successfully where as API query execution fails. I can see status of both the execution in Query Service log.

I'm executing the same query from UI & API.

Query : Select * FROM <table_Name>

API Payload :

{

"dbName": "<sandbox>:cjm_qsaccel",

"sql": "SELECT * FROM <table_Name>",

"name": "API Test Query6",

"description": "API Test Query Description4"

}

Is there anything which I'm missing in query execution via API?

Thanks.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Anil_Umachigi

Employee

@vikashyadav Curious what API endpoint are you using? Also selecting all columns ( SELECT *) via API may probably push the limits of api response based on how much data you have.

Have you tried limiting to few columns and limit the rows returned?

Anil