← Back to team overview

dhis2-devs team mailing list archive

Re: Issue with /api/reportTables api

 

Hi Lars,

I checked on demo (Version 2.22, Revision 21999). The reportTable 'ANC
Coverages Quarterly' has below data
[image: Inline image 1]


Whereas the api
https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.
<https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.html>json
is not giving the same data. Could you please check and confirm.

Thanks
Aamer.


On Fri, Apr 15, 2016 at 8:20 PM, Lars Helge Øverland <lars@xxxxxxxxx> wrote:

> Hi Aamer,
>
> this seems to work as expected in 2.22 / on demo. Can you try to reproduce
> there? If not, can you upgrade to 2.22?
>
> regards,
>
> Lars
>
>
> On Tue, Apr 12, 2016 at 4:54 PM, Jan Henrik Øverland <
> janhenrik.overland@xxxxxxxxx> wrote:
>
>> Seems relative periods are rewinded by one period. "This quarter" returns
>> Apr-Jun in the pivot table, but Jan-Mar in /data.html. Should be fixed.
>>
>> On 12 April 2016 at 11:06, Aamer Mohammed <aamerm@xxxxxxxxxxxxxxxx>
>> wrote:
>>
>>>
>>> I checked in play.dhis2.org also. I am seeing the same issue.
>>> For the reportTable, "ANC: Coverages Quarterly" last row data is not
>>> being retrieved by the api
>>> https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.json
>>>
>>> Is it a known issue?
>>>
>>>
>>> On Tue, Apr 12, 2016 at 1:00 PM, Morten Olav Hansen <morten@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hm, I take that back.. seems both are included.. seems strange
>>>>
>>>> --
>>>> Morten
>>>>
>>>> On Tue, Apr 12, 2016 at 2:29 PM, Morten Olav Hansen <morten@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Hm, seems March 2015 is included instead of March 2016... not sure if
>>>>> it's a known issue or not, but seems like a bug, Lars will know better
>>>>> (maybe it's fixed already)
>>>>>
>>>>> --
>>>>> Morten
>>>>>
>>>>> On Tue, Apr 12, 2016 at 2:27 PM, Aamer Mohammed <
>>>>> aamerm@xxxxxxxxxxxxxxxx> wrote:
>>>>>
>>>>>> Hi Devs,
>>>>>>
>>>>>> We have seen the below issue when working with /api/reportTables api.
>>>>>> We are using DHIS 2.21 build revision 21058.
>>>>>> The reportTable as seen in DHIS app is as below.
>>>>>>
>>>>>> [image: Inline image 1]
>>>>>>
>>>>>> However when we try to fetch the data for the same report Table
>>>>>> through /api/reportTables/<id>/data.html api we are not getting entire
>>>>>> data. The data for last row is not retrieved through api (json response
>>>>>> attached)
>>>>>> Is anyone else facing this issue? Any observations please.
>>>>>>
>>>>>> Thanks
>>>>>> Aamer.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>> _______________________________________________
>>> 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
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org/>
>
>

PNG image

PNG image

Attachment: api_data.json
Description: application/json


Follow ups

References