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.

     

     

     

nilendraFabric's avatar
nilendraFabric
Super User
1 year ago

Try this

 

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

Rutuja1997's avatar
Rutuja1997
Frequent Visitor
1 year ago

Hi Nilendra, Thank you for replying promptly.I tried above suggestion it didn't work.It is showing 

I tried this way as well didn't work 

 

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    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.

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      1 year ago

      Hi Rutuja1997,

      we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

      If the response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

       

      Thank You.

       

      • v-aatheeque's avatar
        v-aatheeque
        Community Support
        1 year ago

        Hi Rutuja1997 ,

        If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.

         

        We value your feedback, and it will help us to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Fabric Community Forum.