skip to Main Content

Select hierarchical JSON as table in PostgreSQL

I'm trying to select this hierarchical JSON as a table in PostgreSQL The JSON script: '{"NODES":[{"DESC_D":"fam","SEQ":"1","ID":"2304500","NODES":[{"DESC_D":"test 1","SEQ":"2.1","ID":"5214","NODES":[{"DESC_D":"test 1.1","SEQ":"3.1","ID":"999"}]},{"DESC_D":"test 2","SEQ":"2.2","ID":"74542"}]}]}' The output I'm trying to get (click this link) This is a solution a friend wrote. It does the required but…

VIEW QUESTION

How to deserialize this JSON to a List?

I have an issue with deserializing the JSON file from the web to a List. My code is down below, but it does not execute and shows Newtonsoft.Json.JsonSerializationException. static void Main(string[] args) { List<Root> coinDatas = new List<Root>(); ; callApi(coinDatas);…

VIEW QUESTION

JSON wrapped in NULL?

I'm using the API of an affiliate network (Sovrn), expecting to retrieve a product's specification using the URL. As per their documentation, I use: url = 'URL-goes-here' headers = { "accept": "application/json", "authorization": "VERY-HARD-TO-GUESS" } response = requests.get(url, headers=headers) The…

VIEW QUESTION
Back To Top
Search