Get results from a query
post
/_/baas-services/database/{project_id}/v1/runQuery
This service executes various types of queries on the database collections or duality views and returns the resulting documents. It supports multiple query types including fetching a single document by path, simple queries with conditions and ordering, collection group queries, join queries on relational models, aggregation queries, and queries on duality views. Specify the query type in the request body. The 'limit' parameter controls the maximum number of results returned (0 for no limit). The version 1 endpoint applies security rules such as Row Level Security. Authentication is required via Bearer token or AppKey. The output will differ based on relational and collection tables.
Request
Path Parameters
-
project_id(required):
Specifies a unique Project ID, associated with the fusabase Project
Header Parameters
-
x-transaction(required):
Used for facilitating transactions
Response
200 Response
Returns list of documents, OID and document Data
401 Response
Authentication Failure
Default Response
Error