Extracting Data value from Program Indicators to Aggregated data elements

Dear team,

I have a scenario on tracker with several hundred “Program Indicators” due to different age band which are auto calculated based on Date of birth. My intention is to create a simple/basic ETL whereby I can extract values program indicators on monthly basis or quarterly basis and load manually to Aggregated Data elements on the other instance (DHIS2) .

One of option is to insert in program indicators a Category option comb + Attribute option comb on the attributes on program indicators as a program indicator allow this. Now, my challenges is on how to pull a program indicators by using SQL view or Web API
with all necessary attributes especially category option comb and Attribute option comb and values.

Anyone ever performed this??, any advice will be much appreciated.

Best regards

Sele