cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
k3rz0rg
Advocate III
Advocate III

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'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!

1 ACCEPTED SOLUTION
mariussve1
Responsive Resident
Responsive Resident

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

View solution in original post

4 REPLIES 4
mariussve1
Responsive Resident
Responsive Resident

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

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

 

That is the escape code for '

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

@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 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors