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

null
    • Ninox developper
    • Jacques_TUR
    • 2 yrs ago
    • Reported - view

    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 \".

      • Care
      • 2 yrs ago
      • Reported - view

      Thank you a lot. I solved that few moment ago by the advise which i received from too

      ```
      '(select Klant_Client where Skinvision_Customer_Id = "FX0000000108_412").Id'
      ```

      Now, my question is why I've the table ID itself appended to the ID ?

      current output is

      ```
      ['LB13213']
      ```

      While am expecting:

      ```
      ['13213']
      ```

      • Ninox developper
      • Jacques_TUR
      • 2 yrs ago
      • Reported - view

       to retrieve the IDRecord number, write : 

      (select Customer).number(id)

      to obtain IDTable+IDRecord write : 

      (select Customer).string(id)
    • Fred
    • 2 yrs ago
    • Reported - view
     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.

Login to reply

Content aside

  • 2 yrs agoLast active
  • 4Replies
  • 154Views
  • 3 Following