Resources

Knowledge Base

Consuming SOAP Web Service. Get Weather

webS1

  • 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 here.

Task

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.

Solution

  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.

webS3