SOLVED

Changing only part of a data value

Go to solution

Changing only part of a data value

I'm trying to standardize my Mobile Number data using a smart Campaign as one of my webhooks won't allow for different formats for some reason.

Is there a way to only remove 1 or 2 digits of a value using the change data value flow step?

This is what I've got at the moment but it takes away the whole number.

pastedImage_1.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Level 10 - Community Moderator

Re: Changing only part of a data value

No can do with a Flow step. But have you seen my post on Calling the Twilio Lookup API as a Marketo webhook​ to perform phone number fixup? Format-only calls to the Twilio API are free. Presumably the other endpoint you're calling, if you're passing the {{lead.Mobile Phone}} expects the standard libphonenumber format returned by Twilio.

If that doesn't work you'd need a(nother) custom webhook to massage the data.

View solution in original post

1 REPLY 1
Highlighted
Level 10 - Community Moderator

Re: Changing only part of a data value

No can do with a Flow step. But have you seen my post on Calling the Twilio Lookup API as a Marketo webhook​ to perform phone number fixup? Format-only calls to the Twilio API are free. Presumably the other endpoint you're calling, if you're passing the {{lead.Mobile Phone}} expects the standard libphonenumber format returned by Twilio.

If that doesn't work you'd need a(nother) custom webhook to massage the data.

View solution in original post