I am pulling asset data from SysAid Rest API into Microsoft Power Automate. I am looking for a better way to parse the data. Currently, I am having to parse the json of the output and then filter the data by each keyCaption value and append that to an array variable. For a amount of assets, currently we’re just over 1000 assets, this process can take upwards of 24 hours to collect my asset variables. Is there a better way to parse the data from the start to get the key values into usable dynamic feilds faster below is a sample of the parse json output of the data.
p
{
"info": f
{
"key": "device_status",
"value": 0,
"valueClass": "",
"valueCaption": "",
"keyCaption": "Status"
},
{
"key": "account_id",
"value": "cmhcm",
"valueClass": "",
"valueCaption": "cmhcm",
"keyCaption": "Account"
},
{
"key": "serial",
"value": "",
"valueClass": "",
"valueCaption": "",
"keyCaption": "Serial"
},
{
"key": "model",
"value": "",
"valueClass": "",
"valueCaption": "",
"keyCaption": "Model"
},
{
"key": "company",
"value": 0,
"valueClass": "",
"valueCaption": "",
"keyCaption": "Location*"
},
{
"key": "ip_address",
"value": "97.87.24.210",
"valueClass": "",
"valueCaption": "97.87.24.210",
"keyCaption": "IP Address"
},
{
"key": "computer_type",
"value": null,
"valueClass": "",
"valueCaption": "",
"keyCaption": "Type"
},
{
"key": "users",
"value": "00-BE-43-60-06-90",
"valueClass": "",
"valueCaption": "",
"keyCaption": "Users"
},
{
"key": "manufacturer",
"value": "",
"valueClass": "",
"valueCaption": "",
"keyCaption": "Manufacturer"
}
],
"id": "00-BE-43-60-06-90",
"name": "",
"group": "\\"
}
]