Forum Discussion

geschinger's avatar
geschinger
Regular Visitor
2 years ago
Solved

Copy Action - XML - Single Element not getting mapped / copied

We are experimenting with a pipeline to take data from XML files to SQL database and everything is working great for files with multiple elements but nothing copies over when there is a single <Sales...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi geschinger ,

    When I tried to repro you scenario in fabric, I am not facing this issue at my end.

    My Pipeline in Fabric Data Factory -






    My Xml Sample File:

    <?xml version="1.0"?>
<catalog>
   <book id="bk101">
      <author>Gambardella, Matthew</author>
      <title>XML Developer's Guide</title>
   </book>
</catalog>


    Can you please re-try by creating a new connection and try to check if issue is still exists.
    In case if the issue still exits please share the sample file you are using let me recheck with that file at my end.

    Thank you
     

geschinger's avatar
geschinger
Regular Visitor
2 years ago

Hello Anonymous 

 

I'm pretty sure I am in Fabric Data Factory and not Azure Data Factory. 

 

The URL I access it from is:

 

I am connecting to Azure for the SQL Database:

 

My understanding is that I'm using Fabric Data Factory connecting to Azure SQL Server.  Azure Data Factory would be accessed through Azure Portal and not app.fabric.com portal, correct?

 

If this is a bug is there URL to report Fabric Data Factory issues?

 

Thanks,

Greg

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi geschinger ,

When I tried to repro you scenario in fabric, I am not facing this issue at my end.

My Pipeline in Fabric Data Factory -






My Xml Sample File:

<?xml version="1.0"?>
<catalog>
   <book id="bk101">
      <author>Gambardella, Matthew</author>
      <title>XML Developer's Guide</title>
   </book>
</catalog>


Can you please re-try by creating a new connection and try to check if issue is still exists.
In case if the issue still exits please share the sample file you are using let me recheck with that file at my end.

Thank you
 

  • geschinger's avatar
    geschinger
    Regular Visitor
    2 years ago

    Hello Anonymous 

    Recreating it seems to have solved it.  Not sure how or why as I cannot find any difference between the one that fails and the newly created replacement.  But now if I run v3 (newly created pipeline) it works as expected:

     

    While the identical previous one still writes 0 rows in the Azure SQL DB.

     

    Thanks for your help,

     

    Greg

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi geschinger ,

      Glad to know that your query got resolved. Please continue using Fabric Community for your further queries.