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:
- Log in to portal.azure.com.
- 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 on New client secret and fill in the Description and Expires fields and click on Add.
Then, you should see the new client secret. Copy the code that you see in the Value field because you will need it later.
Note: Once the secret is generated, you have to copy it and put it somewhere safe because the key will not be shown the second time. 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 into the Password field and click on Save.
- Once the client secret it added, click on Test to get a final confirmation that the connection is working properly.