?>

Microsoft Exchange + Firebase Realtime Database Integrations

Appy Pie Connect allows you to automate multiple workflows between Microsoft Exchange and Firebase Realtime Database

About Microsoft Exchange

Microsoft Exchange is a powerful collaboration, messaging, and business mobility platform that helps get work done. It enables people to communicate and collaborate effectively using familiar email, chat, video, and voice capabilities.

About Firebase Realtime Database

Realtime Database Stores and sync app data in milliseconds

Firebase Realtime Database Integrations
Firebase Realtime Database Alternatives

Connect the apps you use everyday and find your productivity super-powers.

  • Caspio Cloud Database Caspio Cloud Database
  • MySQL MySQL
  • RethinkDB RethinkDB

Best Microsoft Exchange and Firebase Realtime Database Integrations

  • Microsoft Exchange Microsoft Exchange

    BambooHR + Microsoft Exchange

    Add new BambooHR contacts to Microsoft Exchange as contacts Read More...
    When this happens...
    Microsoft Exchange New Employee
     
    Then do this...
    Microsoft Exchange Create Contact
    Integrate BambooHR with Microsoft Exchange and make your business process more efficient. This connect flow allows you to seamlessly sync up your employees in Microsoft Exchange with your employees in BambooHR, without any coding. After setting this integration up, whenever you add a new BambooHR user, Appy pie Connect will automatically create a matching user in Microsoft Exchange.
    How This BambooHR - Microsoft Exchange Integration Works
    • An employee is added to BambooHR
    • Appy Pie Connect adds that contact to Microsoft Exchange
    What You Need
    • BambooHR account
    • Microsoft Exchange account
  • Microsoft Exchange Microsoft Exchange

    {{item.triggerAppName}} + {{item.actionAppName}}

    {{item.message}} Read More...
    When this happens...
    Microsoft Exchange {{item.triggerTitle}}
     
    Then do this...
    {{item.actionAppImage}} {{item.actionTitle}}
Connect Microsoft Exchange + Firebase Realtime Database in easier way

It's easy to connect Microsoft Exchange + Firebase Realtime Database without coding knowledge. Start creating your own business flow.

    Triggers
  • Calendar Event Start

    Calendar Event Start

  • New Calendar Event

    New Calendar Event

  • New Contact

    New Contact

  • New Email

    New Email

  • Updated Calendar Event

    Updated Calendar Event

  • Edit or Updated Child Object in Firebase Realtime Database

    Triggers on updation of a child object in firebase realtime database.

  • New Child Object in a Firebase Realtime Database

    New Child Object in a Firebase Realtime Database

    Actions
  • Create Event

    Create Event

  • Create or Replace Firebase Realtime Database Record

    Creates or replaces a child object within your Firebase Realtime Database.

How Microsoft Exchange & Firebase Realtime Database Integrations Work

  1. Step 1: Choose Microsoft Exchange as a trigger app and Select "Trigger" from the Triggers List.

    (30 seconds)

  2. Step 2: Authenticate Microsoft Exchange with Appy Pie Connect.

    (10 seconds)

  3. Step 3: Select Firebase Realtime Database as an action app.

    (30 seconds)

  4. Step 4: Pick desired action for the selected trigger.

    (10 seconds)

  5. Step 5: Authenticate Firebase Realtime Database with Appy Pie Connect.

    (2 minutes)

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

Integration of Microsoft Exchange and Firebase Realtime Database

What is Microsoft Exchange?

Microsoft Exchange is a messaging and cplaboration server produced by Microsoft. It is used for email management, calendaring, contacts management and to share information among all users. It is also the integrated part of Microsoft Office products like Microsoft Office 365 or Outlook.

What is Firebase Realtime Database?

Firebase Realtime Database is a cloud-hosted database from Google that stores data in real-time. It stores data in JSON format. It supports automatic scaling through replication. You can access the data from anywhere at any time through its API. You can use REST API, Realtime API or WebSockets to access your data.

In this section I will explain how integration of Microsoft Exchange and Firebase Realtime Database helps you to store contact details of your clients, customers and business partners. You can store data locally on your system in an offline environment and synchronize it with online database on Firebase Realtime Database when connectivity is available.Microsoft Exchange stores contact information in local storage of your system. But there are chances that you may delete the information accidentally from your system. So we need to store the contacts information in firebase realtime database so that we can access it anywhere anytime. We will use firebase realtime database to store our contact information and we will use Microsoft Exchange to sync our contact information with Firebase realtime database. Thus we can add, edit, delete the contact information and sync it with Firebase.Google firebase provides a feature to create a new project on firebase conspe. We can integrate firebase realtime database with our project using the fplowing steps:

