We are looking to integrate our 3rd party application with Solarwinds with REST API.

We are looking to integrate our 3rd party application with Solarwinds with REST API. Trying to test with the following query via POSTMAN but unable to retrieve any details from Solarwinds.

https://<MainpollerIP>:17778/SolarWinds/InformationService/v3/json/Query?query=SELECT NodeID,
,DateTime
,AvgResponseTime
,MinResponseTime
,MaxResponseTime
,PercentLoss
,Availability
,Archive
,Weight
FROM Orion.ResponseTime

Find more posts tagged with

rest api

integration

postman

smartinsight

Accepted answers

All comments

tony.johnson

Do you see any error messages? I would expect the query to look like this example from the docs https://github.com/solarwinds/OrionSDK/wiki/REST

https://10.199.20.201:17778/SolarWinds/InformationService/v3/Json/Query?query=SELECT+Uri+FROM+Orion.Pollers+ORDER+BY+PollerID+WITH+ROWS+1+TO+3+WITH+TOTALROWS

m_roberts

The string is not correctly formatted for Postman and I see you had an erroneous ,

I have put a screenshot of the Params section which shows the string that worked for me an I am assuming you have Basic Auth configured:

SELECT+NodeID,DateTime,AvgResponseTime,MinResponseTime,MaxResponseTime,PercentLoss,Availability,Archive,Weight+FROM+Orion.ResponseTime

beethikaDas

Yes, We have the basic authentication. let me try out the format that you have shared. Thank you.

tony.johnson

As a tip, you can use SWQL studio to copy a query in the format needed as shown here https://thwack.solarwinds.com/product-forums/the-orion-platform/f/orion-sdk/94159/is-there-an-api-with-an-example-that-i-can-use-over-rest-that-can-basically-pull-a-report-in-a-csv-format/297643#297643

beethikaDas

We are getting the following error.

Is there any specific authorization required for the connection to be established?