I have a JSON like this, { "TotalCount": 2, "Data": [ { "ID": 9663696221792, "Code": "08099991", "Items": [ { "Amount": 5.05, "LineNo": 1 }, { "Amount": 16.08, "LineNo": 2 } ] }, { "ID": 9663696221793, "Code": "08028001", "Items": [ {…
We are trying to Pull AP names and two specific Bssid values out of json files provided by network team, in PowerShell 5.1 Started with the following function to get the names (this works for just the names), but am…
I am looking into iterating json attributes and values from a json file w/out prior knowledge of the schema. I have code that works with many of the json files or downloads I have tested, but draw blanks when it…
I need to extract some informations from a json file using ps. The json has nested components arrays wich can also contain a components array. { "name": "app", "components": [ { "component_name": "comp1", "component_packages": [ "comp1_package1", "comp1_package2" ], "project_id": "1234",…
I'm using az vm list-skus -l australiasoutheast | convertfrom-json to populate a variable (lets call it $skus) so I can use it in a PS script. When $skus is populated, it's contents look like: apiVersions : capabilities : {@{name=MaxResourceVolumeMB; value=256000},…
Given the following JSON: { "Team1": { "John Smith": { "position": "IT Manager", "employees": [ { "name": "John Doe", "position": "Programmer" }, { "name": "Jane Vincent", "position": "Developer" } ] }, "Jane Smith": { "position": "Payroll Manager", "employees": [ {…