We recently purchased the Webservice license and are trying to implement with our Excel workbooks using oData feed data sources (v1 REST API using Basic authentication)
When I include the ClaimedLicense in the header, I get this error:
The ‘ClaimedLicense’ header is only supported when connecting anonymously.
Does anyone have a workaround or solution for this?
Might this be a syntax error? In the documentation, I see the header format looks like this:
The header is “License” and its value is {ClaimedLicense: “…”}
Never tried it with the OData feed though…
Agree with @Mark_Wonsil looks like your format is a bit off.
Try like this:
let
Headers = [
#"Authorization"="Basic " & p("Base64Auth")
, #"ClaimedLicense"="00000000-0000-0000-0000-000000000000"
, #"Content-Type" = "text/plain"
],
Source = OData.Feed("{FEED}", Headers, [Implementation = "2.0"])
in
Source
Or might be like this as I have never used the Webservice license, so I’m guessing based on Mark’s documentation provided:
let
Headers = [
#"Authorization"="Basic " & p("Base64Auth")
, #"License"="{ClaimedLicense:""00000000-0000-0000-0000-000000000000""}"
, #"Content-Type" = "text/plain"
],
DataFeed = OData.Feed("{FEED}", Headers, [Implementation = "2.0"])
in
DataFeed
Very welcome, glad to help!
