Using HubSpot CRM with IBM App Connect Enterprise
HubSpot CRM is a customer relationship management (CRM) platform that you can use to facilitate the integration of sales and marketing teams, drive sales enablement, increase ROI, and improve the marketing approach to generate more qualified leads.
About this task
IBM® App Connect Enterprise communicates synchronously with HubSpot CRM through the HubSpot CRM Request node, which is available on Windows, AIX, and Linux® systems.
- Companies
- Create, retrieve, update, or delete companies; create, retrieve, or delete associations with companies; or retrieve companies by filters or by ID
- Contacts
- Create, retrieve, update, or delete contacts; create, retrieve, or delete associations with contacts; or retrieve contacts by filters or by ID
- Deals
- Create, retrieve, update, or delete deals; create, retrieve, or delete associations with deals; or retrieve deals by filters or by ID
- Line items
- Create, retrieve, update, or delete line items; add a line item to a deal; delete association with line item; retrieve line item associated with a deal; or retrieve line items by filters or by ID
- Owners
- Retrieve all owners
- Products
- Create, retrieve, update, or delete products; or retrieve products by filters or by ID
For more information about configuring the HubSpot CRM Request node, see HubSpot CRM Request node.
Procedure
- In the IBM App Connect Enterprise Toolkit, create a flow containing a HubSpot CRM Request node.
- Select the HubSpot CRM Request node in the flow to show the node properties in the editor.
- On the Basic tab, click Launch Connector
Discovery. A panel is displayed in which you specify the name of the policy project and vault details to be used during connector discovery.
- Specify the details of the policy project and vault to be
used during connector discovery:
- In the Policy Project field, specify the policy project that is
used to store the policies that are created during connector discovery. Alternatively, you can create a new policy project by clicking New and then specifying the name of the new policy project. Then click Finish.
- Specify the vault to be used during connector discovery. By default, credentials that
are used during connector discovery are stored in an external directory vault, which is
an App Connect Enterprise vault that can be used by any integration server.
Alternatively, you can store the credentials in an integration server vault, which is created in the
integration server's work directory and can be used only by that specific integration server. To specify the vault to be used for storing the credentials, complete the steps in the Using the Connector Discovery wizard section of one of the following topics:
- In the Vault key field, enter the vault key that is used to access the credentials stored in the vault. The vault key must be at least 8 characters in length.
- Optional: By default, the specified vault location and vault key are saved as preferences in the Toolkit so that the values are preset when you launch Connector Discovery. If you do not want the preferences to be saved, deselect Save in vault preferences.
- In the Policy Project field, specify the policy project that is
used to store the policies that are created during connector discovery.
- Click Launch Discovery to start the Connector Discovery wizard for
the HubSpot CRM connector. The Connector Discovery window is displayed. If existing HubSpot CRM connections (accounts) are available, a list of those connections is displayed. If there are no existing connections, the status of the HubSpot CRM connector is shown as
Not connected
.- If one or more HubSpot CRM connections (accounts)
are available, complete the following steps:
- Select the connection (account) that you want to use by clicking it.
- Click the required object type and then select the action that you want to perform on the object. For example, to retrieve companies from HubSpot CRM, click Companies and then Retrieve all companies.
- If there are no existing connections (accounts), complete the following steps:
- Click the required object type and then select the action that you want to perform on that object. For example, to retrieve companies from HubSpot CRM, click Companies and then Retrieve all companies.
- Click Connect to display a menu from which you must select one of the
following authorization methods:
- Provide credentials for App Connect to use (BASIC OAUTH)
- Provide credentials for App Connect to use (BEARER TOKEN)
- If you selected Provide credentials for App Connect to use (BASIC OAUTH) as
the authorization method, enter the following details:
- Application client ID: The unique identifier of your HubSpot client application. Get the application client ID from your HubSpot Apps dashboard in your developer account.
- Application client secret: The application client secret for the unique application client ID. Get the application client secret from your HubSpot Apps dashboard in your developer account.
- Access token: The access token that is generated from the application client ID and client secret.
- Refresh token: The refresh token that is generated from the application client ID and client secret.
- API URL: (Optional) Specify the HubSpot CRM API
server URL if you want to override the default URL. By default, the URL is set to
https://api.hubapi.com
.
- If you selected Provide credentials for App Connect to use (BEARER TOKEN) as
the authorization method, enter the following details:
- Access token: The access token that is generated from the private app.
For more information about accessing or generating these connection details, see How to use IBM App Connect with SuiteHubspot CRM in the IBM App Connect Enterprise as a Service documentation.
- Click Connect.
- If one or more HubSpot CRM connections (accounts)
are available, complete the following steps:
- Set the required connector properties in the wizard.
For retrieve or update actions, you can add conditions for the retrieval of the data by clicking Add condition and then selecting the property that you want to filter on.
If you add conditions for retrieve or update actions, you can optionally use condition filtering to refine the conditions that are applied. To use condition filtering, exit the Connector Discovery wizard by clicking the Close button (X) and then complete the instructions in Using condition filtering.
For create actions, you can optionally use advanced mode. In the default edit view for an action, some applications have fields that are hidden because they are not required for general use cases. For more advanced use cases, you can switch to advanced mode editing, which provides extra capabilities for editing flows. To use advanced mode, exit the Connector Discovery wizard by clicking the Close button (X) and then complete the instructions in Using advanced mode.
You can also set properties that specify the maximum number of records to retrieve and the action to be taken if that limit is exceeded.
- When you have finished specifying the properties in the Connector Discovery wizard, click
Save. The credentials that are used for connecting to HubSpot CRM are stored in the vault, and the other connection details are saved in the policy. For more information, see HubSpot CRM policy. The values of the properties that you set in the wizard are returned to the HubSpot CRM Request node in the IBM App Connect Enterprise Toolkit.
- When you have finished discovery and saved the property values, exit the Connector Discovery wizard by clicking the X in the upper-right corner of the window or by pressing Alt+F4.
- Return to editing the HubSpot CRM Request node in
the IBM App Connect
Enterprise Toolkit. The connector properties that were set in the Connector Discovery wizard (in step 6) are now visible on the HubSpot CRM Request node in the property editor. The Basic tab shows the values of the Action and Object properties that you set in the wizard. For example, if you selected Companies > Retrieve all companies in the wizard, the following properties will be visible on the Basic tab of the node:
- Action -
RETRIEVEALL
- Object -
getCrmV3ObjectsCompanies_model
The values of the Action and Object properties are displayed in read-only format. If you want to change these values, you can do so by clicking Launch Connector Discovery again and setting new values in the Connector Discovery wizard.
The Schema base name property specifies the base name of the schema files that describe the format of the request and response messages that are sent to and received from the HubSpot CRM connector. The schema base name is set automatically the first time that you run discovery for the node, and it is based on the current flow name and node name. If you set this property manually before running discovery for the first time, the value that you set will be used. If you rename the schemas after discovery, you must edit this property so that it matches the schema base name that is used by the renamed schemas in the project. If you change this property after discovery, you must either rename the schema names to match or run discovery again.
Depending on the action that was selected during discovery, the Connector Discovery wizard generates either a request schema and a response schema, or a response schema only. A request schema is generated only if the selected action and object require a request message. The generated request schema is used for validation of the request message. If the action was
RETRIEVE
orDELETE
, only the response schema is returned by the connector.The generated schema files are added to the project and can be used by a Mapping node for transforming input or output data. The full filename of the schema is derived from the schema base name (such as
gen/MyMessageFlow.bSpotCRM.HubSpot_CRM_Request
), suffixed with either response.schema.json or request.schema.json. You can open the schema by clicking Open request schema or Open response schema. - Action -
- Check that the property settings on the HubSpot CRM Request node are correct and then save the message flow.
- On the Connection tab of the HubSpot CRM Request node, the Policy
property shows the name of the policy that contains the details of the security identity to be used
for the connection. The policy has a type of
HubSpot CRM
.For more information, see HubSpot CRM policy. - Optional: Set the Timeout property on the Connection tab to specify the time (in seconds) that the node waits for HubSpot CRM to process the operation.
- The Filter tab of the HubSpot CRM Request node contains properties that control the way
in which the message flow selects data. The initial values of these properties are taken from the
property values that were set for the HubSpot CRM
connector in the Connector Discovery wizard, including the filter options properties and any
conditions that were specified (as described in step 6). If you subsequently
return to the Connector Discovery wizard and change the values of any properties (by adding new
conditions, for example) those updates are reflected in the properties set on the node.
The Filter Options properties control which objects are to be operated upon when the HubSpot CRM Request node executes. The Filter Limit properties control the maximum number of items to be retrieved and the action to be taken if the limit is exceeded.
You can modify the values by clicking Edit next to the value that you want to modify in the Filter Options section, and by changing the property values that have been set in the Filter Limit section.
The property values can be either text values or ESQL or XPATH expressions that are resolved from the contents of the message that is passed to the HubSpot CRM Request node as it executes.
- On the Request tab, set the Data location property to specify the location in the incoming message tree that contains the object data to be created in HubSpot CRM. This data forms the request that is sent from the HubSpot CRM Request node to HubSpot CRM.
- On the Result tab, set the Output data location property to specify the location in the output message tree that will contain the data of the record that is created in HubSpot CRM.
- By default, request messages are validated against the request schema that was generated during connector discovery. You can turn off request validation or change the validation settings by using the Validation properties of the HubSpot CRM Request node.
- Save the message flow.