Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
}
],
"
@Suganth ,check the below link ,will help you use tExtractJSONFields.
https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/LcNrhqdlyheCLpwyUwgJQw
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.