Skip to main content

Other connectors

Besides REST APIs, the APIs section can connect to several non-SQL datasources. Each is configured with its connection details, after which you build queries that your apps can use.

Firestore​

Connect to Google Cloud Firestore to read and write documents in your collections. Provide your project credentials, then create queries to fetch, filter, create, and update documents.

MongoDB​

Connect to a MongoDB database using a connection string. The MongoDB connector is the most fully-featured of the non-SQL connectors and supports most common collection operations.

SettingDescription
Connection stringThe MongoDB URI, including host, credentials and options.
DatabaseThe database to query.

Building a query​

Each MongoDB query targets a collection and a query type, then takes the relevant arguments (filter, document(s), update, options) as JSON. The available query types are:

CategoryOperations
Readfind, findOne, findOneAndUpdate, count, distinct
CreateinsertOne, insertMany
UpdateupdateOne, updateMany
DeletedeleteOne, deleteMany
Aggregateaggregation pipelines (json or pipeline)

Arguments are written as JSON and support bindings. Bindings in a query are placeholders that are filled in later from the app — you define them in the query's Data section and supply their values in the Design section.

For example, in the Data section a find filter might reference an owner binding:

{ "status": "active", "owner": {{ owner }} }

You then declare the owner binding (with an optional default value) alongside the query:

BindingDefault value
owner(optional)

When you bind this query to a component in the Design section, you map owner to a value that only exists in the app context — such as the logged-in end user:

{{ Current User._id }}

This separation keeps the query reusable while still letting it filter or update documents based on user input or app state.

Redis​

Connect to a Redis instance to use it as a fast key/value store or cache. Configure the host, port, and password, then create queries that run Redis commands.

SettingDescription
Host / PortThe Redis server address.
PasswordThe Redis auth password, if set.

MinIO​

MinIO is an S3-compatible object store. Connect it to read and write objects in buckets. MinIO also powers the file upload component, letting end users upload files directly to a bucket from your apps.

SettingDescription
EndpointThe MinIO server URL.
Access key / Secret keyCredentials for the bucket.
RegionThe bucket region, if applicable.

Using queries​

Like REST queries, queries against these connectors can include bindings so they respond to user input and app state, and each query can be protected with a role.