New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

API test query failing when using parameters (SQL)

_Chris
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
Clément_Stenac
Dataiker
Dataiker
Hi,

Did you declare in the query screen that your endpoint takes a parameter named "column" ?
0 Kudos
_Chris
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
Labels (2)
A banner prompting to get Dataiku DSS