Azure Content Moderator API call from Power BI

[PoojaG]

I'm trying to call an API Azure Content Moderator from Power BI. I have one column in a table which needs to be moderated. I have below information about the API. 

POST https://abz.cognitiveservices.azure.com/contentmoderator/moderate/v1.0/ProcessText/Screen/?language=eng&autocorrect=true&PII=true&classify=true200
974 ms
POST /contentmoderator/moderate/v1.0/ProcessText/Screen/?language=eng&autocorrect=true&PII=true&classify=true HTTP/1.1
Ocp-Apim-Subscription-Key: <confidential>
Content-Type: text/plain
User-Agent: PostmanRuntime/7.28.3
Accept: */*
Postman-Token: b41cc134-a107-45cd-8996-68b12356
Host: abz.cognitiveservices.azure.com
Accept-Encoding: gzip, deflate, br
Connection: keep-alive
Content-Length: 17

  and the power query looks like below:

let
    Source = (text) => let
    apikey      = "b9confidential",
    endpoint    = "https://abz.cognitiveservices.azure.com/contentmoderator/moderate/v1.0/ProcessText",
    jsontext    = Text.FromBinary(Json.FromValue(Text.Start(Text.Trim(text), 5000))),
    jsonbody    = "{ documents: [ { language: ""eng"", id: ""0"", text: " & jsontext & ",Content-Type: ""text/plain"" } ] }",
    bytesbody   = Text.ToBinary(jsonbody),
    headers     = [#"Ocp-Apim-Subscription-Key" = apikey],
    bytesresp   = Web.Contents(endpoint, [Headers=headers, Content=bytesbody]),
    jsonresp    = Json.Document(bytesresp),
    moderator  = jsonresp[documents]{0}[moderator]
in  moderator
in
    Source

I get an error when trying to invoke through custom function. Error says '404 Resource not found'. Can someone please help me correct the mquery? thank you

[v-yingjl]

Hi @PoojaG ,

You may refer simliar issues:

1. How to fix error “404” in Power BI M query 
2. THE HIDDEN GEMS OF THE FUNCTION WEB.CONTENTS() 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.