I am looking a way to get the specific value from complex json without creating the Model class. I am able to read via Newtonsoft but with model and since I have many different json model,is it possible to get…
[ [ { "indexnum": 677, "type": 1, "user": 54846, "push": 0, }, { "indexnum": 2321, "type": 1, "user": 77924, "push": 0, } ] ] import json with open('./79553/combined.json', 'r',encoding='UTF-8') as infile: my_data = json.load(infile) datalist1 = [] print(my_data['indexnum']) That is…
I have the below CSV file format: title studentName studentID Science 'James','Jones' 'JA002','JO101' I want to convert this to the below JSON format: [{ "title": "Science", "students":[ { "studentname":"John", "studentid":"JO12" }, { "studentname":"James", "studentid":"JA23" } ] }] How can I…
i'm having a little problem, trying to optimaze quering data from a unstructured json field. By unstructured i mean, each json field is unique on each row. by using this query, i want to collect all the keys which are…
I have two similar calls on a Blazor page: private async void SelectQuiz() { List<String>? ls = await httpClient.GetFromJsonAsync<List<String>>("api/BgQuizAnswer/GetBgQuizList"); String? txt = await httpClient.GetFromJsonAsync<String> ("api/BgQuizAnswer/GetHello"); The first call works fine while the second one fails. [HttpGet] [Route("GetBgQuizList")] public ActionResult<List<String>> GetBgQuizList()…
I have a need to generate a three level nested JSON payload out of Oracle tables. I have described two approaches I have used to accomplish this and neither of them work. Please advise where am I going wrong! Approach…
i am running a query on azure workbook that gives costs for on-demand and spot instances month to date within a number of resource groups. i want to have this data shown in bar chart as well where it could…
I have a existing .json file in GitHub similar to below. { "quiz": { "sport": { "q1": { "question": "Which one is correct team name in NBA?", "options": [ "New York Bulls", "Los Angeles Kings", "Golden State Warriros", "Huston Rocket"…
I run this error when I tried to parse a JSON response returned by an open API: keyNotFound(CodingKeys(stringValue: "name", intValue: nil), Swift.DecodingError.Context(codingPath: [], debugDescription: "No value associated with key CodingKeys(stringValue: "name", intValue: nil) ("name").", underlyingError: nil)) This happens in the…
I am pretty new to JOLTtransform and I'm trying to understand it better. I tried alot of stuff but i didnt work out. I try to take a List of JSONS and Split them so i can put it in…