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 <bobjolli...@gmail.com>: > > 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.chann...@gmail.com> 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@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
