Filter Nodes based on list of IDs?

pradipti

Hello

I am a total newbie to Orion APIs. So pardon the question if it is too silly. 

I am using Curl to fetch my data from Orion.Nodes.

My project needs me to pull all the nodes based on a list of NodeIds. 

Is there a way i can do a IN clause?

Ex. curl ... /SolarWinds/InformationService/v3/Json/Query?query=SELECT+NodeID,Caption+FROM+Orion.Nodes+Where+NodeID+In+(1,2,3)"

Any alternative suggestions would also do if available. 

I am using basic authentication with username and password.

KMSigma.SWI

I don't work with the curl functionality too often, but "IN" is an accepted filtering format.

Using SWQL Studio, You can test your queries and then copy them for the format you want.

I used the above and got this:

curl.exe -k -u : https://myOrionServer.Domain.Local/SolarWinds/InformationService/v3/Json/Query?query=SELECT+NodeID,+Caption+FROM+Orion.Nodes+WHERE+NodeID+IN+(1,+2,+3)

Most script interpreters have an HTTP Utility function or library.  For Windows-based systems I use the System.Web.HttpUtility and the UrlEncode method:

[System.Web.HttpUtility]::UrlEncode("SELECT NodeID, Caption FROM Orion.Nodes WHERE NodeID IN (1, 2, 3)")