← Back to team overview

dhis2-users team mailing list archive

Re: Excel data connection options


Hi Ned,

I don't think there are any plans to support OData at this point.

I would suggest you have a look at our documentation and utilize the
metadata and analytics  API for this. VBA seems to be capable of making
HTTP requests. It might not be the plug and play, standardized solution you
are looking for however, but should be possible.

Jason Pickering

On Nov 26, 2017 21:12, "Ned Jaszi" <ned.jaszi@xxxxxxxxx> wrote:

0down votefavorite

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

Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Follow ups