HubSpot Bulk Update

Overview

You can use this Snap to update data objects in bulk in the HubSpot platform.  Learn more: HubSpot APIs.

Overview.png

Snap Type

The HubSpot Snap is a Write-type Snap.

Prerequisites

None.

Support for Ultra Pipelines  

Works in Ultra Pipelines

Limitations

None.

Known Issues

The HubSpot Bulk Update Snap can update only 100 records in a single execution.

Snap Views

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input 

Document

  • Min: 1

  • Max: 1

  • HubSpot Read

  • Mapper

  • Copy

A document that contains the details to identify the entity to update along with the information to update.

Output

Document

  • Min: 0

  • Max: 1

  • JSON Formatter + File Writer

  • Mapper

  • Copy

  • HubSpot Read

A document with the details of the updated entity.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:

  • Stop Pipeline Execution: Stops the current Pipeline execution if the Snap encounters an error.

  • Discard Error Data and Continue: Ignores the error, discards that record, and continues with the remaining records.

  • Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Snap Settings

  • Asterisk ( * ): Indicates a mandatory field.

  • Suggestion icon (): Indicates a list that is dynamically populated based on the configuration.

  • Expression icon ( ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ( ): Indicates that you can add fields in the fieldset.

  • Remove icon ( ): Indicates that you can remove fields from the fieldset.

  • Upload icon ( ): Indicates that you can upload files.

Field Name

Field Type

Description

Field Name

Field Type

Description

Label*

 

Default ValueHubSpot Bulk Update

ExampleBulk Update Companies

String

Specify a name for the Snap.  If you have more than one of the same Snaps in the pipeline, you can modify this and create a unique name.

 

API Version*

 

Default Value: V3

Example: V4

Dropdown list

Select the API version to use for the pipeline.

 

Category*

 

Default Value: N/A

ExampleCRM

String/Suggestion

Select the application in which to update the data objects.

Entity*

 

Default Value: N/A

ExampleCompanies

String/Suggestion

Select the data object to update.

Action*

 

Default Value: N/A

ExampleUpdate a batch of Companies

String/Suggestion

Specify the action to perform by the Snap. Clicking the Suggestion icon lists the supported actions. 

Required Parameters

Use this field set to enable the Snap to perform a specific action.

Parameter*

 

Default Value: N/A
Example: company.id

String/Suggestion

Specify the names of the required parameters. Clicking the Suggestion icon lists the supported actions. 

Value*

 

Default Value:  N/A
Example: 1884

String

Specify the values for the required parameters. The data type of this field depends on the specified parameter.

Connection timeout

 

Default Value30

Example30

Integer

Specify the connection timeout duration in seconds.

Number of retries*

 

Default Value: 0

Example: 3

Integer

Specify the maximum number of reconnections to make if a connection failure or timeout occurs.

Retry interval (seconds)*

 

Default Value: 0

Example: 15

Integer

Specify the time interval between connection attempts.

Retry policy

 

Default Value: Connection errors
Example: Connection and API limit exceeded errors (429)

Dropdown list

Choose the retry policy for connection and error responses. The available options are:

  • Connection errors: Select this option when the client fails to establish a secure connection to the server.

  • Connection and API limit exceeded errors (429): Select this option when the 10-second or daily limit is exceeded.

Snap Execution

Default ValueExecute only
Example: Validate & Execute

Dropdown list

Select one of the following three modes in which the Snap executes:

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.

  • Execute only: Performs full execution of the Snap during pipeline execution without generating preview data.

  • Disabled: Disables the Snap and all Snaps that are downstream from it.

Troubleshooting

Error

Reason

Resolution

Error

Reason

Resolution

Missing required parameters.

There is a required parameter that was not provided.

Verify whether all required parameters are configured.

You have reached your ten secondly rolling limit.

There are too many requests to REST endpoint.

Select Connection and API limit exceeded (429) errors in the Retry Policy and adjust the values for “Number of retries” and “Retry interval”.

You have reached your daily limit.

There are too many requests to REST endpoint.

The maximum number of daily requests has been reached, and no further requests can be made until it resets. For more information refer to API Meters.

Examples

Updating a batch of companies

The following example pipeline demonstrates how to update the batch of companies in HubSpot.

Bulk_update_pipeline.png

Configure the JSON generator Snap to provide the details to be updated for the specific companies. On validation, you can view the JSON output in the output preview.

01_Input.png

Configure the Mapper Snap to map the output details from JSON generator Snap to the corresponding fields in HubSpot.

Bulk_update_pipeline_mapping_table.png

On validation, the JSON input fields are mapped to the HubSpot entity fields as follows:

Bulk_update_pipeline_mapper_output.png

Finally, configure the HubSpot Bulk update Snap with the Company Entity and Update a Batch of Companies action. 

04_Bulk update.png

On validation, the HubSpot Bulk Update Snap updates a batch of companies with the specified details as follows:

bulk update Output .png

 

Downloads

  1. Download and import the Pipeline into SnapLogic® Platform.

  2. Configure Snap accounts, as applicable.

  3. Provide pipeline parameters, as applicable.

 

  File Modified

File Hubspot_Bulk_Update.slp

Apr 23, 2024 by Irfan Khan

See Also

 

Have feedback? Email helpdesk@rojoconsultancy.com © Rojo Consultancy