Get value JSON to create a nested in golang

I’m trying to create dynamically nested json from value FIELD_QUESTION and FIELD_ANSWER in golang. my result json { “jumlahdata”: 2, “result”: [ { “QUICK_DATA_H_ID”: “1”, “ORDER_TRX_H_ID”: “1”, “FIELD_QUESTION”: “FULLNAME”, “FIELD_ANSWER”: “RUBEN”, “DTM_CRT”: “2019-08-28T16:25:15.757Z” }, { “QUICK_DATA_H_ID”: “2”, “ORDER_TRX_H_ID”: “1”, “FIELD_QUESTION”: “ALAMAT_KTP”, “FIELD_ANSWER”: “jalandisana”, “DTM_CRT”: “2019-08-28T16:25:15.757Z” } ], “statusdb”: 200, “statusload”: 200, “statusquery”: 200 } expected…

JSON Array in SQL – Extracting multiple values from JSON array

I have a JSON column [gca] that looks like this [{ “i”:”https://some.image.URL 1″, “u”:”https://some.product.url”, “n”:”Product 1 Name”, “q”:”1″, “sk”:”sku number 1″, “st”:”$499.99″ }, { “i”:”https://some.image.URL 2″, “u”:”https://some.product.url”, “n”:”Product 2 Name”, “q”:”1″, “sk”:”sku number 2″, “st”:”$499.99″ }] I want to extract values specific to position. For example: JSON_VALUE ([gca], ‘$[0].i’) + ‘, ‘ + JSON_VALUE ([gca],…

How to make dictionary data in json format in python

I am new in python and tried to understand the working with dictionaries operations but stuck in between. I have data like below: [{‘mesure’:’10’, ‘name’: ‘mumbai’, ‘age’: ’15’, ‘class’:’kg1′}, {‘mesure’:’20’, ‘name’: ‘hyd’, ‘age’: ’20’, ‘class’:’kg2′},{‘mesure’:’11’, ‘name’: ‘mumbai’, ‘age’: ‘145’, ‘class’:’kg6′}, {‘mesure’:’21’, ‘name’: ‘hyd’, ‘age’: ’20’, ‘class’:’kg2′}, {‘mesure’:’40’, ‘name’: ‘pune’, ‘age’: ’30’, ‘class’:’kg4′}, {‘mesure’:’30’, ‘name’: ‘chennai’,…