Download data element in DHIS2 using API

[Shapr0019]

Dear ALL,
I need your assistant

How to download data element in DHIS2 using API showing the following in one excel
• Data element Name and Code
• Category option combination Name and Code
• Data Value
• Period
Regards

[Gassim (AL-Gassim Sharaf Addin)]

Hi @Shapr0019

Thank you for your post!

I remember you had posted a similar question before:

Using SQL View for integration

Is it possible to extract aggregate data element data values (with all category combination) using SQL and then using API to extract from executed SQL query to Excel using r, python or powerB1. Regards Shepherd @Gassim out of interest .

The suggested solution should also work for the request above.

Thanks!