How to use apostrophe (') in REST API url for weird email address!

[k3rz0rg]

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'd@xyz.com and cannot use this in the url since that apostrophe in the email end the url before d@xyz.com 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'd@xyz.com' but it becomes

-url 'https://api.powerbi.com/v1.0/myorg/admin/groups/{groupId}/users/ab.c'd@xyz.com' 

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!

[mariussve1 · Accepted solution]

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%27d@xyz.com

Br

Marius

[mariussve1]

If that does not work, maybe you can try %60

That is the escape code for '

[mariussve1]

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

[k3rz0rg]

@mariussve1 😅 Thank you for the suggestions and %27 worked for me 😄

I also found a HTML reference site listing all these weird characters hope someone might find useful through this thread later!

https://www.w3schools.com/tags/ref_urlencode.ASP

-K3