Web scrapping - to pull information from the ministry of corporate affairs portal.

Please read the detailed note.

Need to pull publicly available information from the ministry of corporate affairs portal.

Master Data
http://www.mca.gov.in/DCAPortalWeb/dca/MyMCALogin.do?method=setDefaultProperty&mode=31

Index of Charges
http://www.mca.gov.in/DCAPortalWeb/dca/MyMCALogin.do?method=setDefaultProperty&mode=32

Signatory Details (Directors, Company Secretaries, etc…)
http://www.mca.gov.in/DCAPortalWeb/dca/MyMCALogin.do?method=setDefaultProperty&mode=39

Prosecution details
http://www.mca.gov.in/DCAPortalWeb/dca/MyMCALogin.do?method=setDefaultProperty&mode=53

Public Documents (contains list of eForm filed in connection with a particular CIN)
http://www.mca.gov.in/DCAPortalWeb/dca/MyMCALogin.do?method=setDefaultProperty&mode=12

A spreadsheet containing 50 to 100 (Corporate Identity Number) will be provided in Column A. Details from all the links mentioned above are to be extracted for the given CIN and pasted in the relevant row in the spreadsheet.

In this regard, you may also checkout the portal ‘companywiki.in’ which kind of performs similar tasks.

I want this sheet populated every day and if there is a change in data (i.e. if there is an update), the respective cell should be highlighted and trigger an email alert.


Also please check out the following links in this regard:

http://enterprise.import.io/how-it-works/

https://d24s8iufolpmlr.cloudfront.net/prod/dist-new/setup.exe