Extract Data from json file, name of colum, "12.1"

[rid_rj]

Hi,

I want to extract data from json file, I encountered a problem in extract data because the name of column is "12.1".

I extracted all the others data except this column "12.1", i think the problem in the point and talend can't read this column.

here is an example of data :

{

  "total_count": 2,

  "entries": [

    {

      "id": "1",

      "form_id": "3",

      "date_created": "2020-11-10 15:26:22",

      "5": "Tester",

      "6": "Thompson",

      "9": "",

"12.1": "Yes sign me"

    },

    {

      "id": "2",

      "form_id": "3",

      "post_id": null,

      "date_created": "2020-08-24 14:50:05",

      "5": "Tester",

      "6": "Testcorp",

      "9": "",

      "12.1": "AAAA"

    }

  ]

}

Can you help me please ?

Thank you .

[Anonymous · Accepted solution]

Try this instead of "12.1" in your component.....

".['12.1']"

I've just tested it and it worked for me in 7.3

[rid_rj]

Oh yes great, it work for me too.

Thank you a lot.