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