Forum Discussion

Rutuja1997's avatar
Rutuja1997
Frequent Visitor
1 year ago
Solved

Expression of type: 'String' does not match the field: 'folderPath'. Expected type is 'object'.

Hi Microsoft folks, I am building a pipeline to copy the latest folder to the lakehouse from SFTP server.It could copy the folder when i entered the folder path manually but couldn't when I passed t...
data engineering
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    Hi Rutuja1997,
    Based on the error " Double quoted string is not allowed"
    Expression of type: 'String' does not match the field: 'folderPath'. Expected type is 'object.

    can you try the below path :

    {
  "folderPath": @concat('Directory_name/', activity('Filter1').output.Value[0].name)
}


     

    If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

  • Rutuja1997's avatar
    Rutuja1997
    1 year ago

    Hi Fabric Community,

    Apologies for late feedback.The issue was solved by using set variable activity.I stored the concatenated string in set variable and passed that in the folder path.That way i could solve that problem.

     

     

     

Vaughan_Brant's avatar
Vaughan_Brant
Regular Visitor
2 months ago

Doesn't work when referencing Variable Library values either. Despite the warning messages the pipeline will save and copy activity does work. It is however, disconcerting that the copy activity shows these errors. 



If I use a Set Variable activity and concat the two values and use that in the copy activity. I don't see the error.

In the Set Variable activity:

@concat(pipeline().libraryVariables.Files_Temp_Path, '/', pipeline().libraryVariables.Files_Temp_Filename)

and in the Copy Data activity:
@variables('FilePath')