Calling Oracle REST SQL Python

Hello All,

I 'am tying to mimic the below curl in python::

sh-4.2$ curl -X "POST" "http://slc05ewk.us.oracle.com:8080/ords/hr/_/sql" \
       -H "Content-Type: application/sql" \
       -u TESTUSER1:testuser1 \
       -d $'SELECT sysdate FROM dual;'

**output**::
{"env":{"defaultTimeZone":"PST8PDT"},"items":[{"statementId":1,"statementType":"query","statementPos":{"startLine":1,"endLine":1},"statementText":"SELECT sysdate FROM dual","resultSet":{"metadata":[{"columnName":"SYSDATE","jsonColumnName":"sysdate","columnTypeName":"DATE","precision":0,"scale":0,"isNullable":1}],"items":[{"sysdate":"2020-11-04T04:56:22Z"}],"hasMore":false,"limit":100,"offset":0,"count":1},"response":[],"result":0}]}sh-4.2$ 

I tried below with python, but it doesn’t give the above…

# import requests module 
import requests 
from requests.auth import HTTPBasicAuth 
  
# Making a get request 
url = 'http://slc05ewk.us.oracle.com:8080/ords/hr/_/sql'
sql = 'select sysdate from dual;'
response = requests.get(url, auth = HTTPBasicAuth('testuser1', 'testuser1'), data=sql) 
  
# print request object 
print(response.text) 

All i get is below::

-bash-4.2$ python restSQL_1.py 
{"database_product_name":"Oracle","database_product_version":"Oracle Database 20c Enterprise Edition Release 20.0.0.0.0 - Development\nVersion 20.1.0.0.0","database_major_version":20,"database_minor_version":0}
-bash-4.2$ 

How do i get it done ?

Thank you.
Regards,
John Jacob