convert xml response (from ZohoCRM) to simple “key=value” pairs (for SurveyGizmo) using php or Zoho Creator

convert xml response (from ZohoCRM) to simple “key=value” pairs (for SurveyGizmo) using php or Zoho Creator

Hi there,

This deals with exchanging data between CRM & Gizmo.   I'd like to Creator (or php) to convert the response.

SurveyGizmo posts (insert) data to ZohoCRM.

After insert, Zoho responds with xml that includes an ID of the inserted record.

Gizmo needs that ID for subsequent updates.

The problem is, Gizmo will only accept a response in a simple "key1=value1,key2=value2" format.

I'd like to have ZohoCreator receive Gizmo's post, pass it through to ZohoCRM, receive the xml response from ZohoCRM, convert it to key=value, and return it to Gizmo.

I've managed to create the Creator deluge code:

  1. gizmodatamap = { "WHOID" : input.WHOID, "Subject" : input.Subject_field, "Project" : input.Project, "Case Owner" : input.Case_Owner };
    crmResp = zoho.crm.create("Cases", gizmodatamap);
    info crmResp;
So far, I can post to the creator form, it then onSuccess inserts to CRM.  The problem I'm having is the response I get is from Creator with the ID of the record in Creator.  I need the ID from CRM instead.  And a way to extract it from the response into a key=value format.