It’s very easy to get and analyze voters list using my new XT_HTTP package
We can get up-voters list by the URL:
where NNNN is Idea ID from nomenee’s page.
I don’t like to import certificates, so i cannot use httpuritype for HTTPS pages and I decided to create package which will work with https as http.
It was pretty easy with java stored procedures github/XT_HTTP
java source: xt_http.jsp
create or replace and compile java source named xt_http as
In Part 1 I demonstrated how to "scrape" data from the live webpages with the votes of the Oracle Database Developer Choice Awards. Unfortunately those webpages are not ideal for scraping, so I promised a workaround. Here I do a semi-manual scraping af data by using a browser to retrieve the actual HTML, save it to a file, and then let the code parse out the data from the file.