2 Replies Latest reply: Apr 10, 2017 8:38 AM by Deepika Shinde RSS

    While importing XML :error:Semi colon character was expected error ,Faced

    Deepika Shinde

      Hi,

       

      I am trying to import XML file through URLbut I am facing below error

      "A semi colon character was expected."

       

      In the data there is "&" and hence facing above error.

      I tried replacing "&" with "&amp" and then import in table.but this didn't solve the issue.

       

      Code:

       

      LOAD Replace(key,"&","&amp") as key,

          content

      FROM [https://xyz.net/test-initialload_FIR/tasks?amount=20] (XmlSimple, Table is [Root/tasks]);

       

       

      Data sample"

      <tasks>

           <task>

                <key>documents/de/oxx?mmsArtNo=333993&ampvariantNo=1&ampbundleNo=1&amplanguage=de</key>

                <content>INSERT</content>

           </task>

      </tasks>

       

      Please help.