I added a complementary function
XMLStructuredToObj to a new pastie to show how you can obtain a second JSON representaton from
API_DoQuery based on returning the so-called
Structured XML Response. The main difference is that the JSON returned by
XMLFlatToObj will have
lowercased and
underscore mapped special characters
key names (eg
"record_id_") versus key names identical to the field label "
Record ID#"
Here is the
XML Response (Structured) that
API_DoQuery&qid=1 would return
http://pastie.org/10268257
and this the the
JSON Response we want to work with:
http://pastie.org/10268260
Here is some simple code that will effectively convert the
Structured XML Response to a
JSON Response as part of the AJAX request:
Pastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=403Screenshot attached.
