Re: st: Re: Web APIs and JSON file format reading

[Sergiy Radyakin <serjradyakin@gmail.com>]

On Sun, Dec 19, 2010 at 7:40 PM, Andrew Dyck <andrew@andrewdyck.com> wrote:
> Hi Stata users,
>
> I'm interested in using Stata to access data from web APIs such as
> data.worldbank.org or Twiter. I use 64-bit Stata MP for Windows and

Dear Andrew,
the data from the World Bank also comes in a CSV format, archived in
ZIP files. You can download the data of your interest with -copy- from
the web address to your local drive, then unpack with the -unzipfile-
command (undocumented in Stata 10, documented in Stata 11). Then
-insheet- the data tables you want.

If you are up to the "Apps for development" competition: good luck!

The data catalog with direct links to databases is available here:
data.worldbank.org/data-catalog

Best regards,
     Sergiy Radyakin
     Economist, Research Department, The World Bank


PS: what data is available on Twitter?



> Linux.
>
> I'm aware of the -net-, -copy- and -webuse- commands, however, my
> searches so far haven't uncovered any tools for reading in data
> directly from an API. At this time it seems that this may not be
> possible in Stata without using an external python or perl script.
> However, if you have any experience in using JSON with Stata I'd be
> very happy to hear from you.
>
> I have begun research into writing a native Stata module (using mata)
> for reading JSON data from a web API but I thought I'd tap the
> Statalist knowledge bank first to:
>
> 1) stop me early if it's just not possible or already done;
> 2) suggest any strategies for how to go about this; and
> 3) see if there is any interest in such a feature or if users are
> already using some other methods that would work better than something
> native to Stata.
>
> Any help, advice or links to more info would be greatly appreciated.
>
> Thanks,
> Andrew
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/