Firestore

Cloud Firestore is a flexible, scalable database for mobile, web, and server development from Firebase and Google Cloud.

Setup

To get started, add a project through the Firebase console and create a Firestore database:
https://firebase.google.com/docs/firestore/quickstart

Connect

You will need to use a Service Account in order to be able to access your Firestore via the Budibase connector.

To get the required credentials, within the Firebase console, click on the cog icon beside Project Overview and then select the Service accounts tab.

Next, click Generate new private key button. This will download a json file that will contain the credentials you need to connect.

In particular:

  • client_email
  • private_key
  • project_id

Whenever you add a new Firestore Data SourceData Source - Budibase is built up of multiple data sources, this can be the internal Budibase DB, but can also be your remote MySQL, PostgreSQL, REST or one of the many other sources available in Budibase. you will be prompted to enter these fields:

 
With your Firestore config saved, you will now be able to add a query.

Create query

  1. Select the 'Create' function
  2. Enter a collection to save the new document to
  3. Enter the JSON payload into the query box
  4. The newly created document will be returned with a randomly generated unique id

 

Bindings

You can also use bindings like so:

 

Read query

For these examples, there is a collection named test with five documents representing various fruit and veg.
Select the 'Read' function.

 

Get all documents from a collection

  1. Enter the name of the collection into the collection field
  2. Leave the filter fields blank

 

Using filter fields

These map to the parameters of the where clause

  1. Enter the field name: 'color'
  2. Select the 'equals' filter comparison
  3. Enter the filter value: 'yellow'

The full list of supported filter comparisons can be found here

 

Bindings

You can also use bindings like so:

 

Update query

Select the 'Update' function.

 

Update by id

  1. Enter the name of the collection into the collection field
  2. Leave the filter fields blank
  3. In the query box, enter the id to match on, and the field values to update to

 

Delete query

Select the 'Delete' function.

 

Delete by id

  1. Enter the name of the collection into the collection field
  2. Leave the filter fields blank
  3. In the query box, enter the id to match on

 
As with other data sources, you can Transform any query results.


Did this page help you?