Issue while parsing SOAP Response with name space using webhook.

Anonymous
Not applicable

Issue while parsing SOAP Response with name space using webhook.

I have successfully configure webhook inside marketo. i am facing issue in Response mapping of webhook, XML response is having namespaces as shown below.

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:NetSuiteMassUpdateResponse xmlns:ns3="http://spectrum.pb.com/" xmlns:ns2="http://www.pb.com/spectrum/services/NetSuiteMassUpdate"><ns2:Output><ns2:Row><ns2:AddressLine1>50 Water St</ns2:AddressLine1><ns2:ApartmentNumber.Result>R</ns2:ApartmentNumber.Result><ns2:City>Lee</ns2:City><ns2:Confidence>87</ns2:Confidence><ns2:Country>US</ns2:Country><ns2:CountryLevel>A</ns2:CountryLevel><ns2:MatchScore>0</ns2:MatchScore><ns2:PostalCode>01238-9149</ns2:PostalCode>

Following is the Response mapping for postalcode which i have done in webhook to update the lead records but record is not getting update.

NetSuiteMassUpdateResponse.Output.Row[0].PostalCode  = PostalCode

Please suggest.

4 REPLIES 4
Kenny_Elkington
Marketo Employee

Re: Issue while parsing SOAP Response with name space using webhook.

Are there multiple rows in the response?  If not, I don't think it will be treated as an array.

Anonymous
Not applicable

Re: Issue while parsing SOAP Response with name space using webhook.

Hi Kenny,

Thanks for your reply.

I have tried it with array or without array both way but it is not working. if response have the name space as mentioned below.

<ns3:NetSuiteMassUpdateResponse xmlns:ns2="http://spectrum.pb.com/" xmlns:ns3="http://www.pb.com/spectrum/services/NetSuiteMassUpdate">

         <ns3:Output>

            <ns3:Row>

                  <ns3:PostalCode>01238-9149</ns3:PostalCode>

How should i map the response to get the updated PostalCode value in markeTo from the response.

Regards,

Deepak Kumar.

Anonymous
Not applicable

Re: Issue while parsing SOAP Response with name space using webhook.

Hi Kenny,

Things are working now .

I have used REST service instead of SOAP.

Thanks for your

Best Regards,

Deepak

Kenny_Elkington
Marketo Employee

Re: Issue while parsing SOAP Response with name space using webhook.

Sorry I didn't have a chance to look into this.  I will if I have some extra time this week.  Glad you could get this working.