Forum Discussion
Does Power Query support OPTIONS METHOD?
Hi twilkdaddy,
Sorry for my misunderstanding.
I don't think the Power Query Web.Contents method supports the OPTIONS method currently. You can add it as an idea on Power BI Ideas to improve Power BI on this feature. :smileyhappy:
Regards
Thanks for the respnse v-ljerr-msft.
Does anyone know if a System.Net HttpWebRequest query can be fed into the Power BI Query Advanced Editor? I know the OPTIONS method is available using C# query code. See general code below that I beleive I can modify to make an OPTIONS method request to the API service I'm trying to query from.
using System;
using System.IO;
using System.Net;
using System.Text;
public enum HttpVerb
{
GET,
OPTIONS
}
namespace HttpUtils
{
public class RestClient
{
public string EndPoint { get; set; }
public HttpVerb Method { get; set; }
public string ContentType { get; set; }
public string Accept { get; set; }
public string brightpearl-app-ref { get; set; }
public string brightpearl-account-token { get; set; }
public RestClient()
{
EndPoint = "";
Method = HttpVerb.OPTIONS;
ContentType = "application/json";
Accept = "application/json";
}
public RestClient(string endpoint)
{
EndPoint = endpoint;
Method = HttpVerb.OPTIONS;
ContentType = "application/json";
Accept = "application/json";
}
public RestClient(string endpoint, HttpVerb method)
{
EndPoint = endpoint;
Method = method;
ContentType = "application/json";
Accept = "application/json";
}
public RestClient(string endpoint, HttpVerb method, string postData)
{
EndPoint = endpoint;
Method = method;
ContentType = "application/json";
Accept = "application/json";
}
public string MakeRequest()
{
return MakeRequest("");
}
public string MakeRequest(string parameters)
{
var request = (HttpWebRequest)WebRequest.Create(EndPoint + parameters);
request.Method = Method.ToString();
request.ContentLength = 0;
request.ContentType = ContentType;
if (!string.IsNullOrEmpty(PostData) && Method == HttpVerb.OPTIONS)
{
var encoding = new UTF8Encoding();
var bytes = Encoding.GetEncoding("iso-8859-1").GetBytes(PostData);
request.ContentLength = bytes.Length;
using (var writeStream = request.GetRequestStream())
{
writeStream.Write(bytes, 0, bytes.Length);
}
}
using (var response = (HttpWebResponse)request.GetResponse())
{
var responseValue = string.Empty;
if (response.StatusCode != HttpStatusCode.OK)
{
var message = String.Format("Request failed. Received HTTP {0}", response.StatusCode);
throw new ApplicationException(message);
}
// grab the response
using (var responseStream = response.GetResponseStream())
{
if (responseStream != null)
using (var reader = new StreamReader(responseStream))
{
responseValue = reader.ReadToEnd();
}
}
return responseValue;
}
}
} // class
}