Convert critical Json To DataTable

@Deepak_Kumar_Patel
as mentioned by Adrian it is a RSS is XML


Kindly note the Webtable in the description element value

XML Processing we do with the help of the Deserialize XML Activity and then further with different methods / options e.g. LINQ for XML

When looking to the XML Details we do see that the XML is defining a document namespace which is to handle:
grafik

We do as described here:

So we do see:
grafik
the updated element is using the Atom namespace

In general we would loop over all items:

which would look like this:
grafik

for the demo we retrieves: title and updated (XML Namespace Demo)
grafik

For generic nested loop we can use the Elements method:
grafik

the table from the description we can again handle as XML (in some other scenarios we cannot)
grafik

And can apply the following:
grafik
Just for a quick retrieval RnD

So for the table generation we suggest:

  • prepare the structure with a build Datatable Activity
  • parse the xml and loop over the “item” elements the loop
  • extract the values as introduced above
  • populate and add the data row

Let us know when you need further help

Kindly note: The Demo snippets from the immediate panel will be adapted later to the implementation details. But as you can see we can quick prechecks our ideas can get support by the implementation work

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum