I'm using Instana to deliver view stats on my site, each daily file looks like this: { "items" : [ { "name" : "page1.htm", "earliestTimestamp" : 1675222177839, "cursor" : { "@class" : ".IngestionOffsetCursor", "ingestionTime" : 1675292168217, "offset" : 1 },…
I am trying to access the Scryfall API and perform the following request: https://scryfall.com/docs/api/cards/collection For this I have set up an Angular project that can be found on a public GitHub: https://github.com/ProgFroz/scryfall_test_public I have a NodeJS server running on port…
I am trying to filter out one particular element out of a json file using Python3. This is what I have tried: #Fetch rain radar (forecast) imagery url_rain_forecast = 'http://datapoint.metoffice.gov.uk/public/data/layer/wxfcs/all/json/capabilities?key=key' response_rain_forecast = requests.get(url_rain_forecast, headers=headers, timeout = 60) print(response_rain_forecast) rain_forecast =…
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…