I have a database that returns data as a tree like this: '((7 "vince" "[email protected]" "space" "no value" 1) (8 "vince" "[email protected]" "place" "no value" 1) (9 "Smith" "[email protected]" "now" "no value" 1)) The second column is first name and…
I have this very simple JSON string: { "data": { "id": 33306, "sport": { "id1": "FB", "id2": "HB" } } } I can't understand how to return a datatable from this string. I have tried to use this code but…
I have a ForumController where I have a function ChangeOrder with a ChangeOrderDto. Here is the code: [HttpPost("change-order")] public async Task<ActionResult> ChangeOrder([FromBody] ChangeOrderDto[] forums) { foreach (var dto in forums) { var forum = await context.Forums.FindAsync(dto.Id); if (forum is not…
search = """ [{"text":"Dolores Keane - "Craigie Hills" (1982)"}] """ print(loads(search)) # Returns Error print(search.replace('"',"'")) # Turns all double quotes to single quotes, both the escaped and non escaped ones Here's my issues: I just don't know how to load…
I have two JSON files: $ jq . a.json b.json { "id": "ZGVhZGJlZWY=", "name": "first file", "version": 1, "description": "just a simple json file" } { "version": 2, "name": "fake name", "dependencies": [ 4, 2 ], "comment": "I'm just sitting…
I am building api in laravel and I am catching exceptions if they occur and I am returning them as response. The problem is that I only want to show them in my dev enviroment. Setting APP_DEBUG=false doesn't solve the…
Working with a nested arrays like this: [ { "value1": "Data1-0", "value2": "Data2-0", "nArray": [ {"nValue1": "nData1-0a","nValue2": "nData2-0a"}, {"nValue1": "nData1-0b","nValue2": "nData2-0a"}, {"nValue1": "nData1-0c","nValue2": "nData2-0a"} ], "value3": "Data3-0" }, { "value1": "Data1-1", "value2": "Data2-1", "nArray": [ {"nValue1": "nData1-1a","nValue2": "nData2-1a"}, {"nValue1": "nData1-1b","nValue2":…
I have two JSON objects. I want to merge them but wherever the keys are the same the field obj_count should be summed. Is there any way around it in python? Here is an example of it: This is the…
I'm trying with python to convert a nested json content into a dataframe : { "end_date":"2023-02-02-00:00", "price":{ "2023-01-30":{ "CHFEUR":{ "close":0.99612, "high":0.99939, "low":0.99408, "open":0.99925 }, "CHFUSD":{ "close":1.08098, "high":1.08884, "low":1.08041, "open":1.08579 }, "EURUSD":{ "close":1.08518, "high":1.0914, "low":1.08393, "open":1.08609 } }, "2023-01-31":{ "CHFEUR":{ "close":1.00489,…
I'm looking for a solution to add a new attribute with a JSON object value into an existing JSON file. My current script: if [ ! -f "$src_file" ]; then echo "Source file $src_file does not exists" exit 1 fi…