I am trying to create some integrations with a local system and seem to be having issues with a REST API call using the Query options. I am trying to get the most basic information that is found for all assets: Computer ID, Computer Name, Last Report Time, IP Address, and OS
Here the call that I am using:
https://SERVER:52311/api/query?output=json&relevance=(ids of it, names of it, last report time of it, concatenation " " of values of result (it, bes properties “IP Address”), operating system of it) of bes computers
It returns about 10% of the total assets and then I get
Singular expression refers to nonexistent object.
I went through process of elimination and when I remove “operating system of it” I get the data for all the data for all the assets.
I looked at the machines in the console and expanded by OS, I removed the one machine with and it did not change. I removed the 13 machines with and it seemed to pull more assets but still ended up with the same error message at the end. I noticed a couple assets have for computer ID too so not sure if its related to that.
Is there any way to do the calls if there are assets in this state, shouldnt it just skip over them if the value does not exist?