Populating Custom Lead Fields by Parsing XML Responses

[Anonymous]

Hi All,

I have programmed a webhook which is called each time a new lead is created. The REST API URL saved with the webhook gives back a key:value response in XML format.

How do you folks suggest, that I process and parse this XML response, so that I only collect required key:value pair data from the entire response and populate the custom fields created against each of the lead records so that I can then use these custom fields data on to an email body ?

Thank You all for the help!!

Prabash Rath

Babajob.com, Bangalore, India.

[SanfordWhiteman]

In the config of any Webhook, you set the mapping between XML/JSON fields and Lead fields. What part of that isn't working for you?  If you have full control over the response (you programmed the 'hook?) you should have no problem giving back a response with the perfect schema.

[Anonymous]

Hi Sanford,

Thanks a lot for the help.

I have set the response mapping and have saved matching a response attribute with a marketo field (custom field).

Eg. - RapidHireHealthRow.City mapped to CustomCity field in marketo.

However, on creating a new lead now - results show that the webhook has been called. Also, I am able to view the entire response as well; but, the respective field (CustomCity) against that lead record is not getting populated with the data from the API response. How do you suggest I go about it ?

Thanks again !

Prabash Rath

Babajob.com, Bangalore, India.