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.DateTime,C.Status+FROM+Orion.NPM.CustomPollerStatistics+C+WHERE+C.CustomPollerAssignmentID='4a8b3a15-4b62-42e6-8e2e-4e4baf9649ec'+ORDER+BY+C.DateTime
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
