JSON file – how to delete entire node that contains a string
I have a JSON file: { "JSONS" : [ { "id" : "ToRemove", "First" : [ { "id" : "geo", "Name" : "Person1", "model" : [ ], "adjustments" : [ { "uid" : "3", "name" : "4s", "value" : "1"…
Deserializing array of JSONElement back to a concrete list not working when using System.Text.Json
I have a problem when deserializing an object. The object has a property (data) that is a list of JSONElement. I'm doing: using var doc = JsonDocument.Parse(JsonSerializer.Serialize(result)); var e = doc.RootElement.GetProperty("data"); var data = JsonSerializer.Deserialize<List<MyItem>>(e); The serialized result variable has…
How can I convert this Json array in SQL Server?
I have an array like this and I want to extract its count into a single array. Can I do this in SQL Server? [ { "ItemName": "ITEM1", "Details": [ { "column1": "2021/Apr", "Count": 10 }, { "column1": "2021/May", "count":…
Json – Results not displayed in API call
I am trying to call weather API, but for some reason I could not see the results both in console and the webpage after entering a specific city I called <div id="results"></div> and made sure to declare it in my…
Format json output programatically in javascript/typescript
How can I format the json output file to format the content like in the example? [ {"keyA1": "value1", "keyA2": "value2", "KeyAN": "valueN"}, {"keyB1": "value1", "keyB2": "value2", "KeyBN": "valueN"}, {"keyC1": "value1", "keyC2": "value2", "KeyCN": "valueN"}, ] There are a ton…
SQL Server : parsing a JSON column with irregular values
I have SQL Server 2016 (v13) installation where I am trying to parse a column with JSON data. The data in the column RequestData is in the following format: [ { "Name": "SourceSystem", "Value": "SSValue" }, { "Name": "SourceSystemId", "Value":…
Json – How display an image in a div in html using response from fetch data from api?
I'm trying to display an image in a div in html. I used fetch to get the json data from the api : https://collectionapi.metmuseum.org/public/collection/v1/objects/435828. The response gives json date with the image url named "primaryImage". I'm able to display it…
turning the json result into dynamic
i have a very complicated issue for a beginner. firstly I have this result from json { "success": true, "timeframe": true, "start_date": "2018-01-01", "end_date": "2018-01-05", "source": "TRY", "quotes": { "2018-01-01": { "TRYEUR": 0.21947 }, "2018-01-02": { "TRYEUR": 0.220076 }, "2018-01-03":…
Json – javaScript: mouseenter/out event javaScript?
I want to make hover effect whit javaScript I use mouseenter and mouseout event to make button show the content in mouse enter and remove content in mouse out, the problem is the content in mouse enter disappear if the…
Json – How to use `select` within a jq –stream command?
I have a very large json document (~100 GB) that I am trying to use jq to parse out specific objects that meet a given criteria. Because it is so large, I won't be able to read it into memory,…