GraphQL Queries

GraphQL queries are used to fetch data via the project API.

Archie Core’s GraphQL engine auto-generates queries as part of the GraphQL schema based on your project tables. All project tables can be queried through the project endpoint.

Auto-generated queries

Whenever a table is added to a project, two GraphQL query operations are auto-generated for the table. They are:

• tableNameById(…) - Accepts id and any unique value as an argument to retrieve a single record from the database.
• tableNames(…) - Accepts filter, sort, skip, after, before, first, groupBy, and last to retrieve a list of curated records while supporting pagination, relational-filtering, sorting, and more.

List Arguments

Archie Core responds to the following query arguments when specified for lists.

• filter: Filters records based on field values.
• orderBy: [DEPRECIATING - Use sort]
• sort: Sort order configuration. Can be single- or multi- field sorting.
• first: Limit query to first N records. Default and maximum value is 5000.
• last: Return N last records from the result.
• groupBy: Groups the returned records by the values of a specific field. This is typically used in conjunction with aggregation functions (like count or sum) to analyze data based on categories.
• after: Return records after specified ID. Used for cursor-based pagination.
• before: Return records before specified ID. Used for cursor-based pagination.
• skip: Skip N records from the result.