API OData filtering (startswith and substringof)
Creation date: 26/03/2026 16:06
Updated: 06/05/2026 13:02
Question:
Answer:
I have an API retrieving data for the OData connection and I was just trying to filter the data being returned but it still returns all results.
Answer:
The proper way to apply the
filters should be:
- For startswith and endswith, it should be (Project,'ABC') - this was used
the other way around from the screenshots
- For substringof, it should be ('ABC', Project) being 'ABC' the string you want to filter by. It is different to the endswith and startswith commands which have 'project'
first.