Json parsing

Anonymous — Sat, 16 Nov 2024 03:34:25 GMT

I am trying to upload a json file and import into a database table.

I started with trying to parse out the json file and I am not sure what I am doing wrong.

Any help would be appreciated.

This is my set up and sample data
[
{
"AssetId": null,
"ScanDate": {
"value": "\/Date(1575688499000)\/",
"DateTime": "Friday, December 6, 2019 10:14:59 PM"
},
"SiteId": null,
"OrgId": 999,
"ScanName": "Vulnerability-DomainControllers",
"ScanId": 8,
"FolderName": "My Scans",
"FolderId": 3,
"Description": "This plugin attempts to determine the type and the version of the remote web server.",
"Plugin Output": "The remote web server type is :\n\nMicrosoft-HTTPAPI/2.0",
"Plugin ID": "10107",
"CVE": "",
"CVSS": "",
"Risk": "None",
"Host": "es-tsv-dcs-101",
"Protocol": "tcp",
"Port": "5985",
"Name": "HTTP Server Type and Version",
"Synopsis": "A web server is running on the remote host.",
"Solution": "n/a",
"See Also": ""
},
{
"AssetId": null,
"ScanDate": {
"value": "\/Date(1575688499000)\/",
"DateTime": "Friday, December 6, 2019 10:14:59 PM"
},
"SiteId": null,
"OrgId": 999,
"ScanName": "Vulnerability-DomainControllers",
"ScanId": 8,
"FolderName": "My Scans",
"FolderId": 3,
"Description": "This plugin attempts to determine the type and the version of the remote web server.",
"Plugin Output": "The remote web server type is :\n\nMicrosoft-HTTPAPI/2.0",
"Plugin ID": "10107",
"CVE": "",
"CVSS": "",
"Risk": "None",
"Host": "es-tsv-dcs-101",
"Protocol": "tcp",
"Port": "47001",
"Name": "HTTP Server Type and Version",
"Synopsis": "A web server is running on the remote host.",
"Solution": "n/a",
"See Also": ""
}
]

The output shows no data and I am not sure why

Re: Json parsing

Anonymous — Thu, 16 Jan 2020 10:21:04 GMT

Hello @jgillman1

You don't need a tExtractJSONfield component to exrtract that JSON file

Use only a tFileInputJSON, i have taken your example and made a big part of the extraction :

- Note that you have blank spaces on some of your json keys,

Make sure to use a bracket structure to identify them correctly.

Regards,

¨Pierre

topic Json parsing in Talend Studio

Json parsing

Re: Json parsing