To be honest, building a 3rd party integration into Solarwinds only through direct API edits is pretty challenging, I would say nearly impossible. You will need to have a very deep understanding of the Solarwinds application, the database (they do not publish db information so you will basically only learn by trial and error) and not every table even allows you to create or update entries from the API so you may find limitations there where you get forced into using regular SQL editing, which carries the added risk that once you get everything worked out they could release a new version with changes to the tables that break your integration.

If you are willing to embark on that project I don't know that you will get much support from within Thwack, it's not the kind of "question" that someone would be able to write a simple post and explain for you. If, in the course of your own work, you find a specific API verb that you are having trouble with then it is likely you could get some clarification on the expected syntax etc but questions without specific answers are not likely to get much response.

There are consultants who you could possibly pay to collaborate with you but this would likely be a pretty complex project with a measurable risk of failure, so I know my own employer would be pretty unlikely to take it on without agreeing to some very specific terms regarding billing and such. They tend to stay away from ambiguous things like this.

Thanks a lot for the elaborate explanation, risks, alternate options and potential issues with them.

Is there a mechanism to know if direct edits are allowed using REST APIs for the following tables:

Wireless. (Clients, AccessPoints, Controller, Interfaces and Rouge).

Any example scripts using REST APIs to update any table will get us onboard quickly. We can employ it to try out SQL statements to update the above tables to see if we can make any progress or completely shelve the idea.

Appreciate you sharing the background details about potential changes to database which may cause integration to fail.

If you load up swql studio there is a section called metadata, I don't recall exactly which tables in there would be the ones you need but there are lists of objects and it they have columns for create update read etc that let you know if the api will accept that kind of command for those objects. There's also tables outlining all the verbs and their arguments

Actions

More Like This

Incoming Links

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining.

SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website,
you consent to our use of cookies. For more information on cookies, see our cookie policy.