How to update the client secret on ODATA connections

When your current ODATA connection is configured via Azure AD, it can happen that the client secret expires and you need to generate a new one and update your current ODATA connection.The error message that you will see if the client secret has expired is The REST service returned a status code that is not 20x - i.e. not OK - Status code received: 401 UnauthorizedResponse body: {"error":"invalid_client","error_description":"AADSTS7000222: The provided client secret keys for app 'xxxxxxxxx' are expired.

In order to do so, please go through the following steps:

  1. Log in to portal.azure.com.
  2. Click on Azure Active Directory.

In the left panel, click on App Registrations. From the App registrations panel, click on the app that you are currently using for your ODATA connection.

In the left panel, click on Certificates & secrets.

Click New client secret, fill in the Description and Expires fields, and click Add.

Then, you should see the new client secret. Copy the code from the Value field, as you will need it later.

Note: Once the secret is generated, you must copy it and store it somewhere safe, as the key will not be shown again. You would need to generate a new one. 

3. Next, go to your Rapidi account, log in, and open the Connections tab:

  • Click on the pencil icon to edit your connection.
  • Add the client secret to the Password field, then click Save.
  • Once the client secret it added, click on Test to get a final confirmation that the connection is working properly.