How to unset a property

[#1]

We’d like to remove a property from a deal.
eg we have created prop_1 = 0 under deal 1.
we would like this prop to no longer show up under that deal.
(this prop should still be available for other deals where it applies)
we’ve tried setting it to null, however it still shows up.
we’ve also tried deleting the property and re-adding it,
however that does nothing (the prop is not deleted under the deal if you remove the property)
any insights appreciated

[IsaacTakushi · Accepted solution]

Welcome, @jrummell-elite!

Yes, this is still the case.

You can clear date and datetime-type properties by passing a blank string: "". I just tested and confirmed in my own account:

POST https://api.hubapi.com/contacts/v1/contact/vid/123/profile

{
  "properties": [
    {
      "property": "custom_date_picker",
      "value": ""
    }
  ]
}

[OVYA]

Hi,

It's not a reliable solution because making a property to an empty string make this property as a know value (empty value) not an uncknow value (null value).

To my expericne it is not possible to set a property as uncknow with the api and outside a workflow…

Let me know if I'm wrong.
Regards.

[Derek_Gervais]

Hi @laruellef,

Deleting the property will immediately make the property inaccessible via the HubSpot UI or API. Outside of that, the property values on the object will remain indefinitely (unless the object is deleted or the portal is purged).

[#5]

Is this still the case? I'm working on an API integration and need to fix a handful of property values on thousands of deals. Ideally, we'd like to unset them. For string properties I could try " " or "n/a", but what about date properties?

[#6]

ok, tks Derek,
if I delete the property alltogether,
will it ever be removed from the object?
if so, when?

[Derek_Gervais]

Hi @laruellef,

You can set the property value to a blank string ("") to clear out any value in that property. However once a property is given a value for a particular record, that property will continue to appear in the object even if the value is cleared (i.e. set to "").