topic Re: How do you get the result from queryExecutionClient.queryExecute()? in Developer Q&A Forum

How do you get the result from queryExecutionClient.queryExecute()?

r_weber — Thu, 11 Jan 2024 17:05:29 GMT

What is wrong with this code? It's async, but shouldn't there be something in result (I verfified that the executed query returns data)

async function getEntityName(entityId) { console.log(entityId) const eType = entityId.split('-')[0]; console.log(eType); const query = 'fetch dt.entity.'+eType+' | filter id=="'+entityId+'"'; console.log(query) const result = await queryExecutionClient.queryExecute({ body: { query, } }); console.log(result) }

"result" just shows:

{ result: undefined, ttlSeconds: 399, progress: undefined, requestToken: "jghsd2LVTPmQDTkWIl4QlQ==", state: "RUNNING" }

Re: How do you get the result from queryExecutionClient.queryExecute()?

sinisa_zubic — Thu, 11 Jan 2024 17:55:26 GMT

Hi @r_weber

If you don't add further props to the body, then this is expected behavior. you start a query and get as a result a request token you can use to poll for the result.

But as part of body, you can add another property requestTimeoutMilliseconds , where you would wait x milliseconds for the query to be executed. That should do the trick in your case

const result = await queryExecutionClient.queryExecute({ body: { query, requestTimeoutMilliseconds: 30000 } });

An easier way to query data is ou use the useDqlQuery hook, https://developer.dynatrace.com/develop/data/query-and-visualize/

Best,
Sini

Re: How do you get the result from queryExecutionClient.queryExecute()?

r_weber — Thu, 11 Jan 2024 18:39:12 GMT

Thanks @sinisa_zubic ,

the explicit addition of the requestTimeout should be documented and used in the examples!
This seems to work, now...

Btw. I started with useDqlQuery hook, but since I saw the same behavior I gave the executionClient a try. I will try the hook again...lets see what happens.

Re: How do you get the result from queryExecutionClient.queryExecute()?

r_weber — Thu, 11 Jan 2024 18:43:43 GMT

The version with useDqlQuery crashes on me:

async function getEntityName(entityId) { console.log(entityId) const eType = entityId.split('-')[0]; console.log(eType); const query = 'fetch dt.entity.'+eType+' | filter id=="'+entityId+'"'; console.log(query) /*const result = await queryExecutionClient.queryExecute({ body: { query, requestTimeoutMilliseconds: 30000 } }); */ const result = useDqlQuery({ body: { query, }, }); console.log(result) }

An error occurred: {"code": 541, "message": "Execution crashed.", "details": {"type": "BAD_REQUEST", "message": "<stripped secret anyhow::Error>"}}

Re: How do you get the result from queryExecutionClient.queryExecute()?

imsingh — Fri, 12 Jan 2024 12:53:03 GMT

@r_weber are you using the hooks in app functions? Hooks can only be used in your react code. For all other places besides your react code, I'd suggest using `queryExecutionClient` instead.

Re: How do you get the result from queryExecutionClient.queryExecute()?

r_weber — Sun, 14 Jan 2024 19:45:32 GMT

OK, that wasn't clear. I tried to use it in a workflow.