If I’m working with SQL data and a related table. How do I notate fields from the related table in the Filter, Group or Order parameters to the api URL?
I figured out I can specify the related fields by adding “&RelationshipName.fields=field1,field2&” to the api url, even if there isn’t a box for this in the Api Docs UI. Unfortunately, the same thing doesn’t work for RelationshipName.filter, RelationshipName.order, etc.
Thanks,
Andy