Get hubspot multiselect column data in the order they are added in specific row.

nutan1 — Wed, 08 May 2019 05:50:58 GMT

We have used hubspot multiselect column to store data for multiple countries.Here i want to display data in the order they are added in perticular row.But currently getting data order by id.Mean if i added india first at the time of multiselect column creation it willl get first no matter when we have added it in specific row(first or last or middle).Is it possible to do such a thing.

Re: Get hubspot multiselect column data in the order they are added in specific row.

IsaacTakushi — Thu, 09 May 2019 15:14:55 GMT

Hi, @nutan1.

In my tests, property values for multiple checkbox field types were stored and returned in the order they were added, so this should be possible.

For example, I created a property named multiple_checkbox_test_property with four options: Option 1, Option 2, Option 3, and Option 4. See the screenshot below:

I then gave a contact an Option 4 value first, then Option 3, then Option 2, and finallyOption 1. This screenshot shows how the values look on the contact record:

When I retrieve the contact using this endpoint, the property values are returned in the order I set them:

"multiple_checkbox_test_property": {
            "value": "Option 4;Option 3;Option 2;Option 1",
            "versions": [
                {
                    "value": "Option 4;Option 3;Option 2;Option 1",
                    "source-type": "CRM_UI",
                    "source-id": "",
                    "source-label": null,
                    "timestamp": 1557413789371,
                    "selected": false
                },
                {
                    "value": "Option 4;Option 3;Option 2",
                    "source-type": "CRM_UI",
                    "source-id": "",
                    "source-label": null,
                    "timestamp": 1557413786395,
                    "selected": false
                },
                {
                    "value": "Option 4;Option 3",
                    "source-type": "CRM_UI",
                    "source-id": "",
                    "source-label": null,
                    "timestamp": 1557413782134,
                    "selected": false
                },
                {
                    "value": "Option 4",
                    "source-type": "CRM_UI",
                    "source-id": "",
                    "source-label": null,
                    "timestamp": 1557413776978,
                    "selected": false
                }
            ]
        }
    }

If you are seeing different behavior, please share a link to an example contact in your account.

topic Get hubspot multiselect column data in the order they are added in specific row. in APIs & Integrations

Get hubspot multiselect column data in the order they are added in specific row.

Re: Get hubspot multiselect column data in the order they are added in specific row.