Webhook fails to update Marketo field

Subscribe

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.