Azure / Azure/azure-rest-api-specs

[azure sql database] Fail to call azure rest api to get azure sql resources when resources has special characters, e.g., '/' and '%'

Open
#23,982 3 comments 0 reactions 0 assignees View on GitHub
customer-reported needs-team-attention question Service Attention SQL
Dominant language
TypeSpec
Stars
3.1k
Forks
5.9k
Avg merge
3d 2h
Merged PRs (30d)
424

Description

When I am trying out this API
![image](https://github.com/Azure/azure-rest-api-specs/assets/47666635/5a858c69-156a-403e-8c96-4c8decb8902d)

- when my azure sql schema contains special character '/', it will report
{"error":{"code":"ResourceNotFound","message":"The specified resource '***' was not found."}};
- when my azure sql schema contains special character '%', it will report
{
"error": {
"code": "InvalidDoubleEncodedRequestUri",
"message": "The request URI '**/schemas/testpercent%25schema/tables?api-version=2021-02-01-preview' is not valid, because it contains double encoding sequence '%25'."
}
}

Contributor guide

Open the contributing guide

Research direction

Start with the Azure SQL REST API request and error examples in this issue, focusing on the schema and table resource path. Trace how schema names containing '/' and '%' are represented in the API specification, and consider the work done when both resource forms can be requested without ResourceNotFound or double-encoding errors.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, sql
Domain
api, cloud, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
32/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.