← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Web API in Excel

 

Hi Channara and Bob

I have been using macros to POST and PUT data to the API, and GET requests should work just as well. 

I added your question and put my macro code here: 
https://webapps.stackexchange.com/questions/79521/can-i-use-excel-to-get-json-from-the-dhis-api/79522#79522 <https://webapps.stackexchange.com/questions/79521/can-i-use-excel-to-get-json-from-the-dhis-api/79522#79522>

See the comment at the end, seems it is possible to parse the JSON in a macro also.

Thank you,
Markus

> 23. jun. 2015 kl. 12.13 skrev Bob Jolliffe <bobjolliffe@xxxxxxxxx>:
> 
> You can't use excel to get json data from dhis2 web api.  At least not directly.
> 
> You could possibly write an excel macro to "get" the data through the
> web api (I am really not sure - it is far too many years since i wrote
> an excel macro), but you are still left with the problem of consuming
> what you have got (json) into cells in a spreadsheet.
> 
> I believe all (or certainly almost all) of the data which is available
> as json is also available as csv.  If you are looking at getting dhsi2
> data into excel in general, I would look at csv rather than json if
> you want to minimize the processing/transformation that would
> otherwise have to happen in between getting the data and consuming it.
> 
> https://www.dhis2.org/doc/snapshot/en/developer/html/dhis2_developer_manual.html
> 
> On 23 June 2015 at 07:47, channara rin <rin.channara@xxxxxxxxx> wrote:
>> Hi all DHIS2 developer,
>> Do you know can i use Microsoft Excel to get json data from DHIS2 web API?
>> 
>> thank you
>> channara
>> 
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp


Follow ups

References