Query option $apply

Use the $apply query option transform returned records in the response. The $apply query option allows you to combine aggregate, nest, compute, addnested, join, outerjoin, and concat tranformation functions together.

Component Description

HTTP method

GET

URL

https://host/fmi/odata/version/database-name/table-name?$apply=functions

host – FileMaker Cloud or FileMaker Server host name

version – the OData version, always v4

database-name – the name of the hosted database

table-name - the name of the table

functions - the functions used to transform the returned data

Example: /fmi/odata/v4/Inventory/Products?$apply=concat(topcount(2,Unit Cost),aggregate(Unit Cost))