← Back to team overview

dhis2-users team mailing list archive

Re: Excel data connection options

 

Thanks. I figured out a more plug and play solution using Excel
Get/Transform (previously PowerQuery).  The steps are: 1) Create a New
Query from Other Sources/Web. 2) Enter the API call URL 3) Enter
credentials in Basic tab when prompted

I've tested so far with calls for CSV format. Some fiddling is required to
set the query to read as CSV, but altogether pretty straightforward.  The
source step of the query will end up looking something like: =
Csv.Document(Web.Contents("https://URL/api/dataElements.csv?paging=false
"),[Delimiter=","])

Best,
Ned

On Mon, Nov 27, 2017 at 8:59 AM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> 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.
>
> Regards,
> Jason Pickering
>
>
>
>
>
>
>
>
> On Nov 26, 2017 21:12, "Ned Jaszi" <ned.jaszi@xxxxxxxxx> wrote:
>
>
> 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?
>
>
> _______________________________________________
> 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

References