How would you enter a URL string if I wanted to filter only certain items? For example, if I entered the following URL: rollbase.com/rest/api/selectQuery?query=SELECT status FROM client&sessionId=rest-3039620713623997054 I would get all the clients with all statuses listed. Now, Lets say I want to filter and view only the "SALE" and "CLOSED" statuses on these clients, how would I enter the URL in that case?
Hi Bob,
The REST API selectQuery call expects a URL encoded value as query parameter, so your above example would not work as shown. I recommend using the JavaScript encodeURIComponent() method to encode the whole query parameter before making it part of the URL. You can do a Google search on encodeURIComponent to find out more about this native JS function.
The query parameter supports all types of queries that the Rollbase Query API supports. For more details on the Query API, see the section called "Query API" in Chapter 6 of Rollbase In Action:
https://www.rollbase.com/rollbaseinaction.shtml
Hope this helps,
Matt