Cloud Firestore
ToolJet can connect to Cloud Firestore databases to read and write data.
Connection
ToolJet connects to your Cloud Firestore using JSON key of your GCP service account. Get your service account key as JSON from GCP console. For generating a new key, check out Firestore's official documentation.
Once you have the key, open it in a text editor and copy the contents. Paste the contents in the Private key field of the Firestore data source modal.
Click on Test connection button to verify if the key is valid. Click on Save button to save the data source.
Querying Firestore
Click on +
button of the query manager at the bottom panel of the editor and select the database added in the previous step as the data source.
Select the operation that you want to perform on Firestore and click Save to save the query.
Query results can be transformed using transformations. Read our transformations documentation to see how: link
Supported operations
- Get document
- Query collection
- Add Document to Collection
- Update document
- Set document
- Bulk update using document id
- Delete document
Get document
Use this operation to get the data in a document.
Required parameters:
- Path: Enter the path of the document. Path format:
collection name/document id
. ex:books/23e2wsds32
Query collection
Use this operation to query all the documents in a collection. Check firestore doc here.
Required parameters:
- Path: Enter the name of the collection to be queried. Example:
books