Datamart : Using queries

Vitalth · ‎10-10-2022

Hi,

I tried to use Queries in datamart in order to use it on Web API executeQueries.
If I create a query in my Datamart, this one has a name. (I don't how to change the name but it is another problem).

In POST API I try (in my payload) :

{

"queries": [

{

"query": "EVALUATE VALUES('{My Query Name}')"

}

]

}

But the answer is :

{

"error": {

...,

"value": "Query (1, 17) Cannot find table 'SQL query 1'."

...

}

Do you know if is it possible to use Queries in the Web API and if yes how to use it.

Thanks for your support.

Vitalth · ‎10-10-2022

Thanks for your answer and support

I already saw the last link you gave me and that's why I wrote my post. I found that very interesting and I wanted to see if we can combine features described in second links with theses in the third links. I didn't know the second links you give me. (I saw the possibility to create some query in datamart but I try myself without documentation). So the second link was very helpfull for me for other questions. Thanks.
But I still don't know how to combine creation of query in datamart and execute them in REST API ExecuteQuery