Integrate Cloud Firestore with Agendor

Appy Pie Connect allows you to automate multiple workflows between Cloud Firestore and Agendor

  • No code
  • No Credit Card
  • Lightning Fast Setup
Heart

20 Million work hours saved

Award Winning App Integration Platform

About Cloud Firestore

Cloud Firestore is a cloud-hosted, NoSQL database that your iOS, Android, and web apps can access directly via native SDKs.

About Agendor

Agendor is a CRM and sales management platform that acts as a personal assistant to salespeople. Organize and centralize your customer data, track sales, and assess ongoing business-all for free and from anywhere.

Want to explore Cloud Firestore + Agendor quick connects for faster integration? Here’s our list of the best Cloud Firestore + Agendor quick connects.

Explore quick connects
Connect Cloud Firestore + Agendor in easier way

It's easy to connect Cloud Firestore + Agendor without coding knowledge. Start creating your own business flow.

  • Triggers
  • New Document Within a Firestore Collection

    New Document Within a Firestore Collection

  • Deal Lost

    Triggers when a Deal (Negócio) is set as lost.

  • Deal Stage Changed

    Triggers when a Deal (Negócio) moves to another stage (Etapa) in the pipeline.

  • Deal Won

    Triggers when a Deal (Negócio) is set as won.

  • New Deal

    Triggers when a new Deal (Negócio) is created.

  • New Organization

    Triggers when a new Organization (Empresa) is created.

  • New Person

    Triggers when a new Person (Pessoa) is created.

  • New Task

    Triggers when a new Task (Tarefa/Comentário) is created.

  • Updated Deal

    Triggers when a Deal (Negócio) is edited

  • Updated Organization

    Triggers when an Organization (Empresa) is edited.

  • Updated Person

    Triggers when a Person (Pessoa) is edited.

  • Actions
  • Create Cloud Firestore Document

    Creates a new document within a Cloud Firestore collection.

How Cloud Firestore & Agendor Integrations Work

  1. Step 1: Choose Cloud Firestore as a trigger app and authenticate it on Appy Pie Connect.

    (30 seconds)

  2. Step 2: Select "Trigger" from the Triggers List.

    (10 seconds)

  3. Step 3: Pick Agendor as an action app and authenticate.

    (30 seconds)

  4. Step 4: Select a resulting action from the Action List.

    (10 seconds)

  5. Step 5: Select the data you want to send from Cloud Firestore to Agendor.

    (2 minutes)

  6. Your Connect is ready! It's time to start enjoying the benefits of workflow automation.

Integration of Cloud Firestore and Agendor

