请问api中获取工作表结构信息 POST远程服务器返回错误: (405) 不允许的方法。

李俊峰 2021-11-09 00:58:46 分享收藏

7 / 662

获取应用信息 GET [https://api.mingdao.com/v1/open/app/get，这个 get 接口可以连通
但是 post 接口就无法连通了，提示远程服务器返回错误： (405) 不允许的方法。

获取工作表结构信息 POST [https://api.mingdao.com/v2/open/worksheet/getWorksheetInfo]

麻烦问下，可能是哪里的错误？或者哪里要设置这些接口的权限么？
工作表的 post 接口我都没法连通

4、我是申请的个人应用，测试用的

李俊峰 2021-11-09 00:58:46 回复

李恩涛（Team） 2021-11-08 19:55:07

参数之间，加下逗号。

感谢大家的指导，谢谢。
问题原因是我马虎大意了，a、传输的数据格式不是 application/json，导致 405 b、测试时候少了逗号没看出来
贴出来 post 里面参数转换，谁遇到了可以参考下

public static class HttpHelper
 {

     /// <summary>
     /// http/https请求响应
     /// </summary>
     /// <param name="getOrPost"></param>
     /// <param name="url">地址（要带上http或https）</param>
     /// <param name="headers">请求头</param>
     /// <param name="parameters">提交数据</param>
     /// <param name="dataEncoding">编码类型 utf-8</param>
     /// <param name="contentType">application/x-www-form-urlencoded</param>
     /// <returns></returns>
     public static HttpWebResponse HttpRequest(
         string getOrPost,
         string url,
         Dictionary<string, string> headers,
         Dictionary<string, string> parameters,
         Encoding dataEncoding,
         string contentType
         )
     {
         var request = CreateRequest(getOrPost, url, headers, parameters, dataEncoding, contentType);

         //如果需要POST数据  
         if (getOrPost.ToUpper() == "POST" && !(parameters == null || parameters.Count == 0))
         {
             var data = FormatPostParameters(parameters, dataEncoding, contentType);

             using (Stream stream = request.GetRequestStream())
             {
                 stream.Write(data, 0, data.Length);
                 stream.Close();
             }
         }

         WebResponse Res = null;
         try
         {
             Res = request.GetResponse();
         }
         catch (WebException ex)
         {
             Res = (HttpWebResponse)ex.Response;
         }
         catch (Exception e)
         {
             throw e;
         }

         if (null == Res)
         {
             return request.GetResponse() as HttpWebResponse;
         }

         return (HttpWebResponse)Res;
     }


     /// <summary>
     /// 创建HTTP请求对象
     /// </summary>
     /// <param name="getOrPost"></param>
     /// <param name="url"></param>
     /// <param name="headers"></param>
     /// <param name="parameters"></param>
     /// <param name="paraEncoding"></param>
     /// <param name="contentType"></param>
     /// <returns></returns>
     private static HttpWebRequest CreateRequest(
         string getOrPost
         , string url
         , Dictionary<string, string> headers
         , Dictionary<string, string> parameters
         , Encoding paraEncoding
         , string contentType
         )
     {
         if (string.IsNullOrEmpty(url))
         {
             throw new ArgumentNullException("url");
         }

         if (parameters != null && parameters.Count > 0 && paraEncoding == null)
         {
             throw new ArgumentNullException("requestEncoding");
         }

         HttpWebRequest request = null;
         //判断是否是https  
         if (url.StartsWith("https", StringComparison.OrdinalIgnoreCase))
         {
             ServicePointManager.ServerCertificateValidationCallback =
                 new RemoteCertificateValidationCallback(CheckValidationResult);
             request = WebRequest.Create(url) as HttpWebRequest;
             request.ProtocolVersion = HttpVersion.Version10;
         }
         else
         {
             request = WebRequest.Create(url) as HttpWebRequest;
         }

         if (getOrPost == "GET")
         {
             request.Method = "GET";

             if (parameters != null && parameters.Count > 0)
             {
                 url = FormatGetParametersToUrl(url, parameters, paraEncoding);
             }
         }
         else
         {
             request.Method = "POST";
         }

         if (contentType == null)
         {
             request.ContentType = "application/x-www-form-urlencoded;charset=UTF-8";
         }
         else
         {
             request.ContentType = contentType;
         }

         //POST的数据大于1024字节的时候，如果不设置会分两步
         request.ServicePoint.Expect100Continue = false;
         request.ServicePoint.ConnectionLimit = int.MaxValue;

         if (headers != null)
         {
             FormatRequestHeaders(headers, request);
         }

         return request;
     }


     /// <summary>
     /// 格式化请求头信息
     /// </summary>
     /// <param name="headers"></param>
     /// <param name="request"></param>
     private static void FormatRequestHeaders(Dictionary<string, string> headers, HttpWebRequest request)
     {
         foreach (var hd in headers)
         {
             //因为HttpWebRequest中很多标准标头都被封装成只能通过属性设置，添加的话会抛出异常
             switch (hd.Key.ToLower())
             {
                 case "connection":
                     request.KeepAlive = false;
                     break;
                 case "content-type":
                     request.ContentType = hd.Value;
                     break;
                 case "transfer-enconding":
                     request.TransferEncoding = hd.Value;
                     break;
                 default:
                     request.Headers.Add(hd.Key, hd.Value);
                     break;
             }
         }
     }


     /// <summary>
     /// 格式化Get请求参数
     /// </summary>
     /// <param name="url">URL</param>
     /// <param name="parameters">参数</param>
     /// <param name="paraEncoding">编码格式</param>
     /// <returns></returns>

     private static string FormatGetParametersToUrl(string url, Dictionary<string, string> parameters, Encoding paraEncoding)
     {
         if (url.IndexOf("?") < 0)
             url += "?";
         int i = 0;
         string sendContext = "";
         foreach (var parameter in parameters)
         {
             if (i > 0)
             {
                 sendContext += "&";
             }

             sendContext += HttpUtility.UrlEncode(parameter.Key, paraEncoding)
                    + "=" + HttpUtility.UrlEncode(parameter.Value, paraEncoding);
             ++i;
         }

         url += sendContext;
         return url;
     }


     /// <summary>
     /// 格式化Post请求参数
     /// </summary>
     /// <param name="parameters">编码格式</param>
     /// <param name="dataEncoding">编码格式</param>
     /// <param name="contentType">类型</param>
     /// <returns></returns>
     private static byte[] FormatPostParameters(Dictionary<string, string> parameters, Encoding dataEncoding, string contentType)
     {
         string sendContext = "";
         int i = 0;
         if (!string.IsNullOrEmpty(contentType) && contentType.ToLower().Trim() == "application/json")
         {
             sendContext = "{";
         }

         foreach (var para in parameters)
         {
             if (!string.IsNullOrEmpty(contentType) && contentType.ToLower().Trim() == "application/json")
             {
                 if (i > 0)
                 {
                     if (para.Value.StartsWith("{"))
                     {
                         sendContext += string.Format(@",""{0}"":{1}", para.Key, para.Value);
                     }
                     else
                     {
                         sendContext += string.Format(@",""{0}"":""{1}""", para.Key, para.Value);
                     }

                 }
                 else
                 {
                     if (para.Value.StartsWith("{"))
                     {
                         sendContext += string.Format(@"""{0}"":{1}", para.Key, para.Value);
                     }
                     else
                     {
                         sendContext += string.Format(@"""{0}"":""{1}""", para.Key, para.Value);
                     }

                 }
             }
             else
             {
                 if (i > 0)
                 {
                     sendContext += string.Format("&{0}={1}", para.Key, HttpUtility.UrlEncode(para.Value, dataEncoding));
                 }
                 else
                 {
                     sendContext = string.Format("{0}={1}", para.Key, HttpUtility.UrlEncode(para.Value, dataEncoding));
                 }
             }

             i++;
         }

         if (!string.IsNullOrEmpty(contentType) && contentType.ToLower().Trim() == "application/json")
         {
             sendContext += "}";
         }

         byte[] data = dataEncoding.GetBytes(sendContext);
         return data;
     }


     private static bool CheckValidationResult(object sender, X509Certificate certificate, X509Chain chain,
         SslPolicyErrors errors)
     {
         return true; //总是接受  
     }

 }

5、调用

             Dictionary<string, string> dict = new Dictionary<string, string>();
             dict.Add("appKey", App_Key);
             dict.Add("sign", sign);
             dict.Add("worksheetId", "618737a7b72f7c785f101773");
             var reqGET = HttpHelper.HttpRequest(
                  "POST"    //string getOrPost,
                 , url   //string url,
                 , null    //List < KeyValuePair < string, string >> headers,
                 , dict    //List < KeyValuePair < string, string >> parameters,
                 , Encoding.UTF8                    //Encoding dataEncoding,
                 , "application/json"                                   //string contentType
                 );

             System.IO.StreamReader readerGET;
             readerGET = new System.IO.StreamReader(reqGET.GetResponseStream(), Encoding.UTF8);
             var respHTML = readerGET.ReadToEnd();  //得到响应结果
             readerGET.Close();
             reqGET.Close();

李恩涛（Team） 2021-11-08 19:55:07 回复

参数之间，加下逗号。

李俊峰 2021-11-08 17:13:42 回复