Apps GraphQL API¶
To avoid collisions in tables with the same name of different apps, the objects are created using the
appId as prefix.
For example, if you create a
customerSupport app, which has the
customers table, the system will create the
Queries by PK¶
For each of the GraphQL objects, a
by_pk object is also created. This is useful for selecting an object by primary key.
Additionally, for each app object, both from the Smartmate GraphQL API and the Apps GraphQL API, an
aggregate object is created.
This object allows the following aggregations on your queries:
count: Count the records.
stddev: Sample standard deviation.
stddev_samp: Sample standard deviation. Same as
stddev_pop: Population standard deviation.
variance: Sample variance (square of the sample standard deviation).
var_samp: Sample variance (square of the sample standard deviation). Same as
var_pop: Population variance (square of the population standard deviation).
max: Max value.
min: Min value.
Aggregate objects also allow to include in the same request the data of the
nodes that were used for the aggregation.
While Smartmate is in beta, the aggregate object is available for all plans, but eventually it will be available only on the enterprise plan.