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 yo…

@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 …

One possible solution is to use below regular expression with the Matches activity: (?<=(ObjectID|ProjectID)\s*>\s*)\w+(?=\s*<) [IMG_20201021_065951]

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.

Extract Data from XML

Help

ppr (Peter Preuss) October 21, 2020, 9:55am 3

@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:
grafik

Read from xml file

Topic		Replies	Views
Extract the values from XML files Studio studio , xml-datatable	3	2191	September 2, 2022
Extract data from xml to a datatable Studio studio , question , activities_panel	6	1685	August 30, 2022
Get the specific Data from XML file Studio studio , question , workflow_diff	9	3604	March 31, 2022
Extract data on XML file ( Deserialize XML Activity ) Academy Feedback	1	1674	October 15, 2020
Read and extract certain data from an xml file Help studio , error	3	1581	November 4, 2019

Extract Data from XML

Related topics