Doing VAT lookups on a web page is a typical RPA case. Here’s how to solve it.
- Read and write in Excel
- Web searches
- Web scraping
- Download the Excel book with sample data
- Navigate to https://datacvr.virk.dk and click on English in the upper right corner
- For each row
- Do a CVR lookup at https://datacvr.virk.dk
- Fill in the blank columns (except status) by doing a web scrape of the CVR lookup page
- Write the result back to Excel
- Error handling
- Try to add a row in the Excel sheet with the CVR 12345678. Handle the error.
- Log column: Write either Succesful or Failed
- Use an On block error activity for the error handling