Help to integrate file

Anonymous — Sat, 16 Nov 2024 06:19:27 GMT

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

Re: Help to integrate file

Anonymous — Tue, 02 Apr 2019 09:35:31 GMT

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

topic Help to integrate file in Talend Studio

Help to integrate file

Re: Help to integrate file