topic Re: Update existing property to be unique, need to fetch Deal by custom property in APIs & Integrations

Update existing property to be unique, need to fetch Deal by custom property

LRamsden — Mon, 24 May 2021 19:52:29 GMT

I have created a Deal custom property, `purchase_reference_id`, which I cannot seem to fetch Deals by. I suspect this is because I mistakenly did not set `hasUniqueValue` to `true`. However, it does not seem that I can update the hasUniqueValue, presumably because the property already exists, and I cannot delete and recreate the property because properties seem to only soft delete. Can somebody from HubSpot please help me rectify this?

Please note that this is a test account and so I can easily remove this property so that it is not used in any Deals - the issue is that while API requests to update the hasUniqueValue property succeed, they don't seem to actually change anything.

Re: Update existing property to be unique, need to fetch Deal by custom property

WendyGoh — Tue, 25 May 2021 09:54:52 GMT

Hey @LRamsden,

Happy to help here 🙂

To start, could you share with me the portal Id in question? When I attempt to locate deal Id 10040947267 on portal 195xxxxx, it doesn't exist.

The reason I asked for the portal Id is because, I'd like to try updating the `purchase_reference_id` property's `hasUniqueValue` to true using the Update a property endpoint. However, if you've already deleted the property, I'd like to try and recreate the property using the Create a property endpoint.

Based on your screenshots, it looks like you're retrieving the property (as both the method are GET) and not creating it, so I'd like to see if I'm getting any error when attempting to recreate the `purchase_reference_id` property.

Re: Update existing property to be unique, need to fetch Deal by custom property

WendyGoh — Tue, 25 May 2021 09:41:15 GMT

Hey @LRamsden,

Happy to help here 🙂

To start, could you share with me the portal Id in question? When I attempt to locate deal Id 10040947267 on portal 195xxxxx, it doesn't exist.

The reason I asked for the portal Id is because, I'd like to try updating the `purchase_reference_id` property's `hasUniqueValue` to true using the Update a property endpoint. However, if you've already deleted the property, I'd like to try and recreate the property using the Create a property endpoint.

Re: Update existing property to be unique, need to fetch Deal by custom property

WendyGoh — Tue, 25 May 2021 09:42:21 GMT

Hey @LRamsden,

Happy to help here 🙂

To start, could you share with me the portal Id in question? When I attempt to locate deal Id 10040947267 on portal 195xxxxx, it doesn’t exist.

The reason I asked for the portal Id is because, I’d like to try updating the `purchase_reference_id` property’s `hasUniqueValue` to true using the Update a property endpoint. However, if you’ve already deleted the property, I’d like to try and recreate the property using the Create a property endpoint.

Based on your screenshots, it looks like you’re retrieving the property (as both the method are GET) and not creating it, so I’d like to see if I’m getting any error when attempting to recreate the `purchase_reference_id` property.

Re: Update existing property to be unique, need to fetch Deal by custom property

WendyGoh — Tue, 25 May 2021 09:44:01 GMT

Hey @LRamsden,

Happy to help here 🙂

To start, could you share with me the portal Id in question? When I attempt to locate deal Id 10040947267 on portal 195xxxxx, it doesn’t exist.

Re: Update existing property to be unique, need to fetch Deal by custom property

LRamsden — Tue, 25 May 2021 09:57:59 GMT

Hi Wendy,

Thanks for looking at this.

The deal ID is "5342463385", the ID you were searching by is the transaction_id property

Re: Update existing property to be unique, need to fetch Deal by custom property

WendyGoh — Thu, 27 May 2021 05:48:28 GMT

Hey @LRamsden ,

Thanks for the confirmation!

On my end, I deleted the property and tried recreating it by sending the following API request:

POST https://api.hubspot.com/crm/v3/properties/deals/

{ "groupName": "dealinformation", "name": "purchase_reference_id", "hidden": false, "displayOrder": -1, "hasUniqueValue":true, "label": "Purchase Reference ID", "type": "string", "fieldType": "text", "description":"The ID that refers to the object in Zilch's systems"}

however, I'm seeing the following error:

{ status:"error", message:"Field 'hasUniqueValue' cannot be modified for property 'purchase_reference_id'.", correlationId:"fe980db6-f74d-4c35-b3f6-1283af63f11e", propertiesErrorCode:"PROPERTY_INVALID"}

For this case, I've reached out to our internal team to check on it and I'll keep you posted here.

Re: Update existing property to be unique, need to fetch Deal by custom property

WendyGoh — Fri, 28 May 2021 01:48:26 GMT

Hey @LRamsden ,

All's set here.

I've recreated the `purchase_reference_id` property on your portal and set the `hasUniqueValue` value to true.

Let me know if there are any queries on this!