Forum Discussion

twilkdaddy's avatar
twilkdaddy
Frequent Visitor
9 years ago

Does Power Query support OPTIONS METHOD?

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.Conten...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi twilkdaddy,

 

Do you mean passing query parameters with the Query argument of Web.Contents? If that is the case, the code below is for your reference. :smileyhappy:

let
Source = Json.Document(Web.Contents("https://ws-use.brightpearl.com/public-api/dude/contact-service/contact/", 

Query = [<insert record here of your query object>],

[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"]

 

Regards

twilkdaddy's avatar
twilkdaddy
Frequent Visitor
9 years ago

Thanks for the reply.  However, maybe I wasn't clear what I'm trying to accomplish.  

 

In standard web querying, there are GET, POST, DELETE, etc. METHODS you can call for your query.  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.  

 

Here's an example of what a C# syntax looks like for swithing to OPTIONS METHOD:

 

myHttpWebRequest.Method = "OPTIONS";

 

So, I'm wondering if anyone has a workaround in Power BI to allow for writing a query using OPTIONS instead of GET. 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    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

    • twilkdaddy's avatar
      twilkdaddy
      Frequent Visitor
      9 years ago

      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

      }