Azure Data Factory @concat expression issue...PLEASE HELP

Question

Hello!
I am getting an error in trying to @markus.bohland@hotmail.de a string in ADF; this is for the BODY of my Web Activity call:

@markus.bohland@hotmail.de (item().FirstName, item().LastName, 'EmploymentStatuses: {
Items: [
{
EffectiveStartDate: ',item().effectiveHireDate)'}
}')

Also, I am hoping I can use item().FirstName to get the values from a prior Lookup......

This is the error that is showing
Invalid
Position 135'concat' is a primitive and doesn't support nested properties

I have worked on this for hours; what I have to do is build up the following for the BODY of my Web Activity : I haven't completed this since I am getting the above error part way through concat'ing this:

{ "FirstName": "Henry",
"LastName": "Loescher",
"EmploymentStatuses": {
"Items": [
{
"EmployeeNumber": "010004",
"EffectiveStart": "2017-01-15T00:00:00",
"EmploymentStatus": {
"XRefCode": "ACTIVE"
}
}

    ]  

}
}

Thanks!
Mike Kiser

Answer 1

Hello @Mike Kiser and welcome back.
I noticed a syntax error, but not sure if it is the cause of your problem. Could you please try the change and let me know?

@Concat(  
item().FirstName,   
item().LastName,   
'EmploymentStatuses: {Items: [{EffectiveStartDate: ',  
item().effectiveHireDate)  
'}}'  
)  

change the ) after effectiveHireDate to ,

@Concat(  
item().FirstName,   
item().LastName,   
'EmploymentStatuses: {Items: [{EffectiveStartDate: ',  
item().effectiveHireDate,   
'}}'  
)