I have an array of JSON that looks like this: [ {"test":"a","test1":"1","test2":""}, {"test":"b","test1":"","test2":"hi"} {"test":"","test1":"3","test2":""} ] I want it to look like this if there are any JSON strings with "" values [ {"test":"a","test1":"1","test2":null}, {"test":"b","test1":null,"test2":"hi"} {"test":null,"test1":"3","test2":null} ] >Solution : Loop through the array, then loop through all the properties in each object. Test if the value… Read More How do I replace any instance of "" with null in an array of JSON strings in typescript?

What I’m doing wrong when I try to get some objects into an array of objects based in another array of objects (that is result of selection of user): //Original array let obj1 = [ {"Nome": "João", "Idade": 16, "Fone 1": "55 5555"}, {"Nome": "Pedro", "Idade": 16, "Fone 1": "55 5555"}, {"Nome": "Marcos", "Idade": 16,… Read More Removing selected objects from array of objects

brand new to Javascript. I have figured out how to get data back from a Monday.com board, and it is returned as a JSON value like this: { "boards": [ { "items": [ { "column_values": [ { "id": "location", "title": "Location", "type": "location", "text": "Cape Town, South Africa" } ] }, { "column_values": [ {… Read More Store certain values in JSON into parameters in React

I’m trying to read the below highlighted value: by reading str.hourly[2]["rain.1h"] but getting Undefined error. What is the correct way to access that value? Thanks in advance! >Solution : Simply: str.hourly[2]["rain"]["1h"]; Since rain is an object has 1h property

I am using nodejs + mysql, and I want to show a date in a json api. The date is not a string, is a mysql date type. E* I can’t select date(columnname) because I am already selecting everything from the table. This is my query: var query_ = ` SELECT p.*, GROUP_CONCAT(ss.name) AS technologies… Read More Split string to only get positions 1, 2 and 3, removing everything else

I have an input field in my React app where I can select/drag’n’drop files from my PC. The file data looks like this: { path: "/test/metadata.json", lastModified: 1657787087977, name: "metadata.json", size: 10, type: "application/json", webkitRelativePath: "" } Having selected a file, I’m trying to perform a fetch request if the file is of type JSON… Read More Fetching data from a JSON file on my PC and using it in React

I have this sample return json: message_response_json = {"details": [ { "orderId": "1", "accountId": "1", "orderStatus": "CANCELED" }, { "orderId": "2", "accountId": "1", "orderStatus": "SETTLED" }, { "orderId": "3", "accountId": "1", "orderStatus": "FUNDED" }, { "orderId": "4", "accountId": "1", "orderStatus": "FUNDED" }, ]} I want to only get the list of orderIds with the orderStatus… Read More get only one value in element in array of elements python

dic = [{‘one’:1, ‘two’:’t’, ‘three’: {‘three.1’: 3.1, ‘three.2’: ‘3.2’ }}] Desire Output, [{"one":1, "two":"t", "three": {"three.1": 3.1, "three.2": "3.2" }}] Tried Code: ast.literal_eval(json.dumps(dic[0])) here, Json converting the quotes but also changing the type to str. So I applied ast to change type. at end getting the same output with single quotes. Output of Json.dumps: json.dumps(dic[0])… Read More replace dictionary single quotes to double

I am new to JavaScript and am looking for a way to: first, extract values from a desired key in a complex JSON object. Second, if the value does not equal a given string, print the parent key. Here is a simplified JSON object that needs to be parsed. There are many more entries in… Read More Extracting values from complex JSON in JavaScript

I have file that has ~35k lines and I need to only change values for certain items in key base1, as below. I need to change id and title values and save the same file. Like, title becomes "title abc" and id becomes "789". ex, before: "base1": { "base1base2": [ { "id": "123", "title": "title… Read More Update key values in file of json, maintain file integrity, Python 3