How Can I Read Tag from XML response

[Sandhya_Gajare]

Hi Team
I am sharing my code here from that i wanted to search
eighteen_or_older,=YES
Sponsorship_USA,=No
Future_Sponsorship=No
job profile=…
skills=…
If tag not found throw exception can anyboady help me out guys please

[Sandhya_Gajare]

Main.xaml (12.7 KB)

[Sandhya_Gajare]

here is my code

[ppr (Peter)]

Cross References:

How to read tag from api response

[image] how can i find tag eighteen_or_older,Sponsorship_USA,Future_Sponsorship please guys help me with example

How to search API response

Hi Team, How I can search for particular response I am getting response in xml format from that i wanted to search for different response how I can do that,I am sharing response file please guys help me out how can i do that if i dont find response i will have to throw the exception XML output.docx (388.6 KB)

How to search data from XML response

Hi Team, I have 1000 record on queue for that queue i am taking api response using http request activity now i wanted to search data from that number how i can search particular response below i am sharing my code Process.xaml (24.0 KB) let me know how can i do guys please

where it was answered with the hint on handling the XML namespaces by:

XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types)

Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</productVersion>] } xDoc.Descendants(xnsDefault + "productVersion").First().Value "123" xDoc.D…

And the request for sample XML data:

@ppr

May we ask to share some more details like retrieval needs, sample XML as textfile.

[Sandhya_Gajare]

I have share my code there can you check that,That will provide api response

[Sandhya_Gajare]

Main.xmal file is there

[Sandhya_Gajare]

<?xml version="1.0" encoding="utf-16"?>kamath_harish@hotmail.comR150379TrueBasic SVNVX09wZW5fSm9iX1JlcXVpc2l0aW9uX091dGJvdW5kOkN1c2h3YWtlXzg3NiM=TrueTrue__ReferenceID0

[ppr (Peter)]

We asked for the XML Data as Text file and not for the XAML, as from theXAML we cannot get the details / specifics of the XML Data. However we shared you an initial starter help for the XML extraction approach. Also the question to the extraction details (e.g. which fields…) was unanswered so far.

With such details we can give you more individually help

[Sandhya_Gajare]

API reponse.txt (16.8 KB)
U can refer this not before one that one is wrong

[Sandhya_Gajare]

Hi Team
I am sharing my code here from that i wanted to search
eighteen_or_older,=YES
Sponsorship_USA,=No
Future_Sponsorship=No
job profile=…
skills=…
If tag not found throw exception can anyboady help me out guys please refer final txt file and help me out

[ppr (Peter)]

As mentioned in the link:

Retrieval example:

variation:

[Sandhya_Gajare]

can you tell how can i read that tag specifically

[ppr (Peter)]

@Sandhya_Gajare

ow can i read that tag specifically

what is meant with specifically?

when respecting the structure part and using the XNamespace Varaible and the element local name we can retrieve the value for the particular element

[Sandhya_Gajare]

that response from postman sir actually refer my code and output i am pasting here

[ppr (Peter)]

Maybe following will help you:

as mentioned above:

@ppr

Retrieval example:

variation:

following implementation:

xnsDefault = xDoc.Root.Name.Namespace
Log message:

xDoc.Root.Element(xnsDefault + "Report_Entry").Element(xnsDefault + "Date_Applied" ).Value

will create following output and demonstrate the value retrieval for a specific xml element:

[ppr (Peter)]

Summary:
The topic: How Can I Read Tag from XML response
is understood as

• how the values from the response XML can be extracted

We introduced to you:

• handling of XML Namesspaces for your XML case
• sample retrieval demo
  • above and
    

So based on this you can continue and implement the more detail value extraction

The question:

@Sandhya_Gajare

If tag not found

we can defensive check if the tag is present with the following apporach

Fazit: we do see your general question as answered and ideally this topic can be closed by you:

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

[Sandhya_Gajare]

I have try this approach but i do not get proper values for tag eitheen_or_older,FutureSponseship,USASponarship i am sharing here screenshot
as deserialized xml output for this tag we have descriptor also

[Sandhya_Gajare]

xmlOutput.Root.Element(xdefault + “Report_Entry”).Element(xdefault + “Date_Applied”).Value

xmlOutput.Root.Element(xdefault + “Report_Entry”).Element(xdefault + “Sponsorship_USA” ).Value

xmlOutput.Root.Element(xdefault + “Report_Entry”).Element(xdefault + “Future_Sponsorship” ).Value
Output

[ppr (Peter)]

@Sandhya_Gajare

do not get proper values for tag eitheen_or_older

the XML has a different structure and we can get the values from the Descriptor attribute:

xDoc.Root.Element(xnsDefault + "Report_Entry").Element(xnsDefault + "eighteen_or_older").Attribute(xnsDefault + "Descriptor").Value

A defensive check if the Descriptor attribute is occuring or not we can do:

[Sandhya_Gajare]

@ppr i will check that as of now i am trying somhing else which
Out_XML.Root.Element(XDefault + “Report_Entry”).Element(XDefault + “Sponsorship_USA” ).FirstAttribute.Value
is its right let me know