I have a JSON array which looks like this - [ {name: 'Alex', date: '05/17/2023 10:32 PM', id: '00153168', priority: '3-Medium'}, {name: 'Peter', date: '05/17/2023 11:32 PM', id: '00153169', priority: '3-Medium'} ] Expected : { name : ['Alex','Peter'], date :…
I have a JSON file that contains nested key-value pairs. My JSON file looks like this { "TagName1":{ "TestCaseName1":{ "Status":"pass", "RunTime":"063045" }, "TestCaseName2":{ "Status":"fail", "RunTime":"064045" } }, "TagName2":{ "TestCaseName3":{ "Status":"pass", "RunTime":"073045" }, "TestCaseName4":{ "Status":"fail", "RunTime":"074045" } } } I want…
I have a script, where I get my output using pscustom object (the one with the value -eq 0.0) but is there a way to join $netscaler name+$cmponentname+$name in a single variable ? $Components = @("virtualserver", "services", "servicegroup", "contentswitch") foreach…
I have an object that can have multiple named "url" keys, that they are on different levels of depth, they can change. I need that every key named url found, replace its value for a new one. -1 Using map:…
I have the following json and want to create a list from the display names, the json can have many different types not necessarily only 2: {"data": [ { "types": { "1": { "display_name": "123", }, "2": { "display_name": "321",…
Append an object to a existing dictionary embedded in a json file. I have a sample json file which I am reading using below code. Please check the code and sample json file here. with open('sample.json') as fp: dictObj =…
I have id at the top level document and id at sub document. The subdocument id is not getting populated. My JSON Document:- { "_id": "a392ec9c-4f5c-411a-8599-928c5ce6b18d", "name": "polName", "rules": [ { "t": "TestRule", "principals": [ { "name": "Test Report", "id":…
I have JSON data files that I'd like to modify somewhat. From: { "alpha": "...", "beta": [ ... ], "delta": { ... }, "gamma": "..." } to: { "alpha": "...", "epsilon" : { "beta": [ ... ], "delta": { ...…
Looking forward to an approach to convert simple JSON objects to Key value pair JSON objects using Logic Apps. Like: { "FirstName": "ABC", "LastName": "123", "MiddleName": null, } to [ { "Key": "FirstName" "Value": "ABC" }, { "Key": "LastName" "Value":…
I have a dictionary that looks like the following: { "DICT_KEY1": {"nestKey1": "val", "nestKey2": "val", "nestKey3": "val"} } If I have a function that takes in a parameter like the dictionary above, How would I access the key "DICT_KEY1" (not…