Practice web RPA workflow

david

Objective: Extract a list from a website and export it as an excel

No input parameters required.

When the workflow is launched, it should go to:
https://www.imdb.com/search/title/?groups=top_100&sort=user_rating,desc
Extract the first 100 movies (title, year, rating and description) and export it as an Excel file.
This Wrk Action will be needed to gather the data and export to an Excel file:
https://support.account.wrk.com/en/articles/8395251-export-wrkflow-data-to-file
You might also need to use loops to achieve the objective.

You can do this one in your own account.

david

@Nitish @Ashutosh

Nitish

Hi @david ,

We're currently reviewing the workflow. If we need anything, we'll reach out to you.

Nitish

Hi @david ,

We have completed work on the workflow. Please review it here: https://account.wrk.com/designer/?wrkflow_id=49194

Summary:

Used the action 'Click on an element on a website' to fetch all records.
Combined with 'Run JavaScript on a website' to manipulate all data.
Finally, converted the exported JSON into an Excel file using the action 'Convert JSON to Excel file'.

on the other hand, we are also trying alternative approach using loops.

david

Hey Nitish, using JS to achieve the goal works well and make for a simpler workflow.
The point of this practice is to use the web RPA to navigate and collect information - it will require many more steps but it is a good practice. Try it out.