Passing parameters to REST Linked Service in ADF

Question

Hi,

I have a REST api as below :

https://data.fixer.io/api/latest?access_key=4c00166f&base=GBP&symbols=USD

I am trying to parameterize the values for base and symbols, :

the tobaseparameter and tocurparameter are of type string.

When I test the connection, it is is showing this message. It seems to be inserting a quote in the parameters due to which it is giving error.

I am using the actual working access_key.

I will be calling this REST linked service using Copy Data in the pipeline by passing parameters.

Plesae advice how to fix this.

Regards,

Srinivas

Answer 1

From the message you are getting I think that the URL string is not properly constructed since there are unmatched or misplaced characters. Also, the linked service parameters may not be correctly referenced.

You should follow this syntax :

@concat('https://data.fixer.io/api/latest?access_key=', 'your_actual_access_key', '&base=', linkedService().tobaseparameter, '&symbols=', linkedService().tocurrparameter)

Test and tell me ! :)