question

KlayWang-8254 avatar image
0 Votes"
KlayWang-8254 asked KranthiPakala-MSFT commented

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

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?

azure-data-factorypartner-center-apiazure-open-datasets
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @klaywang-8254,

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

    140841-image.png

  2. Then you will have use the dataset parameter dynamic expression ( @dataset().hashCode ) in the Relative URL property under Connection tab of your dataset

    140799-image.png

  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

    140852-image.png


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



  • Please don't forget to click on 130616-image.png and upvote 130671-image.png 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


image.png (16.2 KiB)
image.png (28.9 KiB)
image.png (69.8 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @klaywang-8254,

We still have not heard back from you. Just wanted to check if the above suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @klaywang-8254,

Just checking to see if the above answer was helpful. If it answers your query, please do consider to click 130616-image.png and upvote 130671-image.png for the same as it can be beneficial for other community members. And, if you have any further query do let us know.

Thank you

0 Votes 0 ·