Extract data from xml to a datatable

Help Studio
, ,
1

Hi team ,

Please help me with xml to a datatable conversion.
Get Remit-to Connection Output - Copy.xml (2.6 KB)

Please find the xml attached.

Usecase -

I want to extract ID and bank account of all the wd:Remit-To_Connections as I have highlighted in the image.

image
image954×438 94.1 KB

I want the final value in datatable as -

image
image758×109 3.55 KB

Please help me with this.

Regards,
Gokul

2

Cross Reference:

In case of you need further help so elaborate on

  • what was done so far
  • what is in detail not working
  • where are the blockers to apply the learnings from the other helped topics on this case - especially the handling of XML Namespaces for the retrieval

grafik

Building Blocks:

grafik
grafik782×118 36.5 KB

2 Likes
3

Thank you ppr for this.

Also , in the below xml file , I want to change the value of wd:Add_Only=“true” to “false”
How do I achieve that ?

<?xml version="1.0" encoding="UTF-8"?>

<env:Envelope
xmlns:env=“http://schemas.xmlsoap.org/soap/envelope/”
xmlns:xsd=“w7.org - contact with domain owner | Epik.com”>

<env:Body>
    <wd:Submit_Supplier_Invoice_Request
        xmlns:wd="urn:com.workday/wfwf"
        wd:Add_Only="true"
        wd:version="v213.0">
		
        <wd:Supplier_Invoice_Reference>
        <wd:ID wd:type="Supplier_Invoice_Reference_ID">SUPPLIER_INVOICE-23472</wd:ID>
        </wd:Supplier_Invoice_Reference>
    </env:Body>

</env:Envelope>

Regards,
Gokul

4

Hi Gokul,

we do see some XML-related topics which are still open, but answered and in general solved within the same approach already shared with you.

Set up the XNamespace and use it for retrieval. The way how to do it and exploration techniques you will find in our several answers.

May we ask you for the following:

  • keep it strict to 1 case = 1 Topic, so other researchers can find quick solutions for the same case

  • mark solved topics as described here:
    Forum FAQ - How to mark a post as a solution

  • go through your different XML-related topics and work on the concepts (e.g. Namespaces, Descendants method, … ) to get more familiar with the general concepts

Thanks for support

5

Sure.First of all thanks a lot for all the support . I have marked solution for all the previous ones.
I wanted to keep the xml discussions in one thread only but forum closes the topic after 3 days and I have to create a new one when a different question arises.I will keep this one open till all my xml queries are resolved.hope that is fine.

Do let me know if I deviate from any of the points mentioned by you.

For the above query ,
I am extracting namespace - “urn:com.workday/wfwf”
for “wd:Add_Only” to make it “false” - I am not getting how to do that.

Can you please help if possible.

Regards,
Gokul

6

@gokul1904

find starter help:

grafik
grafik817×608 37.5 KB

1 Like
7

Thanks a lot @ppr
Would remember your advice.

Regards,
Gokul

8

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