Another resource that has existed for a while is the "Integrated Public Use Microdata Series". Though I don't think they have an API, they do provide a vast amount of data and have tools for online analysis.
IPUMS is often used by the researchers (including myself) who would download the entire dataset and do regressions on it, which might be one reason why they haven’t bothered to create an API.