50 rows limit pulling record using API from DHIS2 (version 2.38.2)

Dear all, I would like to request a suggestion on 50 records limit in Power Bi after the system is upgraded from 2.37.4 to 2.38.2. I tried to pull three types of records (Track entities, Enrollment, and Events).
I use the following API to get data from the DHIS2 tracker. the issue is ony 50 records are pulled from DHIS2 in pulling enrollment and event data.
https://xxdomainxx/api/tracker/events.json?orgUnit=xxxxxxxxx&ouMode=DESCENDANTS&program=xxxxxxxxx&occurredAfter=2022-01-01&occurredBefore=2022-12-31&skipPaging=true

the previous version of DHIS2 is working properly. Could anyone give me advice on this issue?

1 Like

Hi @Kyawmoewai_Ngp ,
In response to your inquiry, I would suggest two things:

  1. You can completely disable paging by adding the ‘paging=false’ parameter. For example https://xxdomainxx/api/tracker/events.json?orgUnit=xxxxxxxxx&ouMode=DESCENDANTS&program=xxxxxxxxx&occurredAfter=2022-01-01&occurredBefore=2022-12-31&paging=false. Or,
  2. You can increase the page size of the data being loaded/downloaded by adding ‘pageSize=1000’ parameter. For example https://xxdomainxx/api/tracker/events.json?orgUnit=xxxxxxxxx&ouMode=DESCENDANTS&program=xxxxxxxxx&occurredAfter=2022-01-01&occurredBefore=2022-12-31&pageSize=500

For more information, check out the Documentation.

I hope our response is able to solve the issue you were facing.

With :heavy_heart_exclamation: from the Dhistance Team.

DHISTANCE.com: The Easiest DHIS2 Setup. Up and running in 5 minutes!

No technical knowledge needed! Great Support with Data Security/Confidentiality.

3 Likes

Thank you so much for your suggestion. it works properly with the following method.
https://xxdomainxx/api/tracker/events.json?orgUnit=xxxxxxxxx&ouMode=DESCENDANTS&program=xxxxxxxxx&occurredAfter=2022-01-01&occurredBefore=2022-12-31&pageSize=500

2 Likes