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?