Connecting Power BI to Informatica Axon API

[dt36]

Hello Everyone,

I am try to connect Informatica Axon api with Power BI but I am getting an 400 error.

Could someone please tell me what I am doing wrong in the below query?

let

url= "http://10.250.137.145:9999/api/v1/queryreport/facets",

headers = [

#"apikey" = "put API key here",

#"accept" = "application/json",

#"Content-Type" = "application/json",

#"method" = "post"

],

content = 

"{

{

""mainFacet"" : ""GLOSSARY"",

""searchGroups"": [

{

""operator"": ""START"",

""searches"": [

{

""operator"": ""START"",

""faceid"": ""GLOSSARY"",

""filterGroups"": []

                        }

            ]

      }

   ]

}

}",

webdata = Web.content(url, [Headers=headers, Content = Text.ToBinary(content)]),

response = Json. document (webdata)

in

response