Error with HTTP to HTTPS redirection (Ebola data)
Dear All,
earlier this year I posted a cheerful message that Stata now supports URL redirection (see here:
http://www.statalist.org/forums/foru...-with-stata-13)
But there seems to be a problem of redirection to https.
. insheet using "http://data.hdx.rwlabs.org/storage/f/2014-10-31T20%3A16%3A27.797Z/ebola-data-db-format.csv"
file http://data.hdx.rwlabs.org/storage/f...-db-format.csv not found
server says file temporarily redirected to https://data.hdx.rwlabs.org/storage/...-db-format.csv
r(601);
. insheet using "https://data.hdx.rwlabs.org/storage/f/2014-10-31t20%3a16%3a27.797z/ebola-data-db-format.csv"
sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderE xception: unable to find valid certification pa
> th to requested target
r(5100);
Is this an indication that there is a problem with the site or Stata itself?
URLs seem to be date-dependent, so if you are reading this on another day, you may want to start from here:
https://data.hdx.rwlabs.org/dataset/ebola-cases-2014#
I have also tried the API for web queries to data, but with a similar problem. It would be great if Stata could access such data directly, without having to download the files manually, but so far I can't tell whether this is Stata's problem or something is wrong with the site.
Thank you, Sergiy Radyakin
PS: quite obviously the problem is not insheet, the same result is with import delimited or any other command accessing web resources.
earlier this year I posted a cheerful message that Stata now supports URL redirection (see here:
http://www.statalist.org/forums/foru...-with-stata-13)
But there seems to be a problem of redirection to https.
. insheet using "http://data.hdx.rwlabs.org/storage/f/2014-10-31T20%3A16%3A27.797Z/ebola-data-db-format.csv"
file http://data.hdx.rwlabs.org/storage/f...-db-format.csv not found
server says file temporarily redirected to https://data.hdx.rwlabs.org/storage/...-db-format.csv
r(601);
. insheet using "https://data.hdx.rwlabs.org/storage/f/2014-10-31t20%3a16%3a27.797z/ebola-data-db-format.csv"
sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderE xception: unable to find valid certification pa
> th to requested target
r(5100);
Is this an indication that there is a problem with the site or Stata itself?
URLs seem to be date-dependent, so if you are reading this on another day, you may want to start from here:
https://data.hdx.rwlabs.org/dataset/ebola-cases-2014#
I have also tried the API for web queries to data, but with a similar problem. It would be great if Stata could access such data directly, without having to download the files manually, but so far I can't tell whether this is Stata's problem or something is wrong with the site.
Thank you, Sergiy Radyakin
PS: quite obviously the problem is not insheet, the same result is with import delimited or any other command accessing web resources.
