hi all,
can anyone help
i could be wrong but microsoft seem to have made entity detection availble in the ACS. im trying to call it but am getting cannot convert a record into type text!
this is the code - i cant write M, i pinched it from the MS guidance for key phrases and adapted it for entities. I'm invoking the function on a sngle column of unstructured survey responses. i've cleaned it for sentiment analysis, so uneccesary punctuation and non lexical characters are gone
// Returns entities from the text in a comma-separated list
(text) => let
apikey = " xxxx ",
endpoint = "https://uksouth.api.cognitive.microsoft.com/text/analytics/v2.0/entities",
jsontext = Text.FromBinary(Json.FromValue(Text.Start(Text.Trim(text), 5000))),
jsonbody = "{ documents: [ { language: ""en"", id: ""0"", text: " & jsontext & " } ] }",
bytesbody = Text.ToBinary(jsonbody),
headers = [#"Ocp-Apim-Subscription-Key" = apikey],
bytesresp = Web.Contents(endpoint, [Headers=headers, Content=bytesbody]),
jsonresp = Json.Document(bytesresp),
entities = Text.Lower(Text.Combine(jsonresp[documents]{0}[entities], ", "))
in entities
