topic Flatten JSON Structure in Talend Studio

Flatten JSON Structure

Anonymous — Fri, 23 Jun 2017 12:47:47 GMT

Hi,

I have the following JSON returned from the tRest component. I need extract the data so in essence I have a list of tasks with their respective parent projectID and projectName. How can this be achieved using the tExtractJSONFields component. I ve had about 2 hours experience with Talend so a detailed explanation if possible

{
"data": [
{
"projectID": "573c8fbe001bc563b07a8e1c908bf071",
"projectName": "UK_0182_Maidstone",
"objCode": "PROJ",
"parameterValues": {
"DES Opening Date - Actual": "2015-07-31",
"DES Country": "United Kingdom",
"DES NSC / Importer": "My UK. Ltd",
"DES Format": "Forurteco",
"DES Region": "DEUR"
},
"estStartDate": "2016-05-18T18:52:00:000+0300",
"estCompletionDate": "2016-10-14T15:13:00:000+0300",
"lastUpdateDate": "2017-05-16T12:31:52:074+0300",
"plannedCompletionDate": "2016-10-13T15:21:00:000+0300",
"plannedStartDate": "2016-05-18T02:00:00:000+0300",
"tasks": [
{
"ID": "573c8fbe001bcdeb524c99bf8786f090",
"name": "Confirm orders placed with Supply Chain",
"objCode": "TASK"
},
{
"ID": "573c8fbe001bcc48de510aef0fc1d1c9",
"name": "Review Design Pack and issue to Brand ",
"objCode": "TASK"
}
]
}
]
}

Re: Flatten JSON Structure

Anonymous — Wed, 28 Jun 2017 04:46:28 GMT

Hi,

Could you please also post your expected result on forum?

Best regards

Sabrina

Re: Flatten JSON Structure

Anonymous — Thu, 29 Jun 2017 13:28:09 GMT

Hi,
Example of raw JSON returned from REST API

{
"data": [
{
"projectID": "573c8fbe001bc563b07a8e1c908bf071",
"projectName": "UK_0182_Maidstone",
"objCode": "PROJ",
"parameterValues": {
"DE S Opening Date - Actual": "2015-07-31",
"DE S Country": "United Kingdom",
"DE S NSC / Importer": "My UK. Ltd",
"DE S Format": "Forurteco",
"DE S Region": "DEUR"
},
"estStartDate": "2016-05-18T18:52:00:000+0300",
"estCompletionDate": "2016-10-14T15:13:00:000+0300",
"lastUpdateDate": "2017-05-16T12:31:52:074+0300",
"plannedCompletionDate": "2016-10-13T15:21:00:000+0300",
"plannedStartDate": "2016-05-18T02:00:00:000+0300",
"tasks": [
{
"taskID": "573c8fbe001bcdeb524c99bf8786f090",
"taskName": "Confirm orders placed with Supply Chain",
"objCode": "TASK"
},
{
"ID": "573c8fbe001bcc48de510aef0fc1d1c9",
"name": "Review Design Pack and issue to Brand ",
"objCode": "TASK"
}
]
}
]
}

Need to get this structure
Project ID, Project Name, DE S Country ,Task ID, Task Name

Thanks in advance