How to parse and extract JSON data

Anonymous — Sat, 16 Nov 2024 04:31:53 GMT

Hi all,

I have a fairly simple issue that I'm struggling to understand. I have a straightforward job (shown below) and I'm trying to loop through the JSON output (also below) and eventually use a tMap and push to a DB. I'm having an issue due to the fact that I don't understand the tExtractJSONFields component thoroughly, nor the difference between the read by options "JsonPath" vs "Xpath". I've attached the job I have (without the tmap), the JSON structure and the desired output. I was hoping to have some help on this as well as some clarification on whether or not my thinking is correct on the components I have selected? Also we're on version 6.2.1.

{
"paging": {
"pageIndex": 1,
"pageSize": 1000,
"total": 113
},
"measures": [
{
"metric": "METRIC1",
"history": [
{
"date": "DATE1",
"value": "VALUE1"
},
{
"date": "DATE2",
"value": "VALUE2"
},
{
"date": "DATE3",
"value": "VALUE3"
}
]
},
{
"metric": "METRIC2",
"history": [
{
"date": "DATE4",
"value": "VALUE4"
},
{
"date": "DATE5",
"value": "VALUE5"
},
{
"date": "DATE6",
"value": "VALUE6"
}
]
}
]
}

Thanks in advance!

Re: How to parse and extract JSON data

Anonymous — Mon, 30 Sep 2019 16:04:17 GMT

Was able to figure this out actually very simply. I should have played with Xpath before asking...

textractjson.PNG

topic Re: How to parse and extract JSON data in Talend Studio

How to parse and extract JSON data

Re: How to parse and extract JSON data