ADF Expression Issue URGENT PROD ISSUE..please help!

Mike Kiser 1,536 Reputation points
2021-02-09T18:02:14.123+00:00

Hello
I have the following ADF Expression
@markus.bohland@hotmail.de (variables('UpdateURL'),item().employeeId,'?expand=EmploymentStatuses,','Contacts') and when I run the pipeline it shows the URL I have attached. When I click on it, it does not include the Contacts. Please assist! Thanks!! Mike Kiser

@MartinJaffer-MSFT

and it is 65975-screenshot-2021-02-09-115746.jpg

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
0 comments No comments
{count} votes

Accepted answer
  1. MartinJaffer-MSFT 26,046 Reputation points
    2021-02-09T18:23:41.287+00:00

    Hello @Mike Kiser and thank you for bringing this issue to our attention. I have reproduced the partial hyperlink effect in the output of a Set Variable activity. I understand this has you worried, but unless I am mistaken, it is not nearly as bad as you think.

    This effect is most likely only confined to your ability to click the link. I do not expect it to actually affect the running of the web activity. Could you please confirm the activity results / data are as expected?


1 additional answer

Sort by: Most helpful
  1. Nasreen Akter 10,766 Reputation points
    2021-02-09T18:29:42.303+00:00

    Hi @Mike Kiser ,

    Would you please try to use %2C, instead of comma , at the end of EmploymentStatuses e.g.,

    @concat(variables('UpdateURL'),item().employeeId,'?expand=EmploymentStatuses%2C','Contacts')   
    

    Hope this helps! Thanks!


    If the above response is helpful, please * accept as answer* and up-vote it. Thanks!

    1 person found this answer helpful.