Excel import: how to pass custom internal values (not only labels) to multiple checkbox property
SOLVE
We use Excel import to create/update multiple checkbox options for exisiting contacts in HubSpot. In such case we pass labels with semicolon delimiter like:
Option label 1;Option label 2;etc.
And HubSpot works as expected.
THE PROBLEM: Now we have a special case: we need to also pass custom internal values (not only labels) and we are not sure what is the format expected from HubSpot.
We need to pass specific custom internal value together with each label, something like:
Where the number in brackets in front each label is the custom internal value of the option. We noticed that when we create options manually from within HubSpot UI then it works, but we are not sure how to pass them in Excel file.
Can you tell us what is the correct format to pass custom internal values when doing an Excel import?
If I understand your question correctly, this isn't possible from the CSV/Excel file alone.
In my tests, I was only able to create custom internal values by defining a delimiter in the UI before importing. My example below created options with the internal values: cat, dog, and fish.
Alternatively, you could create property labels and options via the Contact Properties API.
If I understand your question correctly, this isn't possible from the CSV/Excel file alone.
In my tests, I was only able to create custom internal values by defining a delimiter in the UI before importing. My example below created options with the internal values: cat, dog, and fish.
Alternatively, you could create property labels and options via the Contact Properties API.