0 votes

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"


1 Answer

0 votes

Did you declare in the query screen that your endpoint takes a parameter named "column" ?
Yes, the query expects a parameter and I've checked that the names are consistent between what's expected and the test query.
1,319 questions
1,339 answers
11,888 users

©Dataiku 2012-2018 - Privacy Policy