Hello All,
I 'am tying to mimic the below curl in python::
Thank you.
Regards,
John Jacob
I 'am tying to mimic the below curl in python::
Output: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**::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::
Output:-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