@concat Expression Issue in ADF Pipeline as Variable

Mike Kiser 1,536 Reputation points
2021-05-17T16:00:46.29+00:00

Hello! @Nasreen Akter @KranthiPakala-MSFT @MartinJaffer-MSFT

Good morning, I have the following @markus.bohland@hotmail.de expression:

@markus.bohland@hotmail.de ('https://usconfig60.dayforcehcm.com/Api/Battelle/V1/Employees/', item().employeeid, '?expand=Contacts')

In the debugger it is only showing:
"https://usconfig60.dayforcehcm.com/Api/Battelle/V1/Employees/011216"

and NO ?expand=Contacts at the end. Please tell me what am I doing wrong in the @markus.bohland@hotmail.de expression?

Thanks!
Mike

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

Accepted answer
  1. Mike Kiser 1,536 Reputation points
    2021-05-17T16:42:25.337+00:00

    I found it, thanks! It was an extra space before the ? Mark.....

    These types of errors are so time consuming lol

    Mike

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.