skip to Main Content

Parse multilevel json into a csv using jq tool in unix

I have a multilevel json like so: { "id": "id123", "details": { "prod": "prod123", "etype": "type1" }, "accounts": [ { "bankName": "bank123", "accountType": "account123", "openingBalance": "bal123", "fromDate": "2023-01-01", "toDate": "2023-01-01", "missingMonths": [], "transactions": [ { "dateTime": "2020-12-01", "description": "a very…

VIEW QUESTION

Getting all the information out of a JSON in PostgreSQL

I have a JSON that looks like this: "[{""email"": ""AAA"", ""updated_at"": ""AAA"", ""net_income_verified"": AAA}, {""email"": ""BBB"", ""updated_at"": ""BBB"", ""net_income_verified"": BBB}, {""email"": ""CCC"", ""updated_at"": ""CCC"", ""net_income_verified"": CCC}]" And I would like to get all the data from all the fields so…

VIEW QUESTION
Back To Top
Search