Nick Ashcroft 7/19/2019 3:47:54 AM hi Mike, the filterin in the API uses the same format as when filtering in a view.
To get a better understanding, make a new view with the filter you want in the 'matching' section of the view. for example select 'MachineId' from the left dropdown then 'is' in the middle then 'xxx' on the right. Press 'save' and then edit the view again. Click the 'custom formula' radio button and you will see what the formula syntax is for your filter (something like [MachineId]='xxx'). Copy this formula.
go to the 'REST API Playground' from the database setup, run the 'describe app' option, select your target table in the 'method'/'table dropdown the insert the formula into the 'filter' field.
you will then see the filter added into the url with the correct encoding (but may well work without encoding, depending on what tools you are using)
good luck, nick
|