Hell Marketo community,
I'm trying to format phone number field values for existing records (can't rely on Mask Input within Marketo Forms prior to Lead creation) by calling the following webhooks with support from Hoosh Marketing's (launchpoint partner) free Excel for Marketo webhook solution. Feel free to suggest an alternative approach if these webhooks or webhooks in general are not the best approach.
The first webhook below works successfully, but the second one fails. See the Response "Disallowed Key Characters".
1) Clean Phone Number: remove non-numeric charcters from the field value.
2) Format Phone Number: (XXX) XXX-XXXX
Solved! Go to Solution.
Thanks, Sanford. Is FlowBoost an application of or a reference library to
use within munctions? To leverage FlowBoost, do we need to ask to have
munctions turned on before testing the sample script you provided? I don't
see any other discussions within the Marketo community about FlowBoost and
very few that even reference munctions. If you can point me in the right
direction I'd appreciate it.
<https://nation.marketo.com/?et=watches.email.thread> The Marketo Marketing
Nation Community <https://nation.marketo.com/?et=watches.email.thread>
Re: Phone Number Format Webhook
reply from Sanford Whiteman
in Products - View the full discussion
Munctions were promising, but are now discontinued, so any threads about them tend to meander into discussions of webhook-based alternatives. The Excel function simulator you tried is one, though I find its syntax unsuitable for all but the most basic tasks (this is not a hit on the service, as it also applies to Excel itself -- thus why VBA is preferred for Excel power users). Rajesh (who responded above) has another one, BrightHooks, which offers a built-in function for your phone number task, so give him a shout.
However, though it's been live for over a year for in-house clients (small to multinational, serving millions of requests per month) it's somewhat of a secret project from a commercial standpoint. As tech lead, I blog about new features over at http://blog.teknkl.com/tag/flowboost. But to get a trial key, you should hit up firstname.lastname@example.org. I sometimes answer Community questions with ways you could do things in FlowBoost/JS, not because... okay, not only because!... I'm bigging up the service, but because that's literally the way I'd attack the problem if it were for our clients, rather than building a new app every time.
I'll reach out to Etumos to try out FlowBoost. It sounds like that is a more flexible and formalized product vs. Munctions. Much appreciated. Have a happy new year!
If you are still looking for solving this quickly, this web hook can be useful.
If you need any help, access, please feel free to reach out.