Contents x
    Data Destination - HubSpot
    • 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Contents

    Data Destination - HubSpot

    • Updated on 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    Note

    This is a machine-translated version of the original Japanese article.
    Please understand that some of the information contained on this page may be inaccurate.

    summary

    This is the help page for setting up data transfer to HubSpot.

    Supported Protocols

    • Data Transfer (Embulk)

    constraint

    • Only one object can be transferred.

    Setting items

    STEP1 Basic settings

    Itemnamerequireddefault
    		valuecontent
    HubSpot connection informationYes-From the connection information registered in advance, select the one that has the necessary permissions for this transfer setting.
    Only connection information created with OAuth 2.0 as the authentication method can be selected.
    For more information on how to set up connection information, see Connection information in HubSpot.
    Update toYes-
    • object
    • subscription
    Object TypeYes-Specify the name of the object where the report data is stored.
    • contact
    • company
    • deal
    • product
    • ticket
    • line_item
    • quote
    • subscription
    Transfer ModeYesUPSERTSpecify the method by which data is transferred to the object.
    • UPSERT: UPSERT data to an object.
    • APPEND (INSERT): APPENDS DATA TO THE OBJECT.
    UPSERT keyYeshs_object_idEnter when you select UPSERT in transfer mode.
    Enter the name of the property that you want to treat as a merge key (primary key) with unique values.
    Note that the default values arehs_object_id properties with unique values set by HubSpot.
    Object Type: About Subscription

    If you select subscription as the object type, the transfer is performed in UPSERT. Also, the UPSERT key isemail automatically specified as andsubscription_id .
    For more information, see Renewing your subscription below.

    If you want to set a property to the UPSERT key


    hs_object_id, or any other property of the contact objectemail if you want to set it as a UPSERT key, you'll need to do so in HubSpot beforehand. The following describes the configuration procedure.

    1. Log in to HubSpot and click your HubSpot account
    2. At the top right of the screen, click the settings icon in the red frame.
      image
    3. Click Properties
      image
    4. Select the object and click the property you want to use as the UPSERT key
      image
    5. Click the Rules tab
      image
    6. For this property, enable Require non-duplicate values and click Save
      image

    Renew your subscription

    Usage API

    https://developers.hubspot.com/docs/api/marketing-api/subscriptions-preferences

    schema

    All of the following columns must be included in the transferred data:

    Columndescriptionsample value
    emailE-mail addresshoge@example.com
    subscription_idSubscription ID
    Learn how to find your subscription ID.    		12232
    is_subscribedSubscription StatusMake sure it is set to boolean typein STEP2 of trocco.
    • true: Subscribe
    • false: Unsubscribe

    How to find your subscription ID

    1. In HubSpot, select Settings→ Data Management→ Properties.
    2. Select "Export all properties" at the top right of the properties screen and click "Export" in the modal to download the Excel/CSV file.
    3. Find items starting with in the "CONTACT" sheet hs_email_optout_of the Excel/CSV file.
    4. hs_email_optout_111111, where is the subscription ID.

    constraint

    • If you have unsubscribed, you will not be able to subscribe to Trocco. Update from the top of the HubSpot screen.
    • Updating with the same subscription status will result in an error.
      • Example: Unsubscribing to unsubscribe will result in an error.
    Was this article helpful?
    What's Next