UiPath - Knowledge Base

Consuming REST Web Service. Get Weather. Deserialize Json

Written by Razvan Iordache | Sep 16, 2014 11:04:00 AM

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