API Extract Profile and API Extract component - how to set up Parameter Name and Parameter Value as dynamic job variables

Hi

 

I am building a shared orchestration job that takes the API profile name, API endpoint name and parameters (from a code snippet i.e. 'date=2021-01-01, base=USD') from a metadata table. The most tricky requirement for me is to set up a variable for Params in the Extract Profile and then pass that variable for Parameter Name in API Extract component.

 

I have tried the API Query Component and the parameter Other with values being separated by a comma. However I can't use API Query because I have land the json file in its raw format.

 

Anyone has any ideas how to solve my issue.

 

Many thanks