cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

query against Orion API for NCM universal polling status

Hi there

I'm trying to create an automatic job to retrieve data from NCM universal poller daily to create customized report for management. I am fairly new to the SWSQL/SWIS API thing so my query doesn't come back with the result format i want.

 

The query:

https://solarwinds.gellerco.net:17778/SolarWinds/InformationService/v3/Json/Query?query=SELECT+C.Dat...

I just want the data to come back with 3 columns: CustomPollerAssignmentID, DateTime, Status. Instead the data comes in the below format. How do I remove the repeating labels for the results? Appreciate any pointers for this newbie. 

 

{"results":[{"DateTime":"2020-03-11T00:00:00.0000000Z","Status":"12"},{"DateTime":"2020-03-12T00:00:00.0000000Z","Status":"10"},{"DateTime":"2020-03-13T00:00:00.0000000Z","Status":"59"},{"DateTime":"2020-03-14T00:00:00.0000000Z","Status":"18"},{"DateTime":"2020-03-15T00:00:00.0000000Z","Status":"22"},{"DateTime":"2020-03-16T00:00:00.0000000Z","Status":"97"},{"DateTime":"2020-03-17T00:00:00.0000000Z","Status":"128"},{"DateTime":"2020-03-18T00:00:00.0000000Z","Status":"125"},{"DateTime":"2020-03-19T00:00:00.0000000Z","Status":"125"},{"DateTime":"2020-03-20T00:00:00.0000000Z","Status":"100"},{"DateTime":"2020-03-21T00:00:00.0000000Z","Status":"22"},{"DateTime":"2020-03-22T00:00:00.0000000Z","Status":"31"},{"DateTime":"2020-03-23T00:00:00.0000000Z","Status":"118"},{"DateTime":"2020-03-24T00:00:00.0000000Z","Status":"123"},{"DateTime":"2020-03-25T00:00:00.0000000Z","Status":"137"},{"DateTime":"2020-03-26T00:00:00.0000000Z","Status":"129"},{"DateTime":"2020-03-27T00:00:00.0000000Z","Status":"88"},{"DateTime":"2020-03-28T00:00:00.0000000Z","Status":"18"},{"DateTime":"2020-03-29T00:00:00.0000000Z","Status":"21"},{"DateTime":"2020-03-30T00:00:00.0000000Z","Status":"127"},{"DateTime":"2020-03-31T00:00:00.0000000Z","Status":"111"},{"DateTime":"2020-04-01T00:00:00.0000000Z","Status":"114"},{"DateTime":"2020-04-02T00:00:00.0000000Z","Status":"94"},{"DateTime":"2020-04-03T00:00:00.0000000Z","Status":"97"},{"DateTime":"2020-04-04T00:00:00.0000000Z","Status":"16"},{"DateTime":"2020-04-05T00:00:00.0000000Z","Status":"22"},{"DateTime":"2020-04-06T00:00:00.0000000Z","Status":"130"},{"DateTime":"2020-04-07T00:00:00.0000000Z","Status":"136"},{"DateTime":"2020-04-08T00:00:00.0000000Z","Status":"128"},{"DateTime":"2020-04-09T00:00:00.0000000Z","Status":"105"},{"DateTime":"2020-04-10T00:00:00.0000000Z","Status":"35"},{"DateTime":"2020-04-11T00:00:00.0000000Z","Status":"18"},{"DateTime":"2020-04-12T00:00:00.0000000Z","Status":"19"},{"DateTime":"2020-04-13T00:00:00.0000000Z","Status":"136"},{"DateTime":"2020-04-14T00:00:00.0000000Z","Status":"149"},{"DateTime":"2020-04-15T00:00:00.0000000Z","Status":"152"},{"DateTime":"2020-04-16T00:00:00.0000000Z","Status":"148"},{"DateTime":"2020-04-17T00:00:00.0000000Z","Status":"112"},{"DateTime":"2020-04-18T00:00:00.0000000Z","Status":"27"},{"DateTime":"2020-04-19T00:00:00.0000000Z","Status":"28"},{"DateTime":"2020-04-20T00:00:00.0000000Z","Status":"142"},{"DateTime":"2020-04-21T00:00:00.0000000Z","Status":"153"},{"DateTime":"2

 

Labels (5)
0 Kudos
0 Replies