Forum Discussion
How to use apostrophe (') in REST API url for weird email address!
Hi everyone,
I was trying to bulk remove a users from specific workspaces and using REST API (Admin - Groups DeleteUserAsAdmin) through powershell and putting the url after -url 'the api url' -method delete.
now the problem is the user has a weird email address like ab.c'[email protected] and cannot use this in the url since that apostrophe in the email end the url before [email protected] and the call becomes invalid. For example:
it supposed to be -url 'https://api.powerbi.com/v1.0/myorg/admin/groups/{groupId}/users/ab.c'[email protected]' but it becomes
-url 'https://api.powerbi.com/v1.0/myorg/admin/groups/{groupId}/users/ab.c'[email protected]'
because that apostrophe after ab.c finishes the url code early.
Can somebody please give me any idea how to handle that apostrophe in the middle of API url code?
Also not sure if it's the right section for this request since this is not a desktop one but power bi service.
Thanks!
Hi.
Can you try to replace the apostrophe with %27
That should be the url encoding for '
https://api.powerbi.com/v1.0/myorg/admin/groups/%7BgroupId%7D/users/ab.c%[email protected]
Br
Marius
4 Replies
- mariussve1Solution Sage
Hi.
Can you try to replace the apostrophe with %27
That should be the url encoding for '
https://api.powerbi.com/v1.0/myorg/admin/groups/%7BgroupId%7D/users/ab.c%[email protected]
Br
Marius
- mariussve1Solution Sage
If that does not work, maybe you can try %60
That is the escape code for '
- mariussve1Solution Sage
Hehe.. I also se you might have to use $60 because that is the escape for the string '
Just trying to give you some options, so Sorry for all the answers. Would be great if you reply if any of the suggestions works.
Marius