dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Tom,

if you refer to aggregated data (from the aggregated* tables) there is a
way to do this - unfortunately it is in trunk only and not documented yet -
will try a quick explanation here:

To get the aggregated data you can interact with the reportTables resource.
First you need to look up the ids (uids) of the data elements, indicators,
org units you need using the api starting here (from the snapshot demo in
this example):

http://apps.dhis2.org/dev/api/resources

You can then retrieve the data like this :

http://apps.dhis2.org/dev/api/reportTables/data.xml?de=fbfJHSPpUQD&de=cYeuwXTCPkU&in=Uvn6LCg7dVU&ou=O6uvpzGd5pu&last12Months=true

You can substitute ".xml" with any of ".json", ".jsonp", ".csv", ".pdf",
".xls", ".html".

You can repeat the de, in and ou query params as many times you want to get
data for multiple meta-data objects.

Valid params for periods are


reportingMonth
reportingBimonth
reportingQuarter
lastSixMonth
monthsThisYear
quartersThisYear
thisYear
monthsLastYear
quartersLastYear
lastYear
last5Years
last12Months
last6BiMonths
last4Quarters
last2SixMonths
thisFinancialYear
lastFinancialYear
last5FinancialYears
last52Weeks



Let me know it this helps. Lars