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 header requires anonymous authentication, if I choose anonymous my api wont authnticate to give results.

Please help

Need Help

8 Replies

    • belurrashmi's avatar
      belurrashmi
      Frequent Visitor
      8 years ago

      v-chuncz-msft thank you for reply.

      I saw some posts with the examples and tried, Apikeyname works with anonymous login thats my error message.

      I am using basic authentication here for api login then I was to pass custom header.

      In the advanced editor section when I provide custom headers I get error "Expression.Error: The 'X-Result-Detail' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, If-Modified-Since, Prefer, Referer"

      • 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?