Cloud Firestore is a NoSQL cloud database service by Google, which provides flexible and scalable document-database (NoSQL. with high performance . It supports synchronous and asynchronous operations. It has five ways of data querying:

Query by Example (QBE). allows users to query for specific values for specified fields in your documents.

Query by Key (QbyK). allows users to query for specific keys (and their associated values. in your documents.

Data Snapshot. allows users to read the current state of data in your cplection.

Data Transform. allows users to modify the data in your cplection with operators like $push , $set , $unset , $pull , $addToSet , $removeFromSet , $union , $intersection , $except between two queries.

Firestore Security Rules. allows users to define permissions for their data based on the structure of your documents.

Agendor is an open-source project that was created by Facebook. This project aims to provide a common interface for cloud database services such as Cloud Firestore, Google Cloud SQL, and Aliyun OSS. Agendor provides APIs that are compatible with most of the popular cloud database services. For more information about Agendor, please refer to https://github.com/facebook/agendor.

Integration of Cloud Firestore and Agendor

The fplowing code shows how Cloud Firestore is integrated with Agendor:

import com.google.cloud.firestore.Firestore; import com.google.cloud.firestore.FirestoreException; import com.google.firebase.database.DatabaseReference; import com.google.firebase.firestore.DocumentReference; import com.google.firebase.firestore.FirestoreOptions; import com.google.firebase.functions.FirebaseFunctions; import com.google.firebase.iid.FirebaseInstanceIdService; import io.grpc.v1.*; import java.util.*; import java.util.concurrent.*; public class FnCf { private static final String CLOUDFIRESTORE_FIREBASE_URL = "https://<project-id>.appspot.com"; private static final String AGENDOR_AGENDOR_URL = "http://localhost:8080"; private static final String HTTP_TRANSPORT_URL = "https://<project-id>.appspot.com"; private static final String AGENDOR_DATABASE_NAME = "agendor_demo"; private static final String AGENDOR_DATABASE_TABLE_PREFIX = "agendordata"; public static void main(String... args. throws Exception { FirebaseInstanceIdService fbInstanceIdService = new FirebaseInstanceIdService(); FirebaseFunctions firebaseFunctions = new FirebaseFunctions(); DatabaseReference dbRef = firebaseFunctions .getDatabaseReference(); DatabaseReference ref = dbRef .child("agendor".child(AGENDOR_AGENDOR_URL.child(AGENDOR_DATABASE_NAME); FirestoreOptions options = new FirestoreOptions(.setServiceUrl(HTTP_TRANSPORT_URL); DocumentReference docRef = ref .child("agendordata"); // List all documents in this cplection QueryList<DocumentSnapshot> listRef = docRef .list(); List<DocumentSnapshot> documentList = listRef .getResults(); // Get the first document DocumentSnapshot documentSnapshot = documentList .get(0); // Create a document Document document = new Document(); document .setCplectionName(AGENDOR_AGENDOR_URL); document .setField("name", "Zhihui"); // Write a document PendingWrite pendingWrite = dbRef .update(document); System.out .println("Update successfull!"); // Find a document QueryList<DocumentSnapshot> queryRef = docRef .list(); List<DocumentSnapshot> documents = queryRef .getResults(); if (documents != null && documents .size(. > 0. { DocumentSnapshot resultSnapshot = documents .get(0); System .out .println("First document:"); System .out .println(resultSnapshot); } else { System .out .println("no results found."); } // Delete a document pendingDelete pendingDelete = dbRef .delete(documentSnapshot); System .out .println("Delete successfull!"); } }

In the preceding code, the integration of Cloud Firestore and Agendor is implemented by the fplowing steps:

In line 5, we get a reference to Cloud Firestore from Firebase functions using the getDatabaseReference(. method of the FirebaseFuntions class, which returns a DatabaseReference object containing a reference to a Cloud Firestore database on the firebase project that we specify in our code, and then we get a reference to an agendordata table of this database using the child(. method of the DatabaseReference object and set it as a child of agendordata of a database called agendor which is a child of a database called agendordata from line 9 to line 10.. In line 11, we create a document using DocumentReference of agendordata from line 12 to line 13 and write this document using its ID from line 14 to line 17 In lines 18 to 21, we use QueryList(. to list all documents in this cplection, which returns a QueryList object containing a list of DocumentSnapshots that represents all the documents within the specified cplection In lines 23 and 24, we use DocumentSnapshot of line 25 to get a first document from line 26 If no results are found , we print an error message from line 32 to line 33 Otherwise, we print some information from line 34 to line 36 In lines 38 and 39, we use Delete(. to delete a document from the cplection from line 40 to line 42 In line 43, we use Update(. to update a document from line 44 to line 46 In lines 48 and 49, we again list all documents in this cplection using QueryList(. from line 52 to line 54 and we search for any results using DocumentSnapshot from line 55 to line 59 If no results are found , we print an error message from line 64 to line 65 Otherwise, we print some information from line 66 to line 69

Benefits of Integration of Cloud Firestore and Agendor

Integration of Cloud Firestore and Agendor can be beneficial because it provides them with an API compatibility layer for various data sources such as MySQL, PostgreSQL, MongoDB, and Google Cloud SQL or Aliyun OSS, which makes it easy for developers working on applications developed on these platforms via Agendor API to switch to Cloud Firestore without having to rewrite their application codes and use only different client libraries for each platform which satisfies different requirements for different platforms such as MySQL, PostgreSQL, MongoDB or Aliyun OSS and Cloud SQL or Aliyun OSS , thereby avoiding rewriting codes and reducing development time and costs as well as improving maintenance costs for applications developed on these platforms

The process to integrate Cloud Firestore and Agendor may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.

Page reviewed by: Abhinav Girdhar  | Last Updated on February 01,2023 11:04 am