0
Ninox API issue
Below am able to query the records
But while trying to use `where` am getting `null` why ?
```
{
"query" : "(select 'Klant_Client' where 'Skinvision_Customer_Id' = 'FX0000000108_412').Skinvision_Customer_Id"
}
```
4 replies
-
The code you send must first be tested in your application's console to ensure that it works correctly. Try it and I think you'll get an error in the where clause. I think FX0000000000108_421 should be surrounded by " and not '.
To do this, use "" or \".
-
said:
Now, my question is why I've the table ID itself appended to the ID ? current output is ``` ['LB13213'] ```That is the default Ninox response to a select. Within Ninox if you do a select it returns values as nid which includes the table Id.
Content aside
- 1 yr agoLast active
- 4Replies
- 132Views
-
3
Following