I have a json data like billow …and i want it to convert to datatable …plese help me.
hit this url in to chrome browser and get the json…
and convert in to datatable like
I have a json data like billow …and i want it to convert to datatable …plese help me.
hit this url in to chrome browser and get the json…
and convert in to datatable like
Hello, I hink that is a XML file, not a JSON.
Maybe it can be used an XML activity, not the one for JSON data files
Adrian
@Deepak_Kumar_Patel
as mentioned by Adrian it is a RSS is XML
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:
We do as described here:
So we do see:
the updated element is using the Atom namespace
In general we would loop over all items:
which would look like this:
for the demo we retrieves: title and updated (XML Namespace Demo)
For generic nested loop we can use the Elements method:
the table from the description we can again handle as XML (in some other scenarios we cannot)
And can apply the following:
Just for a quick retrieval RnD
So for the table generation we suggest:
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
Hello @Deepak_Kumar_Patel
Kindly find the attached XAML file. You may get some idea
Forum_DataExtract_TEXT.zip (98.3 KB)
Output
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.