Filter format URL for API call
I m trying to do server side filter so Ninox only returns the relevant records, however I am having trouble figuring out the format. I have the proper ids for team, db and table and I want to search and return only records where Status=Booked, and Trip=107 for example. I am hoping someone can give me an example UTL to make request into Ninox?
2 replies
-
You can use the Ninox API Sandbox to try different API calls : https://forum.ninox.com/t/g9yp9yp/api-sandbox-powered-by-swagger#topic-top
Your URL with Query could look like this: https://api.ninox.com/v1/teams/6nRBvk7KDysdHMPJw/databases/lwjhkothxe05/query?query=(select Clients where text(Status)="Booked" and Trip=764).'First Name'
But if you need to send this you first need to use the function urlEncode() to convert this url to:
https://api.ninox.com/v1/teams/6nRBvk7KDysdHMPJw/databases/lwjhkothxe05/query?query=%28select%20Clients%20where%20text%28Status%29%3D%22Booked%22%20and%20Trip%3D764%29.%27First%20Name%27 -
Worked great thank you!
Content aside
- yesterdayLast active
- 2Replies
- 23Views
-
2
Following