Skip to Content

SAP Cloud Platform Open Connectors simplifies and accelerates connectivity to third-party cloud applications. It provides robust, feature rich, pre-built connectors to an extensible library of over 150 of the most popular third-party cloud applications. Customers can easily build API compositions across the different connectors and can wrap multiple operations in a single request.

With common resource (common objects), you can transform fields provided by your service providers to a single, normalized resource. This allows you to take advantage of our one-to-many integration approach where you write to a single common object to integrate the transformed resources from your various service providers. In this blog, we would showcase a simplified common resources for companies harmonizing the response from customers or accounts resources from two different third-party applications.

For more blogs on SAP Cloud Platform Open Connectors , ref the blog series.

Prerequisites

Note:- In this blog, we have used a third-party application from the CRM hubs which is HubSpot and Financial Hubs which is QuickBooks Online. You are free to use any other third-party application of your choice for this exercise.

In the blog Simplified connectivity to third-party financial hubs application, detailed steps to connect to QuickBooks Online connectors has been covered and in the blog Simplified connectivity to third-party CRM hubs application, detailed steps to connect to HubSpot tenant has been covered. These blog can be followed to create an authenticated connections to your QuickBooks Online tenant and HubSpot using SAP Cloud Platform Open Connectors.

Creating Common Resources in SAP Cloud Platform Open Connectors

In this section, steps to create a common resources named mycompanies with field properties like name, city, country, postalCode, phone has been covered. This mycompanies resource would then be mapped to the responses returned from QuickBooks online and HubSpot connectors via SAP Cloud Platform Open Connectors. SAP Cloud Platform Open Connectors is available for test, explore and try out in SAP Cloud Platform trial. If you have not enabled SAP Cloud Platform Open Connectors in your trial tenant, refer this blog to enable it.

 

  • From the services tab, search and select Open Connectors tile and click on the Go to Service link.

 

  • You would be navigated to SAP Cloud Platform Open Connectors Home or Landing page.

 

 

  • Click on the Common Resources tab to create a common resource. In this blog, the common resources for mapping the companies entity from QuickBooks Online and HubSpot is covered and therefore the name of the common resources was given as mycompanies.

  • The mycompanies resources has field or properties as described in the table below.

Field Name

Display Name

city

City

country

Country

postalCode

Postal Code

phone

Primary Phone number

name

Company Name

 

  • To add fields, click on the + button next to the Account Level Fields and then enter the value for Field Name and Display Name. After all the properties are added , click on the Save button to persist the changes.

 

  • With this common resources named mycompanies would be created. The next step would be to map this common resources to the actual response from HubSpot or QuickBooks online.

 

Mapping Common Resources to pre-built connectors

In this section steps to map the newly created common resources to pre-built connectors of HubSpot and QuickBooks online is covered.

  • For this click on the Create New Transformation tile.

 

  • In the Select a connector instance dialog, select the connector instances created for myhubspot and then click on the + button.

 

 

  • In case of HubSpot, the name of the resources is companies and therefore select + button next to the companies resource.

 

  • Once the resources is selected , the field like city from mycompanies field can be mapped to the actual response from the HubSpot companies resources.  In this blog, the fields were mapped as provided in the table below.  In case you are using a different third-party application then change the mapped property name as provided by the selected third-party application.

Field Name

Mapped Property Name

city

properties.city

country

properties.country

postalCode

properties.zip

Phone

properties.phone

Name

properties.zip

 

  • In the Advanced Settings pane, toggle the switch to Remove Unmapped Fields and click on the Save button to persist the changes.

 

 

  • Click on the Save button to persist all the changes done on the mapping so far.
  • The mapping of the mycompanies to the HubSpot connector can be tested from SAP Cloud Platform Open Connectors for this click on the try out  or play button .

 

  • Both the transformed response and raw response can be viewed in the test pane.

 

 

  • Click on Transformation to create a new mapping to QuickBooks Online.

 

  • Next the mapping to QuickBooks online would be created and for this click on the Create New Transformation tile.

 

  • In the Select a connector instance dialog, select the connector instances created for myquickbooks and then click on the + button.
  • QuickBooks online has the resource named customer which would be used for mapping into the mycompanies common resources. Click on the + button to select the customer resource.

 

  • Once the resources is selected , the field like city from mycompanies field can be mapped to the actual response from the QuickBooks online customer resources.  In this blog, the fields were mapped as provided in the table below.  In case you are using a different third-party application then change the mapped property name as provided by the selected third-party application.

Field Name

Mapped Property Name

city

shipAddr.city

country

shipAddr.country

postalCode

shiipAddr.postalCode

Phone

primaryPhone.freeFormNumber

Name

displayName

 

  • As before the un-mapped fields can be removed and for this click on setings button and from the Advanced Settings pane, toggle the switch to Remove Unmapped Fields and click on the Save button to persist the changes.

 

  • Click on the Save button to persist all the changes done on the mapping so far.
  • The mapping of the mycompanies to the QuickBooks online connector can be tested from SAP Cloud Platform Open Connectors for this click on the try out  or play button .

  • Both the transformed response and raw response can be viewed in the test pane.

 

With this we have successfully created a common resource named mycompanies with fields like city, country, phone,name and then mapped it to the response from third-party application like QuickBooks online and HubSpot.

More blogs on SAP Cloud Platform Open Connectors available in SAP Community.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply