Use Variable option for Profile in the API Extract component NOT WORKING properly while Use Variable options for Data Source, Query Params, Warehouse, Database etc. all working well

Matillion ETL
1

Use Variable option for Profile in the API Extract component doesn't seem to work for me. I keep having errors that No API selected. When I select the actual Profile name (instead of Use Variable), it works. How strange all other Use Variable options for Data Source, Query Params, Warehouse, Database etc. all working well. What could I do wrong? or is it some bugs with the Matillion version I am using?

2

I'm having the same issue.

I have a Query Profile and I'm able to assign URI param from a variable by adding the value on the next line into Connection Options:

Other, ParamName = ${var_UserID}

But, Extract Profile doesn't have a Connection Option and URI Params doesn't allow me to use the ${var_UserID} value to populate the param.

Did you find a solution, please?

 

3

Hello CP872896

 

We are aware of this issue and are working on several solutions to fix it. It stems from how the parameter is handled, due to it being resolved at the Project level, whereas the rest of the parameters are only resolved after the Profile parameter is resolved. Basically, all the other parameters in API Extract and API Query rely on the Profile parameter.

 

Regards

Ben Smiles

Matillion Product Team

4

Hello John

 

In API Extract, once the URI parameter has been defined in the API Extract Profile, then the variable can be entered into the URI Params parameter in API Extract by selecting the defined URI parameter from the Profile.

 

I have managed to do this in my Matillion instance, just to make sure.

What version of Matillion ETL are you using?

 

Regards

Ben Smiles

Matillion Product Team