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

The newer versions (starting in 2022.4) of the platform include some new credential management.

Entity: Orion.Credential

Verbs:

You could look in the credential entity for the API Poller creds you are trying to update and then use the UpdateCredentials verb.

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.

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

What is the proper format to pass in the properties? What are the specific key and values needed in the XML?

Are you referring to a SWIS verb or whatever query the bearer token is used for?

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?

#Documentation: https://github.com/solarwinds/OrionSDK/wiki/Credential-Management

# Connect to the SolarWinds server
$hostname = ""
$username = ""
$password = ""
$swis = Connect-Swis -Soap12 https://$hostname/swvm/services/InformationService -Username $username -Password $password -IgnoreSslErrors



$bearer_token_credset = ""
$bearer_token_desc = ""
$bearer_token = ""

$properties = [System.Collections.Generic.Dictionary`2[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]]::new()
$properties.Add("Name", $bearer_token_credset);
$properties.Add("Description", $bearer_token_desc);
$properties.Add("Token", $bearer_token);


# Define the parameters for the UpdateCredential function
$CredentialID = 201
# Call the UpdateCredential function
Invoke-SwisVerb $swis Orion.Credential UpdateCredentials @($CredentialID, $properties)

This is the error I'm getting:

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

Looks like it wants an input of [in32]ID, @(props) rather than @(id, props)

Updated description with 

1) get URI:
SELECT c.Uri FROM Orion.Credential c where id = target

2) inspect
$cred = Get-SwisObject -Uri $uri -SwisConnection $swis

3) set

$props = @{description = 'test'}

Set-SwisObject -Uri $uri -Properties $props -SwisConnection $swis