我们要想使用web api, 需要首先在azure 中创建application. (如何创建application可以参考我的另一篇blog 从O365中获取users到D365中 )
Get
我们可以用JObject 和 JArray 来快速获取而不需要DeserializeObject
//server-side online oauth2 var sessionResult = (Opportunity)Session["OpportunityData"]; var httpUrl = resourceUrl + "api/data/v9.1/accounts?$filter=accountid%20eq%20" + "hello world"; AuthenticationContext authContext = new AuthenticationContext("https://login.windows.net/common", false); AuthenticationResult result = authContext.AcquireToken(resourceUrl, clientId, new UserCredential(account, password)); using (HttpClient httpClient = new HttpClient()) { ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12; httpClient.Timeout = new TimeSpan(0, 2, 0); // 2 minutes httpClient.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", result.AccessToken); httpClient.DefaultRequestHeaders.Add("OData-MaxVersion", "4.0"); httpClient.DefaultRequestHeaders.Add("OData-Version", "4.0"); HttpResponseMessage response = httpClient.GetAsync(httpUrl).Result; var returnvalue = response.Content.ReadAsStringAsync().Result; LogHelper.WriteLog("Return value:"); LogHelper.WriteLog(returnvalue); JObject jo = JsonConvert.DeserializeObject<JObject>(returnvalue); JArray ja = JsonConvert.DeserializeObject<JArray>(jo["value"].ToString());
}
POST:
ServicePointManager.SecurityProtocol 是必须要添加的. 不然会抛出 security 的exception.
req.Headers.Add("If-Match", "*"); 如果我们在请求的表头里添加了 if-match的话, 如果有相同的record创建时,会抛出 exception 412 error 而不会去创建一条一模一样的数据.
var weburi = resourceUrl + "api/data/v9.1/accounts"; AuthenticationContext authContext = new AuthenticationContext("https://login.windows.net/common", false); AuthenticationResult result = authContext.AcquireToken(resourceUrl, clientId, new UserCredential(account, password)); HttpWebRequest req = (HttpWebRequest)HttpWebRequest.Create(weburi); req.Method = "post"; req.Accept = "application/json"; req.ContentType = "application/json; charset=utf-8"; req.Headers.Add("OData-MaxVersion", "4.0"); req.Headers.Add("OData-Version", "4.0");
req.Headers.Add("If-Match","*"); req.Headers.Set("Authorization", "Bearer " + result.AccessToken); ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12 | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls; var newSurveyResult = new JObject(); newSurveyResult.Add("booleanvalue", true); newSurveyResult.Add("stringvalue", "Hello World!");byte[] data = Encoding.UTF8.GetBytes(newSurveyResult.ToString()); Stream newStream = req.GetRequestStream(); newStream.Write(data, 0, data.Length); newStream.Close(); using (HttpWebResponse res = (HttpWebResponse)req.GetResponse()) { //StreamReader read = new StreamReader(res.GetResponseStream()); string head = res.Headers.ToString(); }
PATCH:
var weburi = resourceUrl + "api/data/v9.1/accounts?$filter=accountid eq " + id; AuthenticationContext authContext = new AuthenticationContext("https://login.windows.net/common", false); AuthenticationResult result = authContext.AcquireToken(resourceUrl, clientId, new UserCredential(account, password)); HttpWebRequest req = (HttpWebRequest)HttpWebRequest.Create(weburi); req.Method = "PATCH"; req.Accept = "application/json"; req.ContentType = "application/json; charset=utf-8"; req.Headers.Add("OData-MaxVersion", "4.0"); req.Headers.Add("OData-Version", "4.0"); req.Headers.Set("Authorization", "Bearer " + result.AccessToken); ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12 | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls; var newSurveyResult = new JObject { {"stringvalue", "Hello World"}, {"intvalue", 123 }, { "booleanvalue" , true} }; byte[] data = Encoding.UTF8.GetBytes(newSurveyResult.ToString()); Stream newStream = req.GetRequestStream(); newStream.Write(data, 0, data.Length); newStream.Close(); using (HttpWebResponse res = (HttpWebResponse)req.GetResponse()) { StreamReader read = new StreamReader(res.GetResponseStream()); }