Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
PSantaniello
Contributor
Contributor

Read an array from a JSON file

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.

Labels (4)
1 Reply
vikramk
Creator II
Creator II

Hi @Paolino Santaniello​ ,

 

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