This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Has anyone used SWQL or SQL to update a Bearer Token value for an API Poller?

pattpall over 2 years ago

We have a token that we renew on a regular basis. When we have monthly patching and reboots of systems, the token is expiring during this process. I created a .bat file that can generate a new token and I can parse it out to get the new token. I would like to store it in the existing Bearer Token, or create a new one and update the token being used by the 5 other API Pollers that are using the same Bearer Token. Any ideas on how to update this information with a script?

Top Replies

pattpall over 1 year ago in reply to KMSigma.SWI +1

This is great to hear! We are going to be upgrading from 2020.2.6 to a newer release in August. I will definately investigate this option after the upgrade.

Parents

0 adam.beedell over 1 year ago

I've got this working within the api poller, and fully outside of the api poller, doing it both inside and outside an api poller sounds really hard. I know one way you could do it, but it comes with hefty limitations.

This stuff's easier to chat about imo, feel free to drop a message
Cancel
Vote Up 0 Vote Down

Cancel
0 ChantalDE over 1 year ago in reply to adam.beedell

What is the proper format to pass in the properties? What are the specific key and values needed in the XML?
Cancel
Vote Up 0 Vote Down

Cancel
0 adam.beedell over 1 year ago in reply to ChantalDE

Are you referring to a SWIS verb or whatever query the bearer token is used for?
Cancel
Vote Up 0 Vote Down

Cancel
0 ChantalDE over 1 year ago in reply to adam.beedell
Orion.Credential UpdateCredentials (int id, Dictionary<string, string> properties)

The SWIS verb. I cannot get the second paramater of the function to pass correctly without it throwing an error. I looked at Credential Management · solarwinds/OrionSDK Wiki · GitHub, for what keys it requires. When i formatted it like this as an xml doc first, it threw some sort of error for not having an "add" function which made me think it indeed does want it as a dictionary. But everytime i tried pass a dictionary it told me it was the incorrect format.
How am i supposed to pass the xml string in a dictionary format?

If you got it working, can you show me an example format?
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 ChantalDE over 1 year ago in reply to adam.beedell
Orion.Credential UpdateCredentials (int id, Dictionary<string, string> properties)

The SWIS verb. I cannot get the second paramater of the function to pass correctly without it throwing an error. I looked at Credential Management · solarwinds/OrionSDK Wiki · GitHub, for what keys it requires. When i formatted it like this as an xml doc first, it threw some sort of error for not having an "add" function which made me think it indeed does want it as a dictionary. But everytime i tried pass a dictionary it told me it was the incorrect format.
How am i supposed to pass the xml string in a dictionary format?

If you got it working, can you show me an example format?
Cancel
Vote Up 0 Vote Down

Cancel

Children

0 adam.beedell over 1 year ago in reply to ChantalDE

You may be able to skip this step by generating the bearer in a login step, then turning it into a variable for reuse within the API poller, however if this method is the required one, I'll take a look when I can, Got some UTF8 code in PS laying around. The SWQL studio expanded api field should have a description of the format required
Cancel
Vote Up 0 Vote Down

Cancel