Have XML format of a file in URL - HOW TO DOWNLOAD IT check for data?

Help Activities
, , , ,
1

image
image916Ă—571 25.7 KB

Hi guys I have a URL which brings me to this XML format page.
I need to check if certain values are present here?

Please advise, should I download before?

Best Regards
:slight_smile:

2

Hi @hurmet.noka

Use Get Text activity to get the text from web page later use if condition to check the certain values present or not.

3

Thank you, there is no way to extract whole info using just the URL ?

4

You can try to use the URL for the HTTP Request activity and use the downloaded XML for the later extraction

1 Like
5

I Will try that, can I then convert XML to a more readable form for data extraction Peter?
You are really a savior

6

here we would recommend to clear the details on what is aimed / focused
then derive the access needs and keep in mind the structures

  • we can access tree structures more flexible as bringing them into a tabular format
    • Example: warehouse. can be 1:1, 1:n relations

Once these factors are cleared we can think about the next steps

1 Like
7

I downloaded the resource via HTTP request, now i can read it and have it in a string format.
How can I search for a “sku” and if found extract the related data of that product

8

can you share XML as text file?

In general we do:
Deserialize XML Activity - output xDoc

myFirstSKU = xDoc.Root.Descendants("sku")(0).Value

1 Like
9

INVENTORY.txt (3.4 MB)

10

grafik

Just a few samples:

Looping over the all product elemente - e.g. feeding to a for each activity
grafik

Collecting all skus:
grafik

l

1 Like
11

Okay thank you so much,
after extracting all SKUs, then I assume we loop through to find the correct match, and fidning the index with which we may extract the other relevant data, is that correct sir?

12

We can filter with LINQ:

grafik
grafik692Ă—228 40.1 KB

1 Like
13

image
image1853Ă—1075 72.9 KB

14

XML in text is invalid.

Make it valid by removing the XMP element at begin
grafik

AND also remove the ending XMP element at the end

1 Like
15

You are correct sir, thank you so much.
One last thing after xDoc.Root.Descendants(“product”).Where(Function (x) x.Element(“sku”).Value.Equals(sku)).FirstOrDefault()

How do we get the values between tags?

16

Just open a new topic and start it with the new question scope along with some more elaborations. We scope topics that other researchers can easier find answers for their similar questions, Thanks for support

1 Like
17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.