Read a DiffGram data container

Help Studio
, ,
1

Hi everybody,

my next bot, which will be working with customer’s app AKIS (AKIS - M&S AG), must use files with .dc extension as input. Those files look very similar to xml, but are still a bit odd. So I did a bit of digging and found out, that those are in fact DiffGram data structures. They have the following line in the header:

<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">

When I deserialize them with XML activity, it seems to work (no error in studio), but I cannot get any node - Execute xpath simply returns empty string. Does anybody have experience with such files? How can I read them in UiPath?

2

check for the need of handling the xml namespaces:
XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types) - Help / Community - UiPath Community Forum

3

@ppr thanks for the link! Approach with Descendants-property works pretty well. Besides, I have found out how to trim the file to make it look more like xml. It should be fine now :slight_smile:

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.