Repository navigation
RequestOptions Filter does not properly escape strings. #418
Description
Hi, I tried to find user by user name using request options however I still got errors until I tried to quote_plus the user name string.
Task:
Find user via user name
username=1oglop1+24@gmail.com
Steps
import tableauserverclient as tsc
# .. server sign in etc..
request_options = tsc.RequestOptions()
request_options.filter.add(
tsc.Filter(
tsc.RequestOptions.Field.Name,
tsc.RequestOptions.Operator.Equals,
'1oglop1+24@gmail.com'
)
)
users, pagination_item = server.users.get(request_options)
print(users)Expected result
[<User ada95cbc-ca59-4087-bbfe-acbcf55d88a4 name=1oglop1+24@gmail.com role=Creator>]
Actual result
[]
This is due to the character + in username.
I'm using quote_plus as a workaround.
import tableauserverclient as tsc
from urllib.parse import quote_plus
# .. server sign in etc..
request_options = tsc.RequestOptions()
request_options.filter.add(
tsc.Filter(
tsc.RequestOptions.Field.Name,
tsc.RequestOptions.Operator.Equals,
quote_plus('1oglop1+24@gmail.com')
)
)
users, pagination_item = server.users.get(request_options)
print(users)
# [<User ada95cbc-ca59-4087-bbfe-acbcf55d88a4 name=1oglop1+24@gmail.com role=Creator>]
Reacted by mark-thompson, Adam Rudd and holzben
Activity
rhelenius commentedon Jan 9, 2020
Quote plus worked for me as well except for when the % character is present.
jacalata commentedon Feb 16, 2023
This works today