|
Klassiska filtyper är inte längre tillgängliga för användning från och med januari 2021. Du kan överföra dina klassiska filer eller ladda ner en PDF. Läs mer

Error when I execute a query using wdata API

Besvarat
Begär demo

Hi, I'm sending a POST https://h.app.wdesk.com/s/wdata/prep/api/v1/queryresult

with request body

{
    "isExplain": true,
    "parameters": {
        "FiscalYear": "2024"
    },
    "queryId": "HGHGHGHffshgasjdhasdhgjhgasd"
}
but query is not taking parameter value, it is ignored
I tried also with same result
{
  "queryDto": {
    "parameters": [
      {
        "label": "Fiscal Year",
        "name": "FiscalYear",
        "type": "integer",
        "value": "2024"
      }
    ]
  },
  "queryId": "KJHKFJHKSJDHFKJHDF"
}
 
 
0

Kommentarer

1 kommentar

Datum Röster
  • Jeff Hickey

    Hi ERNESTO ARIEL MUNOZ,

    What is the error you are getting? The first thing to do is to run the Query in Wdata and verify that the FiscalYear parameter is configured correctly in the Query and that the expected results are generated. Make sure to save any unsaved changes.

    Assuming the Query is functioning as expected in Wdata, without seeing the error, my guess is you're getting an error because you have set "isExplain" to true. If this is true, the Query is explained and not executed. Set this to false or remove it from the body of the request (example below) on your next test.

    {
        "queryId": "HGHGHGHffshgasjdhasdhgjhgasd",
        "parameters":{
            "FiscalYear":"2024"
        }
    }
    0

Du måste logga in om du vill lämna en kommentar.