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