Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have some difficult to read a son file and insert every field in a CSV file. I tried and read several article but without success. Please somebody can me help?
Here the original file, and below the expected CSV file
{"data":[{"Body":"{\"data\": {\"radon\": 48.0, \"nitrates\": null, \"h2s\": null, \"emf_hf\": 0.0, \"temp\": 24.0, \"chlorine\": null, \"geiger\": 0.17000000178813934, \"ammonia\": null, \"pm2_5\": null, \"light\": null, \"nitrites\": null, \"ch4\": 1.0, \"air_quality\": 1.0700000524520874, \"acc_y\": null, \"co2\": 1402.0, \"co\": 0.0, \"battery\": 4.590000152587891, \"ozone\": null, \"noise\": 45.0, \"sox\": null, \"emf_lf\": 1440.56005859375, \"nox\": null, \"ph\": null, \"formaldehyde\": 0.0, \"wifi\": 10.0, \"acc_x\": null, \"led_srv\": 0.0, \"acc_z\": null, \"pm1\": null, \"water_hardness\": null, \"hygro\": 26.0, \"voc\": 252.0, \"q_total\": 6.429999828338623, \"atm\": null, \"led_qbo\": 0.0, \"pm10\": 13.0, \"alkalinity\": null}, \"ts\": \"2019-03-15T12:05:50.000Z\", \"qboIdentifier\": 4487, \"qboOwner\": 4086, \"alarms\": [], \"last_seen\": \"2019-03-15T12:22:30.864Z\", \"qi\": {\"radon\": 8.130000114440918, \"nitrates\": null, \"h2s\": null, \"emf_hf\": 10.0, \"temp\": 0.0, \"chlorine\": null, \"geiger\": 8.359999656677246, \"ammonia\": null, \"pm2_5\": null, \"light\": null, \"nitrites\": null, \"ch4\": 9.979999542236328, \"air_quality\": 9.579999923706055, \"acc_y\": null, \"co2\": 6.0, \"co\": 10.0, \"battery\": 0.0, \"ozone\": null, \"noise\": 7.079999923706055, \"sox\": null, \"emf_lf\": 6.309999942779541, \"nox\": null, \"ph\": null, \"formaldehyde\": 10.0, \"wifi\": 6.0, \"acc_x\": null, \"led_srv\": 0.0, \"acc_z\": null, \"pm1\": null, \"water_hardness\": null, \"hygro\": 7.099999904632568, \"voc\": 6.0, \"q_total\": 6.429999828338623, \"atm\": null, \"led_qbo\": 0.0, \"pm10\": 9.84000015258789, \"alkalinity\": null}}","ERROR_CODE":null}]}
Expected CSV
radon,48.0
nitrates,null
h2s,null
emf_hf,0.0
temp,24.0
etc...
Thanks you very much for the support
Hello,
Please try to use the New Json File wizard to centralize the file connection, XPath query statements, and data structure in the Repository.
TalendHelpCenter:Centralizing JSON file metadata
Best regards
Sabrina