ADF Expression Issue URGENT PROD ISSUE..please help!

Question

ADF Expression Issue URGENT PROD ISSUE..please help!

Mike Kiser 1,536

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

0 comments

Answer accepted by question author

MartinJaffer-MSFT 26,161

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?

Mike Kiser 1,536 Reputation points

2021-02-09T19:09:22.8+00:00

Hey @MartinJaffer-MSFT ,
I think you are right....I am trying to duplicate the functionality of what I am seeing in Postman as shown in the attachment. However, I can hit send on Postman and the phone number will be updated in the Ceridian UI. However, when I run the Web Activity with the same Body, it doesn't update the phone number. Let me look into this further; its one of those very perplexing issues. I was hoping it was the "incomplete" Link but as you mentioned that doesn't seem to be the root cause now, unfortunately. Thanks for your quick response!
Mike Kiser

1 additional answer

Your answer

Mike Kiser 1,536 Reputation points

2021-02-09T19:09:22.8+00:00

Hey @MartinJaffer-MSFT ,
I think you are right....I am trying to duplicate the functionality of what I am seeing in Postman as shown in the attachment. However, I can hit send on Postman and the phone number will be updated in the Ceridian UI. However, when I run the Web Activity with the same Body, it doesn't update the phone number. Let me look into this further; its one of those very perplexing issues. I was hoping it was the "incomplete" Link but as you mentioned that doesn't seem to be the root cause now, unfortunately. Thanks for your quick response!
Mike Kiser

Answer 1

Nasreen Akter 10,896 Volunteer Moderator

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!

Mike Kiser 1,536 Reputation points

2021-02-09T19:12:45.84+00:00

Hi @Nasreen Akter ! Thanks, I incorporated this into my pipeline. The URL is acting as it should it appears, however I am not able to duplicate what I am successfully able to do in Postman. Thanks for your fast reply! I will keep frantically searching for the cause.
Thanks so much!
Mike Kiser
Mike Kiser 1,536 Reputation points

2021-02-10T15:00:43.177+00:00

Hi @Nasreen Akter !

I need to add another parameter; what does the %2C actually do? I can't find it in the documentation.

tStatuses%2C','Contacts')

Thanks!
Mike
Nasreen Akter 10,896 Reputation points Volunteer Moderator

2021-02-10T15:44:37.237+00:00
Hi @Mike Kiser , %2C is a URL encoding for comma ,. The following expression is equivalent to ...?expand=EmploymentStatuses,Contacts,AnotherParam.

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

Thanks!
Mike Kiser 1,536 Reputation points

2021-02-10T17:30:51.097+00:00

Awesome!! Thanks! @Nasreen Akter

Share via

ADF Expression Issue URGENT PROD ISSUE..please help!

1 additional answer

Your answer