Can parameters from a pipeline to be used in the REST Relative URL?

Question

Hi guys, I am new to Azure Data Factory, and recently our client provides a REST API with a signature as an access token. The signature is changing every 15 minutes and combined with key and value and it needed to be hashed to MD5, which I can do as a sequel in the Azure database, in order to be accessed to the API. The hashed code will be following by the base URL.
I used the query in lookup to get the hashcode. However, I find there is no way to put this hashed code into the dataset relative URL as a dynamic thing, which means I can not combine the base URL and hashed code, so no access.
Is there a way to do that? Passing the output value from lookup activity to Relative URL in the dataset?

Answer 1

Hi @Klay Wang ,

Welcome to Microsoft Q&A forum and thanks for reaching out.

In-order to pass the output of your lookup activity (hashcode value ) to RelativeURL of REST dataset, you will have to follow below steps.

1. First declare/create a dataset parameter for your REST dataset as shown below
2. Then you will have use the dataset parameter dynamic expression ( @dataset().hashCode ) in the Relative URL property under Connection tab of your dataset
3. Now when you use this REST dataset in you Copy activity or Web activity under Dataset properties section, you will see the dataset parameter for which you will have to map the Lookup activity output value as show below @activity('LookupHashCode').output.value[0].hashCode

Hope this helps. Do let us know if you have further query.

----------

• Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

Hi @KranthiPakala-MSFT ,
I followed the same steps this window is popping up.

and when I am passing the dummy value 'na', instead of appending the parameter with the base URL it appends the default value and shows the below error.
. Can you please help me resolve this error?