I'm trying to read in JSON file. It has ANSI encoding. The reader throws an error:
"A JSON syntax error was found at line 1, column 49. A sequence of bytes was found which is invalid in the UTF-8 encoding."
Is it possible to get around this?
Page 1 / 1
You can read the JSON with a text file reader, which has a parameter to specify the encoding, and then use the various JSON transformers to turn the text string into features with attributes.
You can read the JSON with a text file reader, which has a parameter to specify the encoding,  and then use the various JSON transformers to turn the text string into features with attributes.
How can this be splitted into separate attributes when read in with text reader?
   },
   {
      "objektokodas" : 50002363,
      "pavadinimas" : "7-2, 7-5, 7-6, 7-7, 7-8, unikalus numeris 1094-0073-0016:0031, plotas 65,35 kv. m, pusr?syje",
      "adresas" : "V. Sopeno g. 12, Vilnius",
      "teritorija" : "Vilnius",
      "weblink" : "https://www.turtas.lt/8952",
      "aukcionas" : {
         "skelbimoPavadinimas" : "Negyvenamosios patalpos",
         "arElektroninisAukcionas" : true,
         "objektoPradineKaina" : 155700,
         "zemesPradineKaina" : null,
         "sklypasNuomojamas" : false,
         "aukcionoData" : "2019-12-09T09:00:00",
         "registracijosPradzia" : "2019-12-02T00:00:00",
         "registracijosPabaiga" : "2019-12-04T23:59:00",
         "weblink" : null
      },
      "statiniai" : ]
   },How can this be splitted into separate attributes when read in with text reader?
   },
   {
      "objektokodas" : 50002363,
      "pavadinimas" : "7-2, 7-5, 7-6, 7-7, 7-8, unikalus numeris 1094-0073-0016:0031, plotas 65,35 kv. m, pusr?syje",
      "adresas" : "V. Sopeno g. 12, Vilnius",
      "teritorija" : "Vilnius",
      "weblink" : "https://www.turtas.lt/8952",
      "aukcionas" : {
         "skelbimoPavadinimas" : "Negyvenamosios patalpos",
         "arElektroninisAukcionas" : true,
         "objektoPradineKaina" : 155700,
         "zemesPradineKaina" : null,
         "sklypasNuomojamas" : false,
         "aukcionoData" : "2019-12-09T09:00:00",
         "registracijosPradzia" : "2019-12-02T00:00:00",
         "registracijosPabaiga" : "2019-12-04T23:59:00",
         "weblink" : null
      },
      "statiniai" : "]
   },Hi @fikusas,
As mentioned by @jdh, you can use JSOn transformers to extract the data.
Â
Â
When reading the JSON as text make sure you are reading the whole file as one attribute value:
Â
Hope this helps.
Hi @fikusas,
As mentioned by @jdh, you can use JSOn transformers to extract the data.
Â
Â
When reading the JSON as text make sure you are reading the whole file as one attribute value:
Â
Hope this helps.
Flattener gives me this:
and ListExploder ends up with this:
Flattener gives me this:
and ListExploder ends up with this:
and if you inspect the results from the ListExploder in de feature information window?
and if you inspect the results from the ListExploder in de feature information window?
I see this:
I see this:
looks good to me...
looks good to me...
AtributeExposer did the trick. Now I can see attributes in Visual Preview. Thanks!
AtributeExposer did the trick. Now I can see attributes in Visual Preview. Thanks!
glad I could help