Hi All,
I'm looking to query datasets from within code engine (a similar function exists but avoiding calling codeengine within codeengine to use that function)
def new_users(dataSetId="insert"):
url = f"https://api.domo.com/v1/datasets/query/execute/{dataSetId}"
body = {"sql": "SELECT * FROM 'table_name'"}
response = codeengine.send_request('post', url,body=body,headers=None, contentType="application/json")
return response
The working pydomo equivilent is
from pydomo import Domo
domo = Domo(client_id,client_secret,url)
domo.datasets.query(table,query)
PyDomo throws error in code engine.
Documentation:
https://developer.domo.com/portal/52fd0777839f4-query-a-data-set
https://developer.domo.com/portal/35115c5c48927-datasets-api
Error(s) returned:
Pydomo:
JSONDecodeError at line 29 of /var/task/app.py: Expecting value: line 1 column 1 (char 0)
ModuleNotFoundError at line 62 of /var/task/executor.py: No module named 'pydomo
Code Engine:
JSONDecodeError at line 41 of /var/task/executor.py: Expecting value: line 1 column 1 (char 0)
Code Engine Configuration
Input: TEXT
Output: OBEJECT