Read an array from a JSON file

[PSantaniello]

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.

[vikramk]

Hi @Paolino Santaniello​ ,

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