API wiki post: developers, collaborate here with API Q&As & tips you find helpful for other developers

[Gassim (AL-Gassim Sharaf Addin)]

Very glad to hear that. (: Thanks for the comment @mykbitz! A good reminder to keep adding input. It’s a wiki so community members are welcome to add their contributions.

@mykbitz

when wanting to pull SQL views to my data models - i.e the period structure, pulling comments made on tracked events, etc.

True! Recently, we were discussing a method to download the SQL view xls using the API

Using SQL View for integration

Hi @Shapr0019 & @Gassim , I have made changes to the script you have provided. import requests url = "https://play.dhis2.org/2.39.0.1/api/sqlViews/jaChwoXyY1N/data.xls" username = "admin" password = "district" response = requests.request("GET", url, auth=(username,password)) open('SQLViewresult.xls','wb').write(response.content) This should work. Thanks, Rithvik