<img src="//trc.taboola.com/1222697/log/3/unip?en=page_view" width="0" height="0" style="display:none">


Knowledge Base

Consuming SOAP Web Service. Get Weather. Deserialize XML


To be able to run this example you need to install UiPath.Excel.Activities and UiPath.WebAPI.Activities. See more details on how to install packages



This sample extract weather information using web service.

Steps to automate

  1. Read a CSV file that contain cities name and countries name.
  2. Add two more columns to your data table.
  3. For each city from CSV file, use web service to extract the temperature and the moment when it was recorded.
  4. Write the information extracted into another CSV file.


  1. Read a CSV file that contain cities name and countries name using "Read CSV" activity.
  2. "Read CSV" output a data table, add two more columns to the data table using "Add Data Column" activity, the columns should be called "Time" and "Temperature".
  3. Extract the time and the temperature for each city using "Soap Client" activity.
  4. After you have all the information in your data table write into a CSV file using "Append to CSV" activity.


Download all samples or browse the repository