Skip to main content
Version: 2.70.0-Beta 🚧

Cloud Firestore

ToolJet can connect to Cloud Firestore databases to read and write data.

Connection​

To establish a connection with the Cloud Firestore data source, you can either click on the + Add new Data source button located on the query panel or navigate to the Data Sources page from the ToolJet dashboard and choose Cloud Firestore as the data source.

ToolJet requires the following to connect to your BigQuery:

  • Private key

For generating a private key check out Firestore's official documentation.

firestore add ds

Querying Firestore​

  1. Click on + Add button of the query manager at the bottom panel of the editor.
  2. Select the Cloud Firestore datasource added in previous step.
  3. Select the desired operation from the dropdown and enter the required parameters.
  4. Click on the Preview button to preview the output or Click on the Run button to trigger the query.
firestore QUERY
tip

Query results can be transformed using transformations. Read our transformations documentation to see how: link

Supported Operations​

Get Document​

Use this operation to get the data in a document.

Required Parameters​

  • Path
firestore get

Query Collection​

Use this operation to query all the documents in a collection. Check firestore doc here.

Required Parameters​

  • Path

Optional parameters​

  • Order type
  • Limit
  • Field
  • Operator
  • Value
firestore collection

Add Document to Collection​

Use this operation for creating a new document in a collection.

Required Parameters​

  • Collection
  • Body.

Example​

{
"Author": "Shubh",
"id": 5
}
firestore document

Update Document​

Use this operation for updating the existing document in a collection. Also, it only updates fields if they exist, but doesn't replace an entire object like set operation.

Required Parameters​

  • Path
  • Body

Example​

{
"Author": "Shubhendra",
"id": 3
}
firestore update

Set Document​

This operation replaces your chosen object with the value that you provide. So if your object has 5 fields, and you use Set operation and pass object with 3 fields, it will now have 3 fields.

Required Parameters​

  • Path
  • Body

Example​

{
"Author": "Shefewfbh",
"id": 9
}
firestore set

Bulk Update Using Document ID​

Use this operation for bulk updating documents.

Required Parameters​

  • Collection
  • Key for document ID
  • Records
firestore bulk

Delete Document​

Use this operation for deleting a document in a collection.

Required Parameters​

  • Path
firestore delete

Transforming Firestore Query Result for Table Widget​

The Firestore query result is in the form of object so we’ll need to transform it into array.

return data = Array(data)