How do I use the API or a DB Connect to get current Device Inventory Status?

I am trying to export a list of the Inventory items for a device along with those items current status.

So for example if I have a switch with 2 PSUs I want to export the data for those 2 PSUs and the current status of those PSUs.

Using the /api/v0/inventory/:hostname/all API endpoint I am able to get the Inventory Items.

But how do I get the status of those items?

Thanks

pete