HubSpot Contact to SAP Business One Business Partner Contact
First published on: 08/10/2023/6:54 pm
Workflow Description
In this workflow, a scheduled job will call HubSpot at regular intervals (configurable) to retrieve company contacts created or updated since the last job run.
Only contacts associated with companies will be imported.
The workflow will check if the contact exists in SAP Business One.
If it exists, it will be updated. Otherwise, if it's associated with a business partner in SAP Business One, a new contact will be created for that business partner.
After creating a new business partner contact, the sap_internal_code field in HubSpot will be updated with the new business partner contact ID.
Workflow Diagram
Mapping
The following mapping will be applied:
|
HubSpot Contact |
SAP Business One Business Partner Contact |
Comments / Hardcoded Values |
|---|---|---|
|
vid |
OCRD.CardCode |
|
|
properties/ firestname+lastname |
OCPR.Name |
|
|
properties/address |
OCPR.Address |
|
|
properties/phone |
OCPR.Phone1 |
|
|
properties/email |
OCPR.E_Mail |
|
|
properties/firstname |
OCPR.FirstName |
|
|
properties/lastname |
OCPR.LastName |
|
|
id |
OCPR. U_V33SB_HubSpotContactId |
|
Assumptions
- Custom fields identified in the mappings will be created in HubSpot.
|
Last modified: 08/30/2024/1:44 pm |