I need a scraper that gets data from the table on this page:
[login to view URL];iawvariant=jaar-vast&iawrvp=1
As you can see there are 2 dropdowns above the table: "Hypotheekvorm" and "Rentevaste periode". When you change these the data in the table also changes.
I need a scraper that gets all that data as well and stores it in the following database table:
id int PK
hypotheekvorm nvarchar(50) (e.g. "Aflossingsvrije hypotheek")
offerername nvarchar(50) (e.g. "ABN AMRO")
years tinyint
NHG decimal(4, 4)
[60] decimal(4, 4)
[75] decimal(4, 4)
[90] decimal(4, 4)
[100] decimal(4, 4)
[125] decimal(4, 4)
Dont worry that I store the hypotheekvorm and offerername full text. I will fix this myself later.
Techniques to be used:
VB.NET
MSSQL
suggestion: HTML agility pack to read the HTML page correct even when the DOM isnt correct, see: [login to view URL]
If you decide not to use that tool, please let me know how you plan to prevent the scraper from crashing when small changes are made to the design of the table to be scraped.