AnsweredAssumed Answered

Using Excel Formula in Webhook

Question asked by Elliott Antal on Nov 3, 2017
Latest reply on Nov 9, 2017 by 25b3328799c7c5f288f354fba32f826134d213b8

Hi - I setup a webhook in Marketo using Hoosh's free excel formula tool and it appears to be performing the action I want, but then it's also giving me an error.


The action I want is to format a phone number of 8888888888 to (888) 888-8888 and replace it in the Marketo designated field. As you can see in the screenshot, that's actually happening.


Screen Shot 2017-11-03 at 9.54.00 AM.png


What I don't understand is why after the Change Data Value is successful, the webhook says it failed and has a Server Returned code 500.


I'm happy with the results and tempted to move forward, but the fact that it says it failed has me worried that there is something not right.


I am including a screenshot of my webhook setup for reference.


Screen Shot 2017-11-03 at 10.21.08 AM.png