Connector Improvement: Medallia - Add Ordinal Column to feedback_answer Table
CompletedIn order to correctly handle multivalued responses to questions contained in the medallia api json response, a new column needs to be added to the feedback_answer table that contains the ordinal rank of each response to a question when the response is multivalued. This is because some medallia multivalued responses are intended to capture a rank-order.
Consider a question like:
Rank your favorite Bluey Characters:
1. Bluey
2. Bingo
3. Chili
4. Bandit
5. Snickers
If the json response payload contains [3, 4, 1, 2, 5] then storing these without order does not allow end users to correctly interpret the results.
If instead we store:
Response | Order
1 | 3
2 | 4
3 | 1
etc.
Then we can correctly understand the response.
-
Official comment
Hi,
Late update: we have made the changes to the connector to address this.
Thanks.
Please sign in to leave a comment.
Comments
1 comment