Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Rest API executeQueries Python

Hello Developer Community, Context: Programming Language- Python Enviroment -Azure Databricks Authentication Type: 'acquire_token_with_client_credentials' Problem Statement: While using t...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thank you for the reply. But i think i solved the issue by passing the body as a string value.

    body = '''{
  "queries": [
    {
      "query": "EVALUATE VALUES(Merge1[Email])"
}
  ],
  "serializerSettings": {
    "includeNulls": "true"
  }
}'''


     

mshilendhari's avatar
mshilendhari
Frequent Visitor
3 years ago

Hi, I had similar issue and your solution fixed the 400 error.

 

But now i am getting 401 error below:

<Response [401]> {"error":{"code":"PowerBINotAuthorizedException","pbi.error":{"code":"PowerBINotAuthorizedException","parameters":{},"details":[],"exceptionCulprit":1}}} JSON Response {'error': {'code': 'PowerBINotAuthorizedException', 'pbi.error': {'code': 'PowerBINotAuthorizedException', 'parameters': {}, 'details': [], 'exceptionCulprit': 1}}}

 

Here's my code:

 

body = '''{
"queries": [
{
"query": "EVALUATE VALUES(BENEFIT_PLAN[LAST_UPDATE_DATE])"
}
]
}'''
api_call = requests.post(url=datasets_rowcount_url,data=body, headers=header)
query_json=api_call.text.encode().decode('utf-8-sig')
print(query_json)