← Back to team overview

dhis2-users team mailing list archive

Excel data connection options

 

0down votefavorite
<https://webmasters.stackexchange.com/questions/110999/data-feed-connection-to-excel#>

I'm interested in creating a data connection in Excel to access data from
the DHIS2 web api. Essentially I want to be able to generate refreshable
tables in an Excel data model from DHIS2 sources: API queries or SQL views.
Excel 2016 (or with PowerPivot/PowerQuery add-ins in previous versions)
enables connections to OData Data Feeds, but the DHIS2 web api does not use
the OData protocol (http://www.odata.org/). I have not found an alternative
method. Any suggestions? Are there any plans to develop an OData compatible
api?

Follow ups