How do I integrate my third-party solution with MeasureSquare?

How do I integrate my third-party solution with MeasureSquare?


This article is for any client who wishes to integrate or otherwise create an automated progress to transfer Measure Square project data into third-party systems such as Salesforce or Microsoft Dynamics 365. Generally, we recommend using our Cloud API, which has a variety of endpoints you can use to achieve desired functionality. You do not necessarily have to use the API to automate the transfer of M2 project data. A few use cases and workflows will be discussed below.


Basic Flow
This diagram displays one way your third-party application exchange data with Measure Square, using the M2 Cloud API. You do not have to follow this workflow, since it is entirely dependent on your requirements.
Salesforce Integration

Case #1


This is specifically for the case where you only intend to pull Measure Square project data into Salesforce to populate the fields of an Opportunity (deal in progress). The project will be manually created by an estimator, then synced to M2 Cloud; there will be no push requests from Salesforce. Once the project has been created, the estimator may enter his/her unique project ID in Salesforce to associate the project with the opportunity. The project-opportunity association will be stored by the client.

Steps
1. The user will create an Opportunity in Salesforce. A unique Opportunity ID will also be generated

2. Once created, Salesforce will 

    1. Send a POST request (creating new project) to M2 Cloud, and receiving new project ID in return

    2. Store the opportunity ID-M2 Project ID relationship


3. Estimator syncs, downloading new project to machine (image shown)




4. Estimator saves new progress on project, then syncs to M2 Cloud (See image from previous step)

5. Salesforce calls GET endpoint to retrieve latest updates to project



Extracting the Project ID
If you find it extremely useful, we can add a project ID to the Project Info form, which users can manually copy & paste into Microsoft 365. Typically, project ID is not visible to users.


Microsoft Dynamics 365 Integration



Case #1

You intend to only import Measure Square data into Dynamics 365, meaning that push requests will not be sent to M2. You choose to use the project report, an Excel spreadsheet, as the container for the data you want to import; this report is manually created at the click of a button in the Measure Square application. In Dynamics 365, you may set it to import the spreadsheet and access its data by searching for certain column names. Measure Square allows you to modify the spreadsheet (also called a bid template) by adding/modifying column names so that they match whatever naming convention you set in Dynamics 365.

Export the M2 XML report file to find out what data are available to you.


Steps

  1. Export Excel file from M2


  2. Import Excel file into MS 365


Modifying the spreadsheet for the client

We can work with the client to finalize what columns names should appear in the spreadsheet, as well as what additional data should be retrieved from the M2 XML report.


For best results, team should communicate internally to create a concrete format, column names, and so forth in the form of a detailed mock-up before the M2 team begins work. This will save time on both sides by creating the clear output desired.

Once the requirements are finalized and delivered, additional work may require additional fees.



Client modifies own spreadsheet

To make things easier for our clients, you have the ability to use your own development resources to make changes to the Excel spreadsheet. This allows them to make additional changes to appearance or macros, which are not important for integration. If the client has their own M2 Cloud group (included with your Measure Square account), they may update the spreadsheet in their online account, therefore updating the bid template for all other users in the group.




    • Related Articles

    • The MeasureSquare Cloud API Integration Reference

      In this article, you will learn the basics of integrating with MeasureSquare's Cloud API, as well as various integration workflows. MeasureSquare's Cloud API allows third-party applications to leverage MeasureSquare's project data, such as diagrams, ...

    • How to connect Microsoft Outlook to MeasureSquare CRM

      In this article, we will show you how to connect your Microsoft Outlook account to MeasureSquare CRM. You can connect or integrate your Outlook email account, contacts, and calendar to your Profile in MeasureSquare CRM Additionally, you may reach out ...

    • Commonly Used API Endpoints in MeasureSquare

      In this article, you will learn how which endpoints are commonly used and what they are used for When integrating Measure Square's Cloud API with your third-party system, you may be wondering where to start. To give you an idea of which endpoints you ...

    • How do I access my API key?

      This article applies to the MeasureSquare Cloud. This article will show you how to access your API Key via the Cloud at cloud.measuresquare.com. If you do not already have a group set up in Measure Square Cloud, then to begin you must contact Measure ...

    • How to use the Measure Square Catalog API with your own ERP system (as an office/operations manager)

      In this article, we will go over a use case of how to use the MeasureSquare Cloud Catalog API to integrate with their ERP system. As an office manager involved with your company's daily operations, you will learn the steps and benefits of using this ...