How to check if an XML element exists, and if does not exist for some transactions give default value?

[Sisay_Dinku (Sisay YDG)]

Hi team,

I have an XML data that for some of the transactions an element is missing. My goal is whenever, that element is missing I’d like to write default value that says “Data does not exist” under that column/ element. I want to write the condition that allows me to proceed to the next transaction after populating the missing element with the default value.

Here is the screenshot of my workflow.

currentItem.Descendants(xns_WD+“Race_Ethnicity__Locale_Sensitive_”).First().Value

Thanks a lot for your help!

[ppr (Peter Preuss)]

When working within Windows compatibility give a try at

currentItem.Descendants(xns_WD+"Race_Ethnicity__Locale_Sensitive_").Select(Function (x) x.Value).FirstOrDefault("NOTFOUNDDEFAULTTEXT")

[Palaniyappan (Palaniyappan P)]

Hi

Use an expression like this

If (String.IsNullOrEmpty(currentItem.Descendants(xns_WD+“Race_Ethnicity__Locale_Sensitive_”).First().Value), “ Data does not exist”, currentItem.Descendants(xns_WD+“Race_Ethnicity__Locale_Sensitive_”).First().Value)

@Sisay_Dinku

[ppr (Peter Preuss)]

When working in Legacy / also working in Windows we can do:

currentItem.Descendants(xns_WD+"Race_Ethnicity__Locale_Sensitive_").Select(Function (x) x.Value).DefaultIfEmpty("NOTFOUNDDEFAULTTEXT").First()

In addition to:

@Palaniyappan

If (String.IsNullOrEmpty(currentItem.Descendants(xns_WD+“Race_Ethnicity__Locale_Sensitive_”).First().Value)

When an element is not found a First() will return an exception and we will not use within an If

Here we would work e.g. with FirstOrDefault / isNothing()

[Sisay_Dinku (Sisay YDG)]

Hi @Palaniyappan @ppr

I tried to run it again using
If (String.IsNullOrEmpty(currentItem.Descendants(xns_WD+“Race_Ethnicity__Locale_Sensitive_”).First().Value), “ Data does not exist ”, currentItem.Descendants(xns_WD+“Race_Ethnicity__Locale_Sensitive_”).First().Value)
Query and it failed on the same transaction.
Just wanted to share how the missing element look like in XML

A you can see in the above, for the first portion the element does not exist and it can be found on the second one.
@ppr this query
currentItem.Descendants(xns_WD+“Race_Ethnicity__Locale_Sensitive_”).Select(Function (x) x.Value).FirstOrDefault(“NOTFOUNDDEFAULTTEXT”)
did not work for me.
Looking forward to hearing from you.
Thanks a lot!

[ppr (Peter Preuss)]

@Sisay_Dinku

did not work for me.

what was done in detail?

[Sisay_Dinku (Sisay YDG)]

FYI - I used the above expression inside the Append Item To List activity like you see below.
Not sure if that was the right thing to do.

Thank you

[ppr (Peter Preuss)]

ok, just have a look on the above screenshots from the immediate panel

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

As we cleared the syntax and also verified, what is working with some sample data

When:

@Sisay_Dinku

currentItem.Descendants(xns_WD+“Race_Ethnicity__Locale_Sensitive_”).Select(Function (x) x.Value).FirstOrDefault(“NOTFOUNDDEFAULTTEXT”)

is used, what is returned?
Ensure:

@ppr

When working within Windows compatibility

OR use below

@ppr

currentItem.Descendants(xns_WD+"Race_Ethnicity__Locale_Sensitive_").Select(Function (x) x.Value).DefaultIfEmpty("NOTFOUNDDEFAULTTEXT").First()

Show us also a screenshot with details from the loop part, where currentItem is coming from. Thanks

[Sisay_Dinku (Sisay YDG)]

Hi @ppr

This worked fine.

@ppr

currentItem.Descendants(xns_WD+“Race_Ethnicity__Locale_Sensitive_”).Select(Function (x) x.Value).DefaultIfEmpty(“NOTFOUNDDEFAULTTEXT”).First()

I am able to extract the data as I needed. Thanks a lot!