Extract Data from XML

[Htwe_Ko_Ko_Wynn]

Dear Experts,

We have some barriers in extracting data from XML, Our sequence contains HTTP request, deserialize XML and its result. But we only need to extract every “ObjectID” and “ProjectID” containing in that XML.
Let me know how can I extract all the contain data field from XML. Thanks for your help.
PJC.txt (1.7 MB)

[ptrobot]

One possible solution is to use below regular expression with the Matches activity:

(?<=(ObjectID|ProjectID)\s*>\s*)\w+(?=\s*<)

[ppr (Peter Preuss)]

@Htwe_Ko_Ko_Wynn
your XML is defining several namespaces which is to handle for the retrieval

find starter help here:
GetElements_Namespace-ATOM.xaml (7.4 KB)

Preview to the logs:

[Htwe_Ko_Ko_Wynn]

Hi All, thanks for your solutions, and is there any examples of we can export these extracted data into a datatable? I am testing of writing it to excel or to SQL database. thanks.

[ppr (Peter Preuss)]

@Htwe_Ko_Ko_Wynn
you can set up like following:

• define with build datatble the datatable structure as needed
• use add datatrow for filling up the datatable
• use datatable e.g. within a write range and write extracted data to Excel

also have a look here to find and alternate approach for retrieval with namespaces and XPath

Reading all the tags of an XML and take them to excel

@Fabian_DDD I do feel that a XPath Approach is better for the retrieval Setting up a NamespaceManager with a Config Datatable: [grafik] for the default namespace with empty prefix “def” is assigne as prefix the retrieval is configured as another datatable (could also be externalize into an excel) [grafik] I did also for a deeper nested element for demo purpose After all preperation it is iterating over the retrieval config and retrieves the specfied values. et voila: [grafik] So this …