topic Re: Converting a string property to an int using custom code in workflow? in 💬 RevOps Discussions

Converting a string property to an int using custom code in workflow?

MFriberg — Fri, 21 Apr 2023 22:12:47 GMT

Hi!

I've recently started deep-diving into what I would consider more advanced parts of HubSpot, and I've realized that one crucial property I use in various workflows is stored as a string instead of an integer, which limits how I can use it with list filters/workflow triggers.

I know that there's no simple way to convert a string property to an int or float using a workflow that copies the property value, but I was wondering if this could potentially be possible using custom code in a workflow?

I basically want to copy the contents of property X, which is a string, to property Y, which is an integer, exactly like a Python type conversion:

int(X)

Would appreciate any help anyone can offer with this!

Betreff: Converting a string property to an int using custom code in workflow?

MiaSrebrnjak — Mon, 24 Apr 2023 17:30:14 GMT

Hi @MFriberg,

Thank you for reaching out to the Community!

I wanted to tag in a couple of subject matter experts to see if they can offer any advice:

Hi @Teun, @miljkovicmisa, @ChristinaKay, do you have any tips for @MFriberg? Thank you!

Cheers
Mia, Community Team

Re: Converting a string property to an int using custom code in workflow?

MFriberg — Thu, 18 May 2023 21:04:41 GMT

Hi @MiaSrebrnjak!

Do you have any other people who might be able to help with this that you could tag to get their eyes on it?

Re: Converting a string property to an int using custom code in workflow?

AJohnsson — Mon, 25 Sep 2023 12:16:07 GMT

Hi, did you ever manage to solve this?

Re: Converting a string property to an int using custom code in workflow?

BérangèreL — Mon, 25 Sep 2023 13:15:43 GMT

Hi @AJohnsson,

Thank you for reaching out to the Community!

I found these resources that might help you:

- The solution from @tmcmillan99 on this post "Convert url parameter string to integer"
- This article "Python Typecasting: How To Cast a String Into An Integer"

I'd also recommend posting in our Developer Forum here, since it is custom code, you might be able to get help!

I'd like to invite a couple of subject matter experts to this conversation @DanielJeal, @ChrisoKlepke and @louischausse do you have any suggestions to help @AJohnsson, please?

If anybody else has anything to add and/or share, please feel free to join in the conversation 🙂

Thanks and have a good day!

Best,
Bérangère

Re: Converting a string property to an int using custom code in workflow?

DanielJeal — Mon, 25 Sep 2023 14:40:55 GMT

You can also define the datatype output in the code output return values

Re: Converting a string property to an int using custom code in workflow?

DanielJeal — Mon, 25 Sep 2023 15:18:25 GMT

Something like this can do it, also define output as a number and you can use it in a later 'copy values' step.

def main(event): # Use inputs to get data from any action in your workflow and use it in your code instead of having to use the HubSpot API. str_id = event["inputFields"]["id"] int_id = int(str_id) # Return the output data that can be used in later actions in your workflow. return { "outputFields": { "id": int_id } }