The DHS Program User Forum: Dataset access » Accessing DHS data using API.

Home » Data » Dataset access » Accessing DHS data using API.

Show: Today's Messages :: Show Polls :: Message Navigator

Accessing DHS data using API. [message #2772]

Fri, 22 August 2014 06:26

adiallo5
Messages: 1
Registered: March 2013
Location: Tunis

Member

Hi,
I am trying the stata code example shown in the following link ( http://api.dhsprogram.com/?utm_content=buffer57c2d&utm_m edium=social&utm_source=twitter.com&utm_campaign=buf fer#/samples-stata.html).
However, when trying this, Stata responds:

. * Call the API and get just the variables of interest
. insheetjson surveyid value using "http://api.dhsprogram.com/rest/dhs/data/20171000,KE.j
> son", table(data) col(SurveyId Value)
Unable to find data. Bad result selector 'data'?
Empty result returned; Nothing to do.

My question is:
- how to get the data values or references - I don't know if this phrased correctly - (in this case, "20171000,KE").
- is there a link or table somewhere with the list of countries, data, indicators, etc., and their reference?

I hope this is clear enough.

Best regards.

Amadou-

Report message to a moderator

Re: Accessing DHS data using API. [message #2786 is a reply to message #2772]

Mon, 25 August 2014 10:28

Trevor-DHS
Messages: 805
Registered: January 2013

Senior Member

Amadou,

We had a small mistake in the Stata example. In the example, where we had "table(data)" it should have been "table(Data)" as capitalization is important in Stata. This was due to a change in the names of the fields returned by the API.

The example has been corrected on the web site.

Regards. Trevor

Report message to a moderator

Re: Accessing DHS data using API. [message #2790 is a reply to message #2772]

Mon, 25 August 2014 12:52

Trevor-DHS
Messages: 805
Registered: January 2013

Senior Member

Hi Amadou,

I didn't answer your question completely. You can use the following queries to get the lists of:

Indicators: http://api.dhsprogram.com/rest/dhs/indicators
Surveys: http://api.dhsprogram.com/rest/dhs/surveys
Countries: http://api.dhsprogram.com/rest/dhs/countries
add ?f=html if you want to see any of these in a web browser.

You can use these calls in Stata in the same way as the data call.

Report message to a moderator

Previous Topic:	dataset
Next Topic:	Zambia MIS 2012 dataset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jan 2 22:51:14 Coordinated Universal Time 2025