Importing data from Map to JSON output file

tanjaj — Sat, 16 Nov 2024 04:41:40 GMT

Hi guys,

I need help about this case....

I've imported data from xml file, did some calculations and now i want to store data in JSON file in structure like this:

{
"type": "FeatureCollection",
"crs": {
"type": "name",
"properties": {
"name": "urngc:def:crsGC:1.3:CRS84"
}
},
"features": [
{
"type": "Feature",
"properties": {
"city": "Bratislava - Staré Mesto",
"county": "Bratislava I",
"region": "Bratislavský",
"latitude": 48.140589,
"longitude": 17.112327
},
"geometry": {
"type": "Point",
"coordinates": [
17.112327,
48.140589
]
}
},

----------------------------------------------------------------------------------------------

This is what i get:

----------------------------------------------------------------------------------------------

[
{
"type3": null,
"type2": null,
"city": "{\"type\":\"FeatureCollection\",\"crs\":{\"type\":\"name\",\"properties\":{\"name\":\"urngc:def:crsGC:1.3:CRS84\"}},\"features\":{\"type\":\"Feature\",\"properties\":{\"city\":\"Praha\",\"county\":[],\"region\":\"Hlavní město Praha\",\"latitude\":\"50.08455284219091\",\"longitude\":\"14.417782158070091\"},\"geometry\":{\"type\":\"Point\",\"coordinates\":[\"50.08455284219091\",\"14.417782158070091\"]}}}",
"latitude": null,
"name": null,
"county": null,
"region": null,
"type": null,
"type1": null,
"longitude": null
},

I don't need these columns with null and I don't know how to get rid of them.

This is what i have in tWriteJSONFile:

This is my job:

And this is my output file and i think that here is the problem,but just don't know how to resolve it.

if you have any idea i would be more than grateful.

BR,

Tanja

Re: Importing data from Map to JSON output file

Anonymous — Thu, 26 Sep 2019 10:25:12 GMT

Hello,

Please try to replace null with another data or handle the string further after tWriteJSONFile.

Maybe you could add a tJavaRow after tWriteJSONField and do this: output_row.output = input_row.output.replaceAll(",\"*\":\\", "");

Let us know if it helps.

Best regards

Sabrina

topic Importing data from Map to JSON output file in Talend Data Catalog

Importing data from Map to JSON output file

Re: Importing data from Map to JSON output file