jquery, json and xml

Question

I have a database at zoho creator. They feed me a json of the database content. I have trouble to parse and display that data with jquery or php or in html

Question : So how do I capture json data, and save (convert) it to file as XML. With the xml file I can parse it with jquery xpath easily... the "file" will be a local database, as a backup (if saved)

anybod have clue on that ?

---

as request.. here is the link for the query -link-

getting a way to display data from var i need is the minimum i must have ! like prod_categorie or prod_nom

note :

1. i can get help with any tutorial on how to get xml data from zoho
2. any json to xml converter (jquery) out there ?????

Answer 1

Firstly, Javascript has no file-output capability. The best it can do is send data back to a server for processing there -- so the "capture json data, and save it to file as XML" idea is out.

What problems in particular are you having with using JSON? As it gets converted to a native Javascript object, I find it quite easy to work with myself. Though, I can see that if you wanted to use XPath to query it, JSON is no help. You should still be able to get to whatever data you need, but it might be a bit more verbose.

In your example JSON:

{"Liste_des_produits1":[{"Added_Time":"28-Sep-2009 16:35:03",
"prod_ingredient":"sgsdgds","prod_danger":["sans danger pour xyz"],"prod_odeur"..

You could access the prod_danger property like this:

$.getJSON(url, function(data) {
   var danger = data.List_des_produits1[0].prod_danger; 
});

If you are having trouble getting the right path to a property, Firebug is a great help with this. Just call this:

$.getJSON(url, function(data) {
    console.log(data);
});

...and then you can browse through its properties in a tree-structure.

Answer 2

There are jQuery pluggins for such convertion, for example json2xml.