Web scrape Azure VM Pricing Pagepage.

I want a C# console tool that parses the following two Azure VM public pricing pages:

[login to view URL]

[login to view URL]

The tool must parse the entire page and create a ROW for every VM SKU option. The columns muse be:

1. VM SKU Family (e.g. D1s-5s v2)

2. Instance

3. vCPU

4. RAM

5. Temporary Storage

5. Pay as you go amount (just the $ amount)

7. 1 year reserved with AHB (in the format of $/hour (~ %)

8. 3 year reserved with AHB (in the format of $/hour (~ %)

9. Spot with AHB (in the format of $/hour (~ %)

10. Operating System (value selected from the list box at the top of the page)

11. Region (value selected from the list box at the top of the page)

The currency and display pricing are always US Dollars and Hour respectively.

The output of the C# console utility must be a CSV file

The command line options are:

-all (represents parsing the entire file)

-sku="x, y, z, etc." where x, y, z, etc. are the VM family SKUs names. The sku list can be 1 or more

-in = URL to page (test with the two URLS shown above)

-out=filename

If the filename exists, append to the file, if the filename does NOT exist, create the file. Always write at the bottom of the file

Validation? I want a Visual Studio project file, version 2017 (preferably) where I can debug the code as appropriate.

BONUS: If you have the ability to programmatically select the OS/Software and Region at run-time, that would be ideal. That would allow me to create a batch file where I can run the tool multiple times but specify the OS/Software and Region. Only if this is possible, you must add two more command line options:

-os (for operating system matching value in the list box)

-region (for region matching value in the list box)

I would like to use this application by Friday morning (Vancouver, BC, Canada time). That is 30 hours from now.

When bidding, please indicate whether you can accomplish the BONUS request. If not, I will accept the tool without the BONUS capabilities.

You must FULLY document your code and minimize unnecessary libraries.

....................

I prefer C# as I understand it. But if someone can accomplish the same thing in Python or VBA via EXCEL, please bid and demonstrate your confidence to complete the job in those tools. But ideally, I prefer the implementation be done in:

Priority 1: C#

Priority 2: C++

Priority 3: VBA Excel

Priority 4: Python

I will accept the bid in 8 hours from now which is 8 AM PST Vancouver, BC, Canada

Programación en C# Amazon Web Services .NET Python Arquitectura de software

Nº del proyecto: #27857980

Sobre el proyecto