Try your hand at analyzing royal sentiment in Dataiku DSS! Learn more

API test query failing when using parameters (SQL)

Level 1
API test query failing when using parameters (SQL)

I'm working on an API runs an SQL query.



The query runs fine when I use hard coded values but when I try to use the same values as parameters the I get this error:

"Failed: Query failed: The column index is out of range: 1, number of columns: 0."



The query is a simple:

SELECT * FROM table WHERE column = '?' 



Using the parameters:

{

    "column": "value"

}

0 Kudos
2 Replies
Dataiker
Dataiker
Hi,

Did you declare in the query screen that your endpoint takes a parameter named "column" ?
0 Kudos
Level 1
Author
Yes, the query expects a parameter and I've checked that the names are consistent between what's expected and the test query.
0 Kudos