Authentication error when connecting Excel to IFS via OData feed

Hi @dsj @apshlk 

I actually managed to fetch data to excel using power query. I found below guide and also did some twerking to the code to achieve this.

https://www.myonlinetraininghub.com/connecting-to-an-oauth-api-like-paypal-with-power-query

This is the code I used 

let
    api_url = "https://servername.ifs.com/",
    token_path = "auth/realms/#realm_name#/protocol/openid-connect/token",
    ClientID = "client id", //client ID and secret from IAM client
    Secret = "secret",

    EncodedCredentials = "Basic " & Binary.ToText(Text.ToBinary(ClientID & ":" & Secret), BinaryEncoding.Base64),

    Token_Response = Json.Document(Web.Contents(api_url,
    [
        RelativePath = token_path,
        Headers = [#"Content-Type"="application/x-www-form-urlencoded",#"Authorization"=EncodedCredentials],
        Content=Text.ToBinary("grant_type=client_credentials")
    ]

    )),

    token = Token_Response[access_token],

    path = "main/ifsapplications/projection/v1/DocumentRevisionsHandling.svc/DocIssueSet?&$skip=0&$top=25",   //projection URL

    data = Json.Document(Web.Contents(api_url,
    [
        RelativePath = path,
        Headers =[#"Authorization"="Bearer "&token,#"Content-Type"="application/json"]
    ]

    )),

    values = data[value],
    #"Converted to Table" = Table.FromList(values, Splitter.SplitByNothing(), null, null, ExtraValues.Error),


    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"luname", "keyref", "DocClass", "DocNo", "DocSheet", "DocRev", "Title"}, {"Column1.luname", "Column1.keyref", "Column1.DocClass", "Column1.DocNo", "Column1.DocSheet", "Column1.DocRev", "Column1.Title"})
in
    #"Expanded Column1"

Below is the fetched data from excel

BR