How To Get JSON From API_DoQuery?

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 Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=403

Screenshot attached.