I have an older version of Matillion i.e. 1.44 where the latest options are not available. I was able to generate the rsd. However, I do not know what options I need to choose to pass the headers authentication. I need to pass the api key in header as well as a query. What authentication options should I choose in the parameter section in the image below to address my needs? I basically need to choose an authentication method, and pass a query and api key as part of a header
@Bryan Any advice please?
Hi @AR253900
Please check out this documentation: https://documentation.matillion.com/docs/2836045 For the most part the doc should still pertain to the older profiles where "<rsb:" is used instead of the new "<api:" in your case these are interchangeable. So where they specify "<api:" just swap it for the "<rsb:" if that's what your API Profile is using.
It has an example of where Headers are defined in the profile and the value being assigned to the particular header is being passed into it at the time of connection. You can pass the api key in at connection or as a input parameter. Either way the api key is being passed in. It's up to you to determine how you want to pass it in. If you decide to go with the _connection option then you would set the api key in the Connection Options of the API Query component. If you use the _input method then you will pass it in using the where statement within the query you defined in the API Query. As an example of using the _input method would be to flip the API Query mode to advanced and in the query you do something like this:
SELECT x, y, z
FROM YourApiProfile
WHERE api_key = 'your api key is passed in here'
I hope this helps! Have a great weekend if I don't hear from you!
