Skip to main content

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": "\\"
  }
]

Hi there,

SysAid Copilot is here with our AI Magic!

Here is the response we thought might assist you:

>
Love the experience? You can enjoy the full power of SysAid Copilot and reduce your team workload starting today - check it by yourself

Reply