Read an array from a JSON file

PSantaniello — Wed, 10 Mar 2021 11:40:58 GMT

Hi everyone,

i'm new in talend.

I'm trying to read a JSON file but I can't read an array. I insert below part of the file structure:

{

"geojson": {

"type": "FeatureCollection",

"features": [

{

"type": "Feature",

"geometry": {

"type": "Point",

"coordinates": [

14.3101919,

40.92249450000001

]

"properties": {

"PROVINCIA": "Napoli",

"REGIONE": "Campania",

"ZONA": "Sud",

"codice_istat": "063002",

"data_presubentro": "09/03/2021",

"label": "AFRAGOLA",

"popolazione": 64797,

"popolazione_aire": 0

}

{

"type": "Feature",

"geometry": {

"type": "Point",

"coordinates": [

16.9122791,

39.1469769

]

"properties": {

"PROVINCIA": "Crotone",

"REGIONE": "Calabria",

"ZONA": "Sud",

"codice_istat": "101001",

"data_presubentro": "09/03/2021",

"data_subentro_preferita": "18/03/2021",

"label": "BELVEDERE DI SPINELLO",

"popolazione": 2258,

"popolazione_aire": 0,

"prima_data_subentro": "14/03/2021",

"ultima_data_subentro": "12/04/2021"

}

I want read the two coordinates and put them in two variables.

Can you help me please?

Thanks everyone.

Re: Read an array from a JSON file

vikramk — Thu, 11 Mar 2021 07:09:07 GMT

Hi @Paolino Santaniello ,

The JSON format is not valid, could you paste valid JSON data

topic Re: Read an array from a JSON file in Talend Studio

Read an array from a JSON file

Re: Read an array from a JSON file