Forum Discussion
Error in Azure Sentiment Analysis
amitchandak just wanted to give you an update, I've finally managed to get the sentiment analysis to work!!
I created parameters for the code so it ended up looking like this:
(text) => let
apikey = APIKey,
endpoint = Endpoint& "/text/analytics/v3.0/"&Service,
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)
in jsonrespI also had a parameter for language replacing the ""en"" but this didn't work so reverted but to the orginal
I'm so happy it worked in the end!!
amitchandak this is the erro:
An error occurred in the ‘’ query. Expression.Error: The field 'detectedLanguage' of the record wasn't found.
Details:
id=0
sentiment=positive
confidenceScores=
positive=1
neutral=0
negative=0
sentences=[List]
warnings=[List]
PaulaMcC , Is showing an error on detectedLanguage, Have you removed any columns ??
What are the steps you have performed
amitchandak I have removed columns prior to Invoked Custom Function. I've also got the text analysis custom function in the same query, I'll try it in a fresh query no & see if it makes a difference
