In this guide, reference here: https://redshiftsupport.matillion.com/customer/portal/articles/2312291-setting-up-oauth-in-matillion-etl-for-redshift
It says only some certain APIs are supported OAuth. Is it possible to configure OAuth in any other custom API profile? Is there any guide on this?
1 Community Answers
Kalyan Arangam —
Matillion has built-in workflow for Oauth for the components listed in that article.
If you are dealing with another API that supports Oauth, you may use the following approach -
1. Use something like Google Playground to authenticate and generate a refresh token. You is generally a one-time requirement.
2. You then use a Python component to refresh the OAuth token and copy the Refresh token into a variable
3. Pass the variable into the API Query component to use with the request.