Back to forum list… Back to How Do I?...

Xml Data - Reading Namespaced File (1 reply)

Zev Kizelnik
5 years ago
Zev Kizelnik 5 years ago

How do I read the following file? Having issues reading the file.

https://www.realisable.co.uk/wp-content/uploads/2019/08/XmlReadWithNamespace.png
Support
5 years ago
Support 5 years ago

Zev, the Xml file has a namespace. This needs to be declared and then referenced throughout the reader setup.

Put the namespace with prefix into the namespace field. In this document there is a default namespace. Default namespaces can be problematic, but these issues can be eradicated with a prefix in the declaration. The prefix is essentially a shortcut to the namespace (urn:schemas-microsoft-com:xml-analysis:rowset).

In our example we used a namespace prefix of 'ns', but you can use character string without spaces.

Each XPath must have each node prefixed with the namespace prefix followed by colon followed the node. These are shown in the entry point, record & field XPaths.

https://www.realisable.co.uk/wp-content/uploads/2019/08/XmlDocument.png
https://www.realisable.co.uk/wp-content/uploads/2019/08/RecordAndFieldSetup.png
https://www.realisable.co.uk/wp-content/uploads/2019/08/NamespaceDeclaration.png
https://www.realisable.co.uk/wp-content/uploads/2019/08/EntryPoint.png

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close