Re: Webhook Error

Elliott_Antal · ‎10-31-2017

I am trying to execute this from the Marketo/Velocify integration guide, "Post must be set up in Marketo to update Velocify as Marketo Interesting Moments occur." The interesting moments for us is an Email Open and Link Click in an Email. We've written an HTTP Post using GET and POST and both are returning a HTTP Error 500: Server error. When we test it using Postman it works perfectly and the Action in Velocify is triggered.

Our current Webhook setup is...

URL: ClientService Web Service

Request Type: POST

Template: AddLeadAction?username=marketo.prod@cardinalfinancial.com&password=marketo2017&leadId={{lead.Velocify Lead Id:default=edit me}}&actionTypeId=146&actionNote=EmailClick

And this is what I am getting in response...

<!DOCTYPE html> <html> <head> <title>Data at the root level is invalid. Line 1, position 1.</title> <meta name="viewport" content="width=device-width" /> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Consolas","Lucida Console",Monospace;font-size:11pt;margin:0;padding:0.5em;line-height:14pt} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } @media screen and (max-width: 639px) { pre { width: 440px; overflow: auto; white-space: pre-wrap; word-wrap: break-word; } } @media screen and (max-width: 479px) { pre { width: 280px; } } </style> </head> <body bgcolor="white"> <span><H1>Server Error in '/' Application.<hr width=100% size=1 color=silver></H1> <h2> <i>Data at the root level is invalid. Line 1, position 1.</i> </h2></span> <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "> <b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. <br><br> <b> Exception Details: </b>System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.<br><br> <b>Source Error:</b> <br><br> <table width=100% bgcolor="#ffffcc"> <tr> <td> <code> An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code> </td> </tr> </table> <br> <b>Stack Trace:</b> <br><br> <table width=100% bgcolor="#ffffcc"> <tr> <td> <code><pre> [XmlException: Data at the root level is invalid. Line 1, position 1.] System.Xml.XmlTextReaderImpl.Throw (Exception e) +88 System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace () +441 System.Xml.XmlTextReaderImpl.ParseDocumentContent () +356 System.Xml.XmlLoader.Load (XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) +160 System.Xml.XmlDocument.Load (XmlReader reader) +135 System.Xml.XmlDocument.Load (Stream inStream) +160 LeadManagerService.ClientServiceNonRestProxy.ProcessRequest (HttpContext context) in F:\Build17\295\s\Services\LeadManagerService\LeadManagerService\ClientServiceNonRestProxy.ashx.cs:44 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute () +508 System.Web.HttpApplication.ExecuteStep (IExecutionStep step, Boolean& completedSynchronously) +92 </pre></code> </td> </tr> </table> <br> <hr width=100% size=1 color=silver> <b>Version Information:</b> Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.6.1590.0 </font> </body> </html>

Any idea why this will work in Postman but not in Marketo?

Thanks!

SanfordWhiteman · ‎11-01-2017

OK, add that Content-Type as a custom header in the webhook config.

Seem to recall there's a known (to me!) bug here, but I'm on my phone so can't check it now.

View solution in original post

Kenny_Elkington · ‎10-31-2017

My Guess is that "AddLeadAction" needs to be part of your URL/Path, and not part of the body.

Elliott_Antal · ‎10-31-2017

Kenny - Thanks for the response! I made the change and now the response is much shorter:

System.InvalidOperationException: Request format is invalid: text/xml; charset=utf-8. at System.Web.Services.Protocols.HttpServerProtocol.ReadParameters() at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()

Our developer thinks the data isn't getting sent correctly so the response is not XML but some .net error page?

SanfordWhiteman · ‎10-31-2017

You aren't sending XML, you're sending Form/URL encoded.

The endpoint supports SOAP (XML) or Form/URL request payloads.

Elliott_Antal · ‎10-31-2017

Does this look like the settings I should be using?

SanfordWhiteman · ‎10-31-2017

Yep, that would be consistent with their docs.

Elliott_Antal · ‎11-01-2017

Hmmm. I am still getting an error.

System.InvalidOperationException: Request format is invalid: text/xml; charset=utf-8. at System.Web.Services.Protocols.HttpServerProtocol.ReadParameters() at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()

Odd that this is working outside of Marketo in Postman. Am I correct in assuming there is something in the response that Marketo isn't liking?

Elliott_Antal · ‎11-01-2017

Here is a screenshot of what was working for us in Postman. Post and response both included.

SanfordWhiteman · ‎11-01-2017

And the Headers tab?

Elliott_Antal · ‎11-01-2017

Here is a screenshot of the Headers tab.