API giving weird string (GUID format) for deal stage rather than the text

[JCrane1]

Hi all!

I'm trying to pull the deal stage from Hubspot into Monday via integromat. But the output data I get gives me the value of the deal stage in a very strange format. I just need the label.

[JCrane1]

Hi @dennisedson @Kevin-C for the help!

It's the weirdest thing, but it's the only output map I can see from the HubSpot API in integromat that has anything to do with the deal stage.

Sometimes they're GUID-style strings, sometimes they're just numbers...

[dennisedson]

@JCrane1 , that looks like the deal stage ID

@Kevin-C, @Josh  any chance either of you have built something like this?

[Kevin-C]

Hey@dennisedson @JCrane1 

I've seen this before when using hubl to pull lifecycle stages.

@dennisedson maybe the product team made an update and the docs haven't been updated or somethingwas missed in the update?

[dennisedson · Accepted solution]

dangit @Kevin-C 😒.  I wanted you to solve this not me 😜

Sooo looking into this it appears that the default deal stage properties are english for the internal name but any new properties that are added just get an ID as the internal name. You can get the labels by calling the pipelines API and matching stage IDs up, but I am not sure how that would work with Integromat.

@Kevin-C , this is the same for Hubl.

[Kevin-C]

The simplicity of this solution hurt my feelings lol!

To make myself useful I looked into the availble integromat functions.

It seems that you might be able to us a switch function to match your IDs to string values!

Side note that uses some odd syntax IMO!