Does Power Query support OPTIONS METHOD?

Question

I am trying to write a query using the OPTIONS method in order to pull URIs for contactIDs in my data set. However, I cannot find any documentation on how to apply the OPTIONS METHOD to a Web.Contents query.

Does anyone know if this is possible and, if not, is there a workaround??

See code below:

let
Source = Json.Document(Web.Contents("https://ws-use.brightpearl.com/public-api/dude/contact-service/contact/", [Headers=[#"brightpearl-app-ref"="dude_powerbi-1", #"brightpearl-account-token"="GNVf5bK9ihanzifXke3BKkr2vp2fPntxOqJoKAXnsjI=", accept="application/json", #"accept-encoding"="gzip, deflate", #"accept-language"="en-US,en;q=0.8", #"Content-Type"="application/json"],#"Query"="OPTIONS"]))
in
Source

v-ljerr-msft · Answer

Hi&nbsp;twilkdaddy,
&nbsp;
Do you mean&nbsp;passing query parameters with the Query argument of Web.Contents? If that is the case, the code below is for your reference.&nbsp;:smileyhappy:
let
Source = Json.Document(Web.Contents("https://ws-use.brightpearl.com/public-api/dude/contact-service/contact/",

Query = [&lt;insert record here of your query object&gt;],

[Headers=[#"brightpearl-app-ref"="dude_powerbi-1", #"brightpearl-account-token"="GNVf5bK9ihanzifXke3BKkr2vp2fPntxOqJoKAXnsjI=", accept="application/json", #"accept-encoding"="gzip, deflate", #"accept-language"="en-US,en;q=0.8", #"Content-Type"="application/json"]))
in
Source
An example of the Query record might be:
Query = [#"Argument 1" = "aaa", #"Argument 2" = "bbbb"]
&nbsp;
Regards

twilkdaddy · Answer

Thanks for the reply. &nbsp;However, maybe I wasn't clear what I'm trying to accomplish. &nbsp;&nbsp;In standard web querying, there are GET, POST, DELETE, etc. METHODS you can call for your query. &nbsp;I'm attempting to call using the OPTIONS method; however, it doesn't look like the Power Query Web.Contents method supports the OPTIONS method. &nbsp;&nbsp;Here's an example of what a C# syntax looks like for swithing to OPTIONS METHOD:&nbsp;myHttpWebRequest.Method = "OPTIONS";&nbsp;So, I'm wondering if anyone has a workaround in Power BI to allow for writing a query using OPTIONS instead of GET.&nbsp;

v-ljerr-msft · Answer

Hi&nbsp;twilkdaddy,
&nbsp;
Sorry for my misunderstanding.
&nbsp;
I don't think&nbsp;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.&nbsp;:smileyhappy:
&nbsp;
Regards

twilkdaddy · Answer

Thanks for the respnse&nbsp;v-ljerr-msft. &nbsp;&nbsp;Does anyone know if a System.Net HttpWebRequest query can be fed into the Power BI Query Advanced Editor? &nbsp;I know the OPTIONS method is available using C# query code. &nbsp;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.&nbsp;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) &amp;&amp; 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 responseusing (var responseStream = response.GetResponseStream()){if (responseStream != null)using (var reader = new StreamReader(responseStream)){responseValue = reader.ReadToEnd();}}return responseValue;}}} // class}

Forum Discussion

Does Power Query support OPTIONS METHOD?

4 Replies

Related content

shortcuts - Refresh Method

Power BI Service Refresh Failure: OAuth authentication method isn't supported for this data source

Authentication Method for lakehouse

Datatable options

Campaign Voucher FAQ & Support