Query option $apply

Use the $apply query option transform returned records in the response. The $apply query option allows you to combine aggregate (sum, min, max, average, countdistinct, as), nest, compute, addnested, join, outerjoin, groupby, 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=groupby((Category),aggregate("Unit Price" with sum as "Sum of Unit Price"))