Upcoming: A change for number properties in CRM APIs

mwelch
HubSpot Alumni
What's happening?

We are going to restrict number property values in the API to contain only numeric digits, an optional single negative sign ("-"), and an optional single decimal point represented by a period/dot symbol.

Attempts to save values on numeric properties with commas, spaces or multiple period/dot symbols via the API will be rejected with an HTTP 400 response code.

For example, if a user in Germany wishes to save a price property value with the amount of '4 Euro and 68 cents', then they must submit a value of 4.68 in the API request for this operation. A value like 4,68 will no longer be accepted.

This change will apply across all API endpoints handling number properties. This will not change the behavior of the HubSpot app itself.

 

Why is this happening?

This change will bring us much closer to strong numerical data consistency across the core systems at HubSpot. In turn, this will lead to coherent views of contact, company, deal and ticket information whether viewed as part of a report, record, or within a table, no matter the geographic locale or number format preferences of the consumer. This change will be of particular benefit to those users outside the US or UK locales who have in the past experienced occasional data inaccuracies with numerical property values in HubSpot.

 

When is this happening?

This change is happening on January 7, 2020.

 

Please join the conversation here if you have any comments.

3 Replies 3
antoine_aircall
Participant

Hi there, This is great news. Does this at all impact phone numbers? If not so, I think that's something we would be curious seeing as well, a sort of unified format for phone numbers across HubSpot.

 

Thanks,


Antoine

 

0 Upvotes
mwelch
HubSpot Alumni

Hi Antoine,

 

Thanks for the feedback. This change does not apply to phone fields. I'll let our internal teams know about your interest in a more standardized format for phone fields in the API.

 

Matt

0 Upvotes
mwelch
HubSpot Alumni

I have updated the original forum post here, as well as the original changelog, to clarify that an optional single negative sign ("-") will also be accepted.

0 Upvotes