Resources

Knowledge Base

Consuming REST Web Service. Get Weather

webS1

Task

This sample extract weather information using web service.

Steps to automate

  1. Read a CSV file that contain cities name.
  2. Add one more column 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 one more columns to the data table using "Add Data Column" activity, the column should be called "Temperature".
  3. Extract the temperature for each city using "HTTP Client" activity.
  4. Use "Deserialize Json" activity and then use the output to extract any information that json provides.In our case the temperature.
  5. After extraction temperature from json, write the data table into a CSV file using "Append to CSV" activity.

webS4

 

Download all samples or browse the repository