Parsing JSON using tExtractJSONFields

[stagliaferri1640766615]

Hello 🙂

i am parsing a JSON file using tExtractJSONFields which has this structure:

 "applications": [

    {

      "id": 12345678,

      "candidate_id": 9876543,

      "location": {

        "address": "Nowhere"

      },

"source": {

        "id": 678543,

        "public_name": "Source of job"

      },

      "jobs": [

        {

          "id": 44444444,

          "name": "CEO of company"

        }

      ],

      "job_post_id": 444555555

]

in this way:

then I use a tmap and I am loading the data in a sql table.

I don't understand why job_id nad job_name are not stored (but values are in the JSON)

but for example, source and source_id are ok.

How can I fix it to have also job_id and job_name?

thank you very much

sergio

[Anonymous · Accepted solution]

Please change the Json query like the below

job_id --> "$.jobs[*].id"

job_name --> "$.jobs[*].name"

[stagliaferri1640766615]

I ve tried, but I got this error:

For input string: "[1437500]"

For input string: "[329280]"

😞

[stagliaferri1640766615]

oooh got it, it can not be INT , I fixed it

[stagliaferri1640766615]

the value are stored like this: [1459923], I will find a way to remove it

[stagliaferri1640766615]

I replaced [*] with [0]