Ler e desserializar um arquivo XML

The following example explains how to use activities such as Deserialize XML, Execute XPath, Get XML Nodes, or Get XML Node Attributes for reading, deserializing, accessing, and displaying various information about an XML file. You can find these activities in the UiPath.WebAPI.Activities package.

Observação:

Download and extract the archive with the project in this example and copy the file daily_usd.xml to your project folder.

É assim que um processo de automação pode ser construído:

1. Abra o Studio e crie um Processo.
2. Arraste um contêiner Sequência para o Designer de Fluxo de Trabalho.

   • Crie as seguintes variáveis:

     Nome da variável	Tipo de Variável	Valor Padrão
     xml	String
     xmlDeserialized	XDocumentName
     xml_xpath_result	Object
     xmlNodes	IEnumerable
     xmlAttributes	IEnumerable
     allExchRates	String

3. Add a Read Text File activity inside the Sequence.
   • Add the expression "daily_usd.xml" in the File Name field.
   • In the Properties panel, add the variable xml in the Content field.
4. Add a Deserialize XML activity after the Read Text File activity.
   • Add the variable xml in the XML String field.
   • In the Properties panel, add the variable xmlDeserialized in the XMLDocument.
5. Add an Execute XPath activity after the Deserialize XML activity.
   • Add the variable xmlDeserialized in the Existing XML field.
   • Add the expression "string(/channel/lastBuildDate)" in the XPath Expression field.
   • In the Properties panel, add the variable xml_xpath_result in the Result field.
6. Add a Message Box activity after the Execute XPath activity.
   • Adicione a expressão "Exchange rates for " + xml_xpath_result.ToString no campo Texto.
7. Add a Get XML Nodes activity after the Message Box activity.
   • Add the variable xmlDeserialized in the ExistingXML field.
   • In the Properties panel, add the variable xmlNodes in the XMLNodes field.
8. Add a Get XML Node Attributes activity after the Get XML Nodes activity.
   • Add the expression xmlNodes(0) in the Existing XML Node field.
   • In the Properties panel, add the variable xmlAttributes in the Attributes field.
9. Add a Message Box activity after the Get XML Node Attributes activity.
   • Adicione a expressão xmlAttributes(0).Name.Tostring + ": " + xmlAttributes(0).Value.Tostring no campo Texto.
10. Add an Assign activity after the Message Box activity.
    • Adicione a variável allExchRates no campo Para.
    • Adicione a expressão "Exhange Rates" + System.Environment.NewLine no campo Valor.
11. Add a For Each activity after the Assign activity.
    • Add the expression xmlDeserialized.Element("channel").Elements("item") in the Values field.
    • In the Properties panel, select the System.Xml.Linq.XElement option from the TypeArgument drop-down list.
12. Add an Assign activity inside the Sequence container of the For Each activity.
    • Adicione a variável allExchRates no campo Para.
    • Add the following expression in the Value field: `allExchRates + System.Environment.NewLine + "1 " + item.Element("baseName").Value.ToString + " = " + item.Element("exchangeRate").Value.ToString
      • " " + item.Element("targetName").Value.ToString`.
13. Add a Message Box activity after the For Each activity.

    • Adicione a variável allExchRates no campo Texto.

      

14. Execute o processo. O arquivo XML é lido, desserializado e acessado. Algumas caixas de mensagem são exibidas com informações extraídas do arquivo.

Aqui você pode baixar um exemplo.