how can i parsing json array and create the table on sql server

[Anonymous]

Hello,

 In fact, I just started working with talend open studio for data integration; I want to export a array long json and I want to transform the data coming from JSON by using talend to organize and store them in a sql database and sqlserver

It is necessary that the data in the JSON file be structured in a mysql database according to the same division so I need to load JSON files periodically in a table sql(insert in the same table) in the SQL Server database. Can you explain to me which components with which configuration and  schema I can use?

How I would like the output to look like:

CVE	Scope	debainbug	description	status	fixed_version	urgency

I attach one part short  my jsonfille : https://security-tracker.debian.org/tracker/data/json

I thank you in advance.

I use "Talend open studio for data integration version 7.1.1.2018102681147

Thank you very much for your time and help

Best regard

[Anonymous]

I think this is just a typo 🙂 I confused the exact same thing when I worked on this. The field is "debianbug" not "debainbug".

Good work on extrapolating from my code by the way 🙂

[Anonymous]

Thanks a lot for your time and help 🙂

[Anonymous]

No problem, glad I could help 🙂