I'm having intermittent trouble using the Census ACS API in Stata 15.0. For a brief period, the API calls were working fine in my office. Now they've stopped working, and when I make the following API call I get the following error message:
gen str60 B01001_001E = ""
gen str60 geoname = ""
gen str60 state = ""
insheetjson B01001_001E geoname state using "api.census.gov/.../acs1, aoa(1) columns( "1" "2" "3" "4")
Received fatal alert: handshake_failure Error -603, Unable to open URL: file could not be opened Warning: No response from source?!?
* Notes: I've left the API key empty above but am using my personal key in practice. This requires insheetjson.ado and libjson.mlib to be installed.
I can't tell if it's a Stata issue, firewall issue, or Census server issue. When I past the API directly into a Chrome browser window it works fine, so I suspect it's one of the first two or a combination of the first two.
I've had trouble just copying files from the Census FTP server within Stata as well. For example, this simple command fails in similar fashion.
copy "https://thedataweb.rm.census.gov/pub/cps/march/mar98supp.zip" "mar98supp.zip"
Received fatal alert: handshake_failurer(5100)
Has anyone else experienced this issue with Stata 15.0, or any recent version for that matter? Or has anyone noticed a change in behavior recently?
FWIW Stata 17 has the semblance of native support for Python, and I've been using Python to pick up the JSON files from the Census API and pass them as Stata data frames. I can share some code if needed.