Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I am building a python script for automating add user to datasource, as I debug the script, I am getting this error.
full error:
{'error': {'code': 'BadRequest', 'message': 'Bad Request', 'details': [{'message': 'Invalid JSON. A token was not recognized in the JSON content.', 'target': 'userAccessRightEntry'}]}}
===
context = adal.AuthenticationContext(authority, validate_authority=True)
token = context.acquire_token_with_username_password(resource, username , password, clientid)
accessToken = token['accessToken']
#print('this is the token:', accessToken) #after this line the code is throwing me the error above.
headers = {'Authorization': 'Bearer {}'.format(accessToken), 'Content-Type': 'application/json'}
body = { 'emailAddress' : '_@email.com', 'AccessRight' : 'Read'}
try:
response = requests.post(_uri, headers=headers, data=body)
results = response.json()
print ("response:", results)
except Exception as e:
print (str(e))
@Anonymous
This doesnt resolve the issue.
I tried changing the header before posted this issue with the header format you provided:
headers = {
"Authorization": "Bearer " & str(accessToken),
"Content-Type": "application/json",
)
HI @Anonymous,
How about directly using fixed tokens string in your post step?
BTW, you can also try to change the variable name if this issue is related to the conflict of variable and function parameter names.
context = adal.AuthenticationContext(authority, validate_authority=True)
token = context.acquire_token_with_username_password(
resource, username, password, clientid
)
accessToken = token["accessToken"]
# print('this is the token:', accessToken) #after this line the code is throwing me the error above.
_headers = {
"Authorization": "Bearer xxxxxxxxxxxxxx",
"Content-Type": "application/json",
}
body = {"emailAddress": "_@email.com", "AccessRight": "Read"}
try:
response = requests.post(_uri, headers=_headers, data=body)
results = response.json()
print("response:", results)
except Exception as e:
print(str(e))
Regards,
Xiaoxin Sheng
HI @Anonymous,
I think this should more relate to the 'headers' structure, you can try to use the following codes if it works on your side.
context = adal.AuthenticationContext(authority, validate_authority=True)
token = context.acquire_token_with_username_password(
resource, username, password, clientid
)
accessToken = token["accessToken"]
# print('this is the token:', accessToken) #after this line the code is throwing me the error above.
headers = {
"Authorization": "Bearer " & str(accessToken),
"Content-Type": "application/json",
}
body = {"emailAddress": "_@email.com", "AccessRight": "Read"}
try:
response = requests.post(_uri, headers=headers, data=body)
results = response.json()
print("response:", results)
except Exception as e:
print(str(e))
Regards,
Xiaoxin Sheng