topic Re: Parsing JSON using tExtractJSONFields in Talend Studio

Parsing JSON using tExtractJSONFields

stagliaferri1640766615 — Fri, 15 Nov 2024 22:21:28 GMT

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 — Wed, 16 Nov 2022 09:53:23 GMT

Please change the Json query like the below

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

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

stagliaferri1640766615 — Wed, 16 Nov 2022 10:05:44 GMT

I ve tried, but I got this error:

For input string: "[1437500]"

For input string: "[329280]"

😞

stagliaferri1640766615 — Wed, 16 Nov 2022 10:14:21 GMT

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

stagliaferri1640766615 — Wed, 16 Nov 2022 10:15:00 GMT

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

stagliaferri1640766615 — Wed, 16 Nov 2022 10:21:14 GMT

I replaced [*] with [0]