# OpenAPI Sentiment Analysis return values issue

**URL:** <https://community.glideapps.com/t/openapi-sentiment-analysis-return-values-issue/62947>\
**Category:** Report a Bug\
**Created:** [June 19, 2023, 10:25pm UTC](https://community.glideapps.com/t/openapi-sentiment-analysis-return-values-issue/62947 "2023-06-19T22:25:22Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mark\_Eden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_eden/32/340_2.png) [@Mark\_Eden](https://community.glideapps.com/u/Mark_Eden)\
**Post date:** [June 19, 2023, 10:25pm UTC](https://community.glideapps.com/t/openapi-sentiment-analysis-return-values-issue/62947/1 "2023-06-19T22:25:22Z")

</div>

**Describe the bug:**

- When adding Analyze Sentiment type column, some of the returned values do not match the values in the docs; I see some values as **Positive** or **Neutral**.

**Expected behavior:**

- The returned values (in the column) should _all_ match the values in the docs ( **positive, neutral, negative** ), including case-sensitivity

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 19, 2023, 11:34pm UTC](https://community.glideapps.com/t/openapi-sentiment-analysis-return-values-issue/62947/2 "2023-06-19T23:34:48Z")

</div>

Can you add some screenshots or a video of the bug? Thank you.

---

<div class="post-metadata">

**Author:** ![Mark\_Eden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_eden/32/340_2.png) [@Mark\_Eden](https://community.glideapps.com/u/Mark_Eden)\
**Post date:** [June 20, 2023, 12:44pm UTC](https://community.glideapps.com/t/openapi-sentiment-analysis-return-values-issue/62947/3 "2023-06-20T12:44:11Z")

</div>

Sure thing @ThinhDinh . Hope this helps.

 ![Screenshot (8)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/78845ae7c0b9add16d0b139d0fdf08437a48807e.jpeg)

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [June 20, 2023, 2:59pm UTC](https://community.glideapps.com/t/openapi-sentiment-analysis-return-values-issue/62947/4 "2023-06-20T14:59:45Z")

</div>

Is there a reason youre pointing to a prompt?

If youre looking to analyze your comments, then the Sentiment should be pointing at your comments column so it can interpret if that comment is positive, neutral or negative. You dont need a formal prompt to generate a sentiment.

---

<div class="post-metadata">

**Author:** ![Mark\_Eden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_eden/32/340_2.png) [@Mark\_Eden](https://community.glideapps.com/u/Mark_Eden)\
**Post date:** [June 20, 2023, 5:48pm UTC](https://community.glideapps.com/t/openapi-sentiment-analysis-return-values-issue/62947/5 "2023-06-20T17:48:52Z")

</div>

Thanks, @Joe_Gabriele . This observation (presumably a bug) was to highlight that more than the documented 3 values are returned. Note the _Positive_ (with uppercase “P”) and _Neutral_ (with uppercase “N”) values in addition to the documented (all-lowercase) _positive_, _neutral_, _negative_ values. I wouldn’t expect the input to have any influence on this.

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [June 20, 2023, 5:54pm UTC](https://community.glideapps.com/t/openapi-sentiment-analysis-return-values-issue/62947/6 "2023-06-20T17:54:07Z")

</div>

![Screen Shot 2023-06-20 at 1.53.09 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5b3704a3cbd5095a729c972b412fda7069c4ecc8.png)

I can confirm that there is a random neutral with a capital N.

Interestingly enough, if I change “why” to “hi”, it goes to a lowercase neutral, and if I switch it back to “why” it goes back to a Capitalized Neutral. I also tried a bunch of different words and they go to “neutral” but going back to “why” moves it to Capital again. Very strange…

 ![Screen Shot 2023-06-20 at 1.57.52 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/927b7c91f6b904d4938ce4b992de969d4bb65eba.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 20, 2023, 6:00pm UTC](https://community.glideapps.com/t/openapi-sentiment-analysis-return-values-issue/62947/7 "2023-06-20T18:00:28Z")

</div>

cc @Jeremy 👆

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 20, 2023, 11:55pm UTC](https://community.glideapps.com/t/openapi-sentiment-analysis-return-values-issue/62947/8 "2023-06-20T23:55:26Z")

</div>

I wonder if the new functions thing can help with this, to force OpenAI to return a more defined set of outcomes.
