0 Replies Latest reply: Dec 15, 2016 4:32 AM by Virilo Tejedor RSS

    Parse database field consisting on a list of XMLs

    Virilo Tejedor

      Hi,

       

      I have a list of XMLs stored on a MongoDB field.

       

      I need to connect this database via The MongoDB Connector for BI, and I’d like to know if there is any way to parse the xml from the QlikeSense side.

       

      This is an example of .json document:

       

      {

      '_id': ObjectId('58525eb375d8920001c7b555'),

      'creationDate': '2016-12-15T10:13:21+01:00',

      'docs': [

        {'files': [

        { 'id': 'main-document',

         'base64': 'N',

         'content': '<?xml version="1.0" ?>

        <Received_out xmlns="...">

               <binformation>

                       <InfoExp>

                               <exp>

                                       <dec>

                                               <idp>

                                                       <pos>

                                                               <dp>information-to-be-retrived</dp>

                                                       </pos>

                                               </dfn>

                                       </dec>

                                       <lepoch>

                                               <epoch>

                                                       <ldocu>

                                                               <docu>

                                                                       <orig>information-to-be-retrived</orig>

                                                               </docu>

                                                       </ldocu>

                                               </epoch>

                                       </lepoch>

                               </exp>

                       </InfoExp>

               </binformation>

        </Received_out>',

            'type': 'XML'},

       

       

       

       

       

       

            { 'id': 'attached-document-1',

            'base64': 'N',

          'content': '<?xml version="1.0" ?>

        <Received_out xmlns="...">

               <binformation>

                       <InfoExp>

                               <exp>

                                       <dec>

                                               <idp>

                                                       <pos>

                                                               <dp>information-to-be-retrived</dp>

                                                       </pos>

                                               </dfn>

                                       </dec>

                                       <lepoch>

                                               <epoch>

                                                       <ldocu>

                                                               <docu>

                                                                       <orig>information-to-be-retrived</orig>

                                                               </docu>

                                                       </ldocu>

                                               </epoch>

                                       </lepoch>

                               </exp>

                       </InfoExp>

               </binformation>

        </Received_out>',

            'type': 'XML'}

           ],

         'requestId': None}],

      }

       

       

      Is it possible to parse and retrieve information stored on a database field from QlikSense?

       

      Thanks in advance,

       

      Virilo