XML automation - Update existing nodes

Hi all,

I have a simple task to automate but I cannot figure out how to design it in Studio:

Here is the situation:

My robot is extracting data from invoices and will generate a xml file which will be used in an API that will input an application with the extracted data.
The xml file is already created so the bot is simply going to modify relevant nodes.

My question : How can I make these updates ?

Here is a sample of the xml I would like to automate :

<vendorNo>VENDOR_NO</vendorNo>
<vendorName>VENDOR_NAME</vendorName>
<vendorShortName>VENDOR_SHORT_NAME</vendorShortName>
<vendorType>VENDOR_TYPE</vendorType>
<invoiceNo>INVOICE_ID</invoiceNo>
<revInvoiceNo></revInvoiceNo>
<memo>MEMO</memo>
<billRemarks>BILL_REMARKS</billRemarks>
<paymentTermsCode></paymentTermsCode>
<invoiceDate>INVOICE_DATE</invoiceDate>
<entryDate>ENTRY_DATE</entryDate>
<actDate>ACT_DATE</actDate>
<dueDate>DUE_DATE</dueDate>
<exchangeRateDate>EXCHANGE_RATE_DATE</exchangeRateDate>
<aparCode>APAR_CODE</aparCode>
<currencyAmount>CURRENCY_AMOUNT</currencyAmount>
<currency>CURRENCY</currency>
<exchangeRate>EXCHANGE_RATE</exchangeRate>
<baseCurrencyAmount>BASE_CURRNECY_AMOUNT</baseCurrencyAmount>
<oprBillSource>BILL_SOURCE</oprBillSource>
<billStatus>BILL_STATUS</billStatus>

Thank you in advance for your help!

a few other things are to respect as well. In general we do:

read XML + Deserializing it / Load XML
retrieve element
update element
save xml (when needed)

grafik

1 Like

Thank you I will try this

@loirdiahmed . Use below thread which is similar once except getting values from the excel