我有 ASP.NET web api
接收Web请求并返回 Json
数据 .
浏览到此网址:http://1.2.3.4/api1/api/values/mypartname
将返回以下json字符串:
{
\"PartName\": \"mypartname\",
\"PartDes\": \"53.6X53.6APA/ALIM1NOTPAK\",
\"PartLocation\": \"A36\"
}
但是当发送包含空格或引号的零件名称时: http://1.2.3.4/api1/api/values/my part na"me
我收到 404 - File or directory not found.
错误 .
我正在使用 json
消耗 json
,如下所示:
static void Main(string[] args)
{
try
{
string partName = "TAPE 56 3M 3/4\"";
WebRequest wr = WebRequest.Create("http://1.2.3.4/api1/api/values/" +
HttpUtility.UrlEncode(partName));
wr.Credentials = CredentialCache.DefaultCredentials;
HttpWebResponse hwr = (HttpWebResponse)wr.GetResponse();
Stream dataStream = hwr.GetResponseStream();
StreamReader reader = new StreamReader(dataStream);
string json = reader.ReadToEnd();
//some json parsing function
des(json);
reader.Close();
dataStream.Close();
hwr.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
Console.ReadKey();
}
}
此行抛出异常: HttpWebResponse hwr = (HttpWebResponse)wr.GetResponse();
,异常消息为: The remote server returned an error: (404) Not Found.
我在 mypartname
做错了吗?我还尝试根据这个来手动替换有问题的字符:HTML URL Encoding Reference并使用此函数: Uri.EscapeDataString(partName)
但没有运气 .
EDIT
这是routeConfig定义:
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.MapRoute(
name: "Default",
url: "{controller}/{action}/{id}",
defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional }
);
和api GET方法:
// GET api/values/5
public string Get(string id)
{
List<dummy> dummies = new List<dummy>();
string con = "user id=sa;" +
"password=1234" +
"server=someServer\\someInstance;" +
"database=game; " +
"connection timeout=30";
//SqlConnection sqlConn = new SqlConnection(con);
using (SqlConnection sqlconn = new SqlConnection(con))
{
sqlconn.Open();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT PART.PARTNAME,PART.PARTDES, PARTPARAMA.LOCATION ");
sb.Append("FROM PART LEFT JOIN PARTPARAMA ");
sb.Append("ON PART.PART = PARTPARAMA.PARTPARAM ");
sb.Append("WHERE PART.PARTNAME = @part");
using (SqlCommand cmd = new SqlCommand(sb.ToString(), sqlconn))
{
cmd.Parameters.AddWithValue("part", id);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
dummies.Add(new dummy
{
PartName = sdr.IsDBNull(0) ? "Unknown" : sdr.GetString(0),
PartDes = sdr.IsDBNull(1) ? "Unknown" : sdr.GetString(1),
PartLocation = sdr.IsDBNull(2) ? "Unknown" : sdr.GetString(2)
});
}
}
}
if (dummies.Count() > 0)
{
string json = JsonConvert.SerializeObject(dummies[0]);
return json;
}
else
{
string json = JsonConvert.SerializeObject(null);
return json;
}
1 回答
EDIT 2015年4月10日:
我在这里留下这个答案给那些在搜索中找到它的人,不过凯文在下面说的是Scott Hanselman says here:
我认为你的问题更多地与零件名称中的正斜杠有关 . 您可以使用处理空格和引号
而不是
HttpUtility.UrlEncode(partName)
.处理正斜杠更成问题 . 有关详细信息,请参阅this post .