Calling WDI and IDS data through World Bank API

[Raj]

Hello - I am trying to pull the latest WDI and IDS data in XML or JSON format from World Bank through API calls.  There is a nice API Query Builder available but can select only one country and one indicator at a time.  I would like to get WDI data for ALL COUNTRIES and ALL INDICATORS for all time periods.  Can someone help me how to create a single API call to pull all this data in XML or JSON format?

Thanks in advance

Raj

[Sarven Capadisli]

What you are looking for is the full data dump of WDI. I'm not aware of
a way to get that over the API, however, you could make a call for each
indicator which will get you all countries for all periods e.g.:

http://api.worldbank.org/{lang}/countries/all/indicators/{indicator}?format=xml&per_page=20000

lang: language code for strings e.g., 'en' for English

indicator: indicator code e.g., SP.DYN.IMRT.IN

IIRC, per_page=20000 is sufficient to get all data for all indicators,
but you might want to play around with that number.

-Sarven

[Raj]

Hello - Is it possible to get all indicators for all time periods for one country at a time?  It can reduce the number of API calls.

Thanks in advance

Raj

[leila...@gmail.com]

In API, we don't have provision to query all indicators, however you can query API for multiple countries, multiple indicators for all years.

If API calls made with multiple indicators, 'source' is mandatory query parameter.

Source Id for WDI is 2, for complete list of sources try http://api.worldbank.org/sources 

Also, maximum of 60 indicators allowed in one API call.

Following API call will return data for country 'ind', indicators 'sp.pop.totl', 'sp.pop.grow' and 'se.prm.ages' for all years.

http://api.worldbank.org/country/ind/indicator/sp.pop.totl;sp.pop.grow;se.prm.ages?source=2&per_page=1000 

Call with multiple countries, multiple indicators for all years.

http://api.worldbank.org/country/ind;pak;aus/indicator/sp.pop.totl;sp.pop.grow;se.prm.ages?source=2&per_page=1000 

You can get data for all the countries, regions, income groups and aggregates for a given indicator for all the years.

http://api.worldbank.org/country/all/indicator/sp.pop.totl?per_page=14000&format=json 

You can download All countries, all indicators for all years in excel or CSV format from following link.

http://data.worldbank.org/data-catalog/world-development-indicators 

Click on WDI (Excel)-ZIP or WDI (CSV)-ZIP.

Best,

Development Data Group

The World Bank

data.worldbank.org

[yomi yusuf]

I have been trying to use the API.

I want to get the list of all countries, their GDP and regions.

http://api.worldbank.org/v2/countries/all/indicators/NY.GDP.MKTP.CD includes a list of different classes of regions which isn't what i want.

I have not been able to do that for 2 days now. How should I go about it.

[Tim Herzog]

That is the correct API call to fetch an indicator for all countries and aggregate regions. What class of regions are you looking for?