I am using an API that uses OAuth 2.0 for authentication. I would like to use API Query Profile provided in Matillion. How do we integrate access token generation using refresh token logic?

Matillion ETL
1

I am trying to retreive data from an API which uses Outh 2.0 as authentication. The API provides access token which is valid only for 2 hours. We need to write a logic to create new access token using the refresh token passed. I am unsure as to how to integrate this logic when I use the API Query Profile feature of Matillion.

2

i think that should be handled when you setup the Oauth connection, not in the Query profile...

 

0694G00000OxesTQAR_0D74G000008hUGHSA2
0694G00000OxesTQAR_0D74G000008hUGHSA2282×625 26 KB

 

0694G00000Oxes9QAB_0D74G000008hUGHSA2
0694G00000Oxes9QAB_0D74G000008hUGHSA21006×738 72.6 KB

 

The Oauth connection should handle retrieving the access/refresh token for you… I usually try getting the connection up and running in Postman first then I do the same/similar setup in Matillion Oauth before I start building out my api query profiles…