HubSpot Bulk Read

Overview

You can use this Snap to retrieve data objects in bulk from HubSpot. Learn more: HubSpot APIs.

Overview.png

Snap Type

The HubSpot Bulk Read Snap is a Read-type Snap.

Prerequisites

None.

Support for Ultra Pipelines

Works in Ultra Pipelines

Known Issues

None.

Limitations

None.

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: 0

  • Max: 1

  • Mapper Snap

  • Copy Snap

  • CSV Snap

A document containing details with which to identify the data object(s) to retrieve from HubSpot.

Output

Document

 

  • Min: 1

  • Max: 1

  • HubSpot Update

  • CSV Formatter + File Writer

  • Copy

A document that contains details of the data object(s) retrieved from HubSpot.

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 value: HubSpot Bulk Read

Example: Bulk Read Company Details

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 ValueV3
Example: V4

Dropdown list

Select the version of the API to use for the pipeline.

Category*

Default Value: N/A
Example: CRM

String/Suggestion

Select the application from which to retrieve the data objects.

Entity*

 

Default Value: N/A
Example: Companies

String/Suggestion

Select the data object to read. Alternatively, click the Suggestion icon to select the entity.

Action*

 

Default Value: N/A
Example: Read a batch of Companies

String/Suggestion

Select the read-action to perform on the selected entity. 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: http://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: http://company.id

String

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

Optional Parameters

Specify the optional parameters for a specific action.

Parameter

Default Value: N/A
Example: properties

String/Suggestion

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

Value

Default Value: N/A
Example: name

String

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

Connection timeout*

Default Value: 30
Example: 30

Integer

Specify the time in seconds for the Snap to wait before terminating the request because of a failure to establish a connection to the target service.

Number of retries*

Default Value: 0
Example: 4

Integer

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

Retry interval (seconds)*

Default Value: 0
Example: 10

Integer

Specify the number of seconds for which the Snap must wait before attempting recovery from a network failure.

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

Retrieving details of a batch of companies

The following example pipeline demonstrates how to retrieve the details of a batch of companies from HubSpot.

Bulk_Read_pipeline.png

Configure the JSON generator Snap to provide the company name as an input to retrieve the specific company details. On validation, the JSON output is displayed in the output preview.

01_Input.png

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

02_Create_read.png

On validation of the Snap, the JSON input fields are mapped to the HubSpot entity's fields as shown below:

03_Create output.png

Finally, the output from the Mapper Snap is passed on to the HubSpot Bulk Read Snap. The HubSpot Bulk Read Snap is configured with the Company Entity and Read a Batch of Companies action.

04_Bulk create.png

On validating the HubSpot Bulk Read Snap, the Snap retrieves the details of a batch of companies as shown below:

05_Bulk 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_Read.slp

Apr 23, 2024 by Irfan Khan

See Also

 

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