topic JSON To Excel in Talend Studio

JSON To Excel

Anonymous — Mon, 30 Dec 2019 06:00:00 GMT

Hi Team,

I have a JSON File like the follows and I want to convert that as an Excel file.

JSON File:

{
"_id": "12dhgui5665553gk",
"userName": "xyz@gmail.com",
"loginTime": "2019-11-11",
"clientLocalTime": 1576590800541,
"offsetTimeZone": -480,
"userId": "745475689",
"orgId": "120073",
"orgName": "abc",
"oracleId": "2458",
"entitlements": [
{
"name": "Support Cloud",
"entitlement": 1,
"appType": 118,
"startDate": "2017-12-20",
"endDate": "2020-12-19",
"overrideEndDate": null
},
{
"name": "Marketing Cloud Service",
"entitlement": 1,
"appType": 119,
"startDate": "2019-07-31",
"endDate": "2020-07-30",
"overrideEndDate": null
},
{
"name": "abc",
"entitlement": 1,
"appType": 200,
"startDate": null,
"endDate": null,
"overrideEndDate": "2020-01-31"
}
],
"

To see the whole post, download it here

Re: JSON To Excel

manodwhb — Mon, 30 Dec 2019 07:19:43 GMT

@Suganth ,check the below link ,will help you use tExtractJSONFields.

https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/LcNrhqdlyheCLpwyUwgJQw

Re: JSON To Excel

karthikj18 — Fri, 03 Jan 2020 15:44:58 GMT

tFileInputJSON component is used to read json file, parse it into row output (table format). Its a source component.

tExtractJsonField component parses JSON data, if JSON data comes along with other data columns.

For example assume there are two columns in a mysql table.

column 1, column 2

cust_id, cust_address

1,{ "addr1":"sd"}

2,{ "addr1":"sda"}

Read this table with MySQL input component, and pass the row to tExtractJsonField component and select cust_address column as JSON field. Configure and run after connecting output to tLogRow, now in the output, you will get cust_address json data parsed.

Thanks.