You can download the data source behind a chart in JSON, XML, Excel, CSV, JXRML or Raw data SQL formats with different identification schemes (ID, Code, and Name). The data document uses identifiers of the dimension items and opens in a new browser window to display the URL of the request to the Web API in the address bar. This is useful for developers of apps and other client modules based on the DHIS2 Web API or for those who require a plan data source, for instance for import into statistical packages.
To download plain data source formats:
Click Download .
Under Plain data source , click the format you want to download.
Format |
Action |
Description |
---|---|---|
JSON |
Click JSON |
Downloads JSON format based on ID property. You can also download JSON format based on Code or Name property. |
XML |
Click XML |
Downloads XML format based on ID property. You can also download XML format based on Code or Name property. |
Microsoft Excel |
Click Microsoft Excel |
Downloads Microsoft Excel format based on ID property. You can also download Microsoft Excel format based on Code or Name property. |
CSV |
Click CSV |
Downloads CSV format based on ID property. You can also download CSV format based on Code or Name property. |
JRXML |
Put the cursor on Advanced and click JRXML |
Produces a template of a Jasper Report which can be further customized based on your exact needs and used as the basis for a standard report in DHIS 2. |
Raw data SQL |
Put the cursor on Advanced and click Raw data SQL |
Provides the actual SQL statement used to generate the data visualization. You can use it as a data source in a Jasper report, or as the basis for a SQL view. |