5 Replies Latest reply on Oct 31, 2013 8:27 AM by tanmoypalit

    Error while consuming XML file containing ":" in Teiid

    tanmoypalit Newbie

      Hi,

      We are running into error while consuming the following XML as Teiid View:

       

      <feed xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

           <id>stream1</id>

           <content>

                <m:properties>

                     <d:value1>12</d:value1>

                     <d:value2>14</d:value1>

                     <d:value3>18</d:value1>

                </m:properties>

           </content>

      </feed>

       

      If we remove the ":" characters from properties and values then it works otherwise its results in parsing error.

      Is there anyway to resolve this problem? We are using Teiid 7.7.5

       

      Also after removing colons we had to remove one xmlns tag in the actual file which causes no data to be imported, the root in real file looks like:

      <feed xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

      The data import works well if we remove xmlns="http://www.w3.org/2005/Atom" or change to xmlns:a="http://www.w3.org/2005/Atom" ( where 'a' could be anything)

      Any ideas?

       

      Regards

      Tanmoy