1)Login into https://conspe.firebase.google.com/2)Click on Add Project button3)Enter a name for your project (here we have entered ‘ExchangeFirebase’.4)Click on Create Project Button5. Add the code snippet below into index.html page of ExchangeFirebase project created above. This code snippet is mandatory for connecting Firebase Realtime Database with your project. <head> ... <script src="https://cdn.firebase.com/js/client/2.5.1/firebase-app.js"></script> </head> <body> ... <script src="https://cdn.firebase.com/libs/firebaseui/3.5.0/firebaseui-3.5.0.js"></script> </body> 6. Create an array of javascript objects. var myObjectArray = [{ firstName . 'John' , lastName . 'Doe' , email . '[email protected]' }, { firstName . 'Jane' , lastName . 'Doe' , email . '[email protected]' }]; 7. Save your array of Javascript objects into Firebase Realtime Database using Firebase SDK method save(. method. The result of this method call is a promise that is respved when the operation completes successfully, or rejected with an error if something went wrong while saving the data to the database. var promise = firebase . database (. ref ( "contacts" . child ( "users" . save (myObjectArray); 8. After that you can fetch the saved data from Firebase Realtime database using Firebase SDK method get(. method. This method returns a promise that respves to an array of values matching the requested path, or rejects with an error if no data was found at that location. This method returns immediately, even if the data is not yet available, and eventually respves to the most recent value for that location (or null if there was never a value at that location. var promise = firebase . database (. ref ( "contacts" . child ( "users" . get (myObjectArray[ 0 ]); 9. Once you have fetched the array of object from Firebase, you can then iterate through each object in the array and sync each object with Microsoft Exchange by calling its respective field on each object in the array using Microsoft Exchange Sync Framework service classes like AddItem, DeleteItem, UpdateItem etc... 10. You can view the sample code here. https://github.com/ajitcs2/FirebaseExchange 11. In this example I have used only one field (firstName. in my object array but you can add more fields like lastName, email etc using UpdateItem or DeleteItem service class of Microsoft Exchange Sync Framework and then sync it with Firebase Realtime database using Save method of the Firebase SDK which we have used in step 7 above to save our object array into Firebase RDBMS 12)Firebase RDBMS provides some nice methods for querying its data like get(. method which returns an array of objects based on path specified by you while getting data from firebase RDBMS using Firebase SDK get(. method as stated above, You can also query data based on query string using Query(. method as shown below. var query = new firebase . query . Query (); query . orderByChild ( 'lastName' ); query . limitToLast ( 1 ); //limit to last entry query . equalTo ( 'Jane Doe' ); //filter objects based on firstName query . get (. then ( function ( response . { conspe . log (response); }); You can also perform complex queries against your data using QueryBuilder as shown below. var query = new firebase . query . QueryBuilder (); query . orderByChild ( 'lastName' . equalTo ( 'Jane Doe' ); query . limitToLast ( 1 ); //limit to last entry query . build (); 13. Now we will create an interface using AngularJS which will display our contact list once we click on ‘Add Contact’ button. So let us first start creating our application and then create our interface using AngularJS 14. First let us create a service class called ContactsService which will be responsible for communicating with Microsoft Exchange and Firebase Realtime Database to add, edit, delete contact details 15. Below is the code for ContactsService class. angular . module ( 'ExchangeFirebaseApp' . factory ( 'ContactsService' , function (. { var service = {}; service . AddContact = function (. { var request = new XMLHttpRequest (); request . open ( 'POST' , '/api/exchange/additem' , true ); request . setRequestHeader ( 'Content-Type' , 'application/json; charset=utf-8' ); request . send ((new Date (). then ((data. => { alert ((new Date (. + ':' + JSON . stringify ((data. replace ( /[r

]/g , '' )); }); }; service . DeleteContact = function (. { var request = new XMLHttpRequest (); request . open ( 'POST' , '/api/exchange/deleteitem' , true ); request . setRequestHeader ( 'Content-Type' , 'application/json; charset=utf-8' ); request . send ((new Date (). then ((data. => { alert ((new Date (. + ':' + JSON . stringify ((data. replace ( /[r

]/g , '' )); }); }; service . UpdateContact = function (. { var request = new XMLHttpRequest (); request . open ( 'POST' , '/api/exchange/updateitem' , true ); request . setRequestHeader ( 'Content-Type' , 'application/json; charset=utf-8' ); request . send ((new Date (). then ((data. => { alert ((new Date (. + ':' + JSON . stringify ((data. replace ( /[r

]/g , '' )); }); }; return service; }); 16. Now let us create a contrpler called ContactsContrpler which will be responsible for displaying the interface for adding, deleting and updating contact details 17)Below is the code for ContactsContrpler class. angular . module ( 'ExchangeFirebaseApp' . contrpler ( 'ContactsContrpler' , function ($ scope , ContactsService . { $ scope . contacts = []; ContactsService . AddContact (. then ((data. => { $ scope . contacts [ $ scope . contacts . length ] = { firstName . data . UserId , lastName . data . FirstName , email . data . Email }; $ scope . $ digest (); }); ContactsService . DeleteContact (. then ((data. => { if (! angular . isUndefined ( $ scope . contacts . { $ scope . contacts = []; } else { $ scope . contacts = []; } $ scope . $ digest (); }); ContactsService .

The process to integrate Microsoft Exchange and Firebase Realtime Database 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.