Parsing JSON files

New Contributor

Hi All I am trying to add new key value layer to existing JSON files (SQL logs that will be sent to cloud).

So the current JSON output is like:

[
{
"Column1": ".....",
"session_server_principal_name": "",
"server_principal_name": "....",
"database_principal_name": "",
"target_database_principal_name": "",
"target_server_principal_name": "",
"server_instance_name": "S.....",
"statement": "....."
},

 

I would like to add a parent key values like this:

 

{
"split_events": true,
"events" [
{
"Column1": ".....",
"session_server_principal_name": "",
"server_principal_name": "....",
"database_principal_name": "",
"target_database_principal_name": "",
"target_server_principal_name": "",
server_instance_name": "S.....",
"statement": "....."
},
},

0 Replies