Experts,
Power BI data is getting from api link. I have difficulty to connect using token authenticaton . Following is my code. What i am doing wrong here. please advise.
let
test = {username : Lordloc , password : ******},
AccessTokenHeader = "test" & "Bearer *" ,
Headers = [Authorization = AccessTokenHeader],
url = "https://dfsf.cdsfe.ae:3289/dede/getCusfedfsfock",
body = "{ ""plant"" : ""c051"",
""storageLocation"" : ""0001"",
""type"" : ""MARD"",
""sapid"": ""qEP""
}",
Source = Json.Document(Web.Contents(url,[
Headers = [#"Content-Type"="application/json"],
Content=Text.ToBinary(body)
])),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"plant", "material", "storageLocation", "warehouseNo", "quant", "storageType", "unrestrictedStock", "stockInTfr", "qualityInsp", "restrictedUse", "blocked", "returns", "totalQuantity", "availableStock"}, {"Column1.plant", "Column1.material", "Column1.storageLocation", "Column1.warehouseNo", "Column1.quant", "Column1.storageType", "Column1.unrestrictedStock", "Column1.stockInTfr", "Column1.qualityInsp", "Column1.restrictedUse", "Column1.blocked", "Column1.returns", "Column1.totalQuantity", "Column1.availableStock"}),
#"Renamed Columns" = Table.RenameColumns(#"Expanded Column1",{{"Column1.material", "material"}, {"Column1.plant", "plant"}, {"Column1.unrestrictedStock", "unrestrictedStock"}})
in
#"Renamed Columns"
teste
