...
Use this Snap to retrieve data objects from HubSpot. Learn more about HubSpot APIs from HubSpot Documentation.
Prerequisites
None.
...
Field Name | Field Type | Description | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Label Default Value: HubSpot Read | String |
| |||||||||
Entity
| String | Required. Select the data object to read. | |||||||||
Action
| String | Required. Select the read-action to perform on the entity selected above. Click to see the list of supported actions. | |||||||||
Required parameters | Use this field set to enable the Snap to perform a specific action. | ||||||||||
Parameter
| String | Specify the names of the required parameters. Click to see the list of supported parameters. | |||||||||
Value
| Multiple | Specify the values of the required parameters. The data type of this field depends on the specified parameter. | |||||||||
Optional parameters | Specify the optional parameters for a specific action. Specify each parameter in a separate row. | ||||||||||
Parameter
| String | Specify the names of the optional parameters. Click to see the list of supported parameters. | |||||||||
Value Default Value: N/A | Multiple | Specify the values for optional parameters. The data type of this field depends on the specified parameter. | |||||||||
Filter parameters | This property enables you to filter the results from the API response based on logical operations.
| ||||||||||
Parameter
| String | Specify the system parameter $filter fields to be included in the output. | |||||||||
Operator
| String | Specify the comparison operator for the system parameter $filter. | |||||||||
Value
| Multiple | Enter the values of the specified input $filter fields. The data type of this field depends on the specified parameter. | |||||||||
Order records by | Select the order of the specified parameters. The order types to be selected are either ascending or descending.
| ||||||||||
Parameter
| String | Enter the parameter for which to specify the order. | |||||||||
Value Default Value: ASCENDING | String | Select one of the following orders in which to sort the specified parameter:
| |||||||||
Advanced options | Use this section of Snap Settings to specify options to control the number of records in the output. This section comprises the following fields:
| ||||||||||
Output entry offset
| Integer | Specify the number of records to skip during the read operation. Leave it empty so as not to skip any records. | |||||||||
Output entry limit
| Integer | Select the number of records to fetch in the read operation. Leave it empty to retrieve the default number of records, | |||||||||
Automatic pagination
| Checkbox | Select this checkbox to enable the Snap to return all the records in the output. By default, the HubSpot Read Snap returns the maximum number of records per page from HubSpot based on the entity. The remaining records, if any, display in the subsequent pages. If you deselect the Automatic pagination checkbox, the Snap returns only the records of the first page in the output. Learn more about Usage of Automatic pagination. | |||||||||
Connection timeout
| Integer | Required. Enter the connection timeout duration of seconds. | |||||||||
Number of retries
| Integer | Required. Enter the maximum number of re-connection attempts in case of a failure or timeout. | |||||||||
Retry interval (seconds)
| Integer | Required. Enter the interval in seconds between reconnections attemptsreconnection attempts. | |||||||||
Retry policy Default Value: Connection errors | Dropdown list | Choose the retry policy for connection and error responses. The available options are:
| |||||||||
Snap Execution
| String | Indicates how the Snap must be executed. Available options are:
|
Troubleshooting
Error | Reason | Resolution | Missing required parameters. | There is a required parameter that was not provided. | Verify whether all required parameters are configured.||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
| ||||||||||||||||||||||||||||||||||||
|
|
| ||||||||||||||||||||||||||||||||||||
|
|
|
Additional Information
Usage of Automatic pagination
...
There are two different date input:
Milliseconds.
Example: Date 1420772453000. This value represents the date Fri Jan 09 2015 04:00:53 GMT+0100
Dates.
Example: Date 20150109. This value represents the date Fri Jan 09 2015 00:00:00
The maximum of records returned is entity-specific.
Some entities of HubSpot have required parameters to be used. Without which, a 404 exception is thrown by HubSpot. This exception indicates the mandatory fields required.
Example
...
Retrieve Company Data
We want to retrieve records of the Company entity in HubSpot. This Pipeline demonstrates how we can use the HubSpot Read Snap to accomplish this task.
...
We configure the HubSpot Read Snap to read the entity Company with the Get all companies action as shown below:
A successful validation or execution of the Snap gives the following output preview, showing the query results.
We format the above output as a JSON file using the JSON Formatter Snap and write the JSON Formatter Snap's output into a local file using the File Writer Snap.
To view the newly-created file, we SSH to the target directory and open the newly-created file.
...