Forum Discussion

belurrashmi's avatar
belurrashmi
Frequent Visitor
8 years ago

How to include header in the web data source?

I  am trying to get data from a api source and it requires header  X-Result-Detail=info,properties. What is the best way to pass this parameter with Basic authentication? I get error that the above...
Need Help
belurrashmi's avatar
belurrashmi
Frequent Visitor
8 years ago

I changed my way to get the content my request works in the below format,

When I covert it into Power BI query format 

 

 

let
body="items.find({""repo"" : ""maven-prereleases-local""},{""@PL000003_RELEASE"" : {""$match"" : ""*17*""}}).include(""repo"",""path"",""name"",""created"",""updated"",""@PL000003_RELEASE"")",
Source = Json.Document(Web.Contents("https://artifactory.xyz.com/api/search/aql", Content=Text.ToBinary(body)))

in
Source

 

I get error as Expression.Error: The name 'Content' wasn't recognized.  Make sure it's spelled correctly.

 

Why is that?

 

 

 

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

belurrashmi,

 

You need to specify the value as a record.

[Content=Text.ToBinary(body)]
  • belurrashmi's avatar
    belurrashmi
    Frequent Visitor
    8 years ago

    After fixing the content value, I am getting error as

     

    DataSource.Error: Web.Contents with the Content option is only supported when connecting anonymously.
    Details:
    DataSourceKind=Web
    DataSourcePath=https://artifactory.xyz.com/api/search/aql

     

    v-chuncz-msft do you have any thoughts on this issue. 

    making anonymous login will fail authentication from the api side

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Community Support
      8 years ago

      belurrashmi,

       

      Edit permissions in data source settings and try again.

      • belurrashmi's avatar
        belurrashmi
        Frequent Visitor
        8 years ago

        As I mentioned earlier, after changing the authentication to anonymous login will fail authentication from the api side.