Webhook fails to update Marketo field

A document by KCS Integration on behalf of Naveen Bharathi on Mar 12, 2018Last modified by Roxann McGlumphy on Mar 13, 2018
Version 3Show Document
  • View in full screen mode

Issue Description
The call Webhook flow is successful but the Marketo field mapped is not updated.

 

Issue Resolution
Marketo can translate data received by a Webhook to a lead field. If the fields are not getting updated:

 

  • Check if the Response types are JSON or XML. The correct response type must be selected in order to map properties of the response back to lead fields in Marketo
  • Check if the fields are blocked from Updates in field management.
  • If the response type is XML, all elements in the XML hierarchy must be referenced in the mapping.

 

For example: If the XML is:

 

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <soap:Body>
        <GetDealerByPostcodeResponse xmlns="http://webservices.hmca.com.au/DealerLocatorMapService/">
            <GetDealerByPostcodeResult>
                <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
                    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:Locale="">
                        <xs:complexType>
                            <xs:choice minOccurs="0" maxOccurs="unbounded">
                                <xs:element name="Table">
                                    <xs:complexType>
                                        <xs:sequence>
                                            <xs:element name="dl_tradingName" type="xs:string" minOccurs="0" />
                                            <xs:element name="dl_physicalstreetname" type="xs:string" minOccurs="0" />
                                            <xs:element name="dl_physicalsuburb" type="xs:string" minOccurs="0" />
                                            <xs:element name="dl_physicalstate" type="xs:string" minOccurs="0" />
                                            <xs:element name="dl_physicalpostcode" type="xs:string" minOccurs="0" />
                                            <xs:element name="pcmaplat" type="xs:float" minOccurs="0" />
                                            <xs:element name="pcmaplng" type="xs:float" minOccurs="0" />
                                            <xs:element name="maplat" type="xs:float" minOccurs="0" />
                                            <xs:element name="maplng" type="xs:float" minOccurs="0" />
                                            <xs:element name="distance" type="xs:float" minOccurs="0" />
                                            <xs:element name="dl_phonenumber" type="xs:string" minOccurs="0" />
                                            <xs:element name="dl_faxnumber" type="xs:string" minOccurs="0" />
                                            <xs:element name="dl_emailaddress" type="xs:string" minOccurs="0" />
                                            <xs:element name="dl_code" type="xs:string" minOccurs="0" />
                                            <xs:element name="pd_postcode" type="xs:string" minOccurs="0" />
                                            <xs:element name="dl_webaddress" type="xs:string" minOccurs="0" />
                                            <xs:element name="dl_dealershipregion" type="xs:string" minOccurs="0" />
                                            <xs:element name="dl_deliverycharge" type="xs:float" minOccurs="0" />
                                            <xs:element name="dl_regionstate" type="xs:string" minOccurs="0" />
                                            <xs:element name="BkAServiceDesktop" type="xs:string" minOccurs="0" />
                                            <xs:element name="NewWinBkAServiceDesktop" type="xs:string" minOccurs="0" />
                                            <xs:element name="BkAServiceMobile" type="xs:string" minOccurs="0" />
                                            <xs:element name="NewWinBkAServiceMobile" type="xs:string" minOccurs="0" />
                                        </xs:sequence>
                                    </xs:complexType>
                                </xs:element>
                            </xs:choice>
                        </xs:complexType>
                    </xs:element>
                </xs:schema>
                <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
                    <NewDataSet xmlns="">
                        <Table diffgr:id="Table1" msdata:rowOrder="0">
                            <dl_tradingName>Wild West Hyundai</dl_tradingName>

 

The Response attribute must be:

 

soap:Envelope.soap:Body.GetDealerByPostcodeResponse.GetDealerByPostcodeResult.diffgr:diffgram.NewDataSet.Table.dl_tradingName

 

All the elements need to be referenced in the top down approach.

Attachments

    Outcomes