Problem downloading a linear list dataIdScheme=NAME in the analytics API

Support - Assistance technique
, , ,
1

Hello,
I have a problem with the download in CSV or XLS from the module of Event report for a specific tracker program.
When I launch the download of a linear list, there is a new tab that opens but no download, I took the analytical request of the API and proceeded by eliminating the parameters, I discovered that it is the parameter dataIdScheme=NAME that causes the problem. All other tracker programs have no such problem. Somebody can help me please, I use version 2.36.11.1.

2

Hi @lebaldem2,
Thank you for the post! I’m not able to reproduce the issue on play in the 2.36.11.1 version. This request to get the line list event report for the child program works https://play.dhis2.org/2.36.11.1/api/29/analytics/events/query/IpHINAT79UW?dimension=pe:LAST_YEAR&dimension=ou:ImspTQPwCqd&dimension=A03MvHHogjR.zDhUuAYrxNC&dimension=A03MvHHogjR.cejWyOfXge6&stage=A03MvHHogjR&displayProperty=NAME&tableLayout=true&dataIdScheme=NAME&columns=pe;ou;zDhUuAYrxNC;cejWyOfXge6&rows=pe;ou;zDhUuAYrxNC;cejWyOfXge6&paging=false and it includes the dataIdScheme=NAME

If you are able to reproduce the issue on play then please share the steps, if not then would you please help us check the errors that might appear in your browser while sending the request.

Please copy the request link to download the CSV and open a new tab in the new tab, click F12 > Network tab. Once the Network tab is open copy and paste the request. Do you see any red text in the Network tab? Please select it and take a screenshot of the errors (Payload and Response).

Thank you! :+1:

3

Thanks @Gassim , the problem is the same on the play version, below the API request and the screenshots.

https://play.dhis2.org/2.36.11.1/api/29/analytics/enrollments/query/qDkgAbB5Jlk.xls?dimension=pe:THIS_YEAR;LAST_YEAR&dimension=ou:ImspTQPwCqd&dimension=hYyB7FUS5eR.fazCI2ygYkq&dimension=hYyB7FUS5eR.GyJHQUWZ9Rl&dimension=hYyB7FUS5eR.TfdH5KvFmMy&dimension=hYyB7FUS5eR.aW66s2QSosT&dimension=hYyB7FUS5eR.h5FuguPFF2j&stage=hYyB7FUS5eR&displayProperty=NAME&tableLayout=true&dataIdScheme=NAME&columns=pe;ou;fazCI2ygYkq;GyJHQUWZ9Rl;TfdH5KvFmMy;aW66s2QSosT;h5FuguPFF2j&rows=pe;ou;fazCI2ygYkq;GyJHQUWZ9Rl;TfdH5KvFmMy;aW66s2QSosT;h5FuguPFF2j&paging=false

Capture2
Capture21911×810 121 KB

capture1
capture11913×969 163 KB

1 Like
4

Thank you for your patience @lebaldem2!

It seems that there is an issue with one of the selected dimensions (or when selected along with another dimension). Removing the data element “Case Detection” from the selected data items downloads the xls file successfully and the error no longer appears.

However, selecting Case Detection which is a DE of an option set ‘Malaria case detection type’ will cause the issue to appear even when selected alone.

To reproduce this issue:

  1. Go to Event Reports app
  2. Select Line List , Enrollment , Malaria case diagnosis, treatment, and investigation
  3. Select data element: ‘Case Detection’
  4. Select period ‘last year’
  5. Click Update
  6. Download as xls, csv, or HTML and you will see the error in the console.

@lebaldem2 This could be a bug so would you like to create a Jira bug issue in jira.dhis2.org?

Thank you!