Language Keys API throws 400 when a duplicate key exists

[muhammadfaizandotcms]

Problem Statement

Language Keys API throws 400 when a duplicate key exists.
Relevant Ticket: https://dotcms.zendesk.com/agent/tickets/109737.
Reproduced in 23.01
API: https://demo.dotcms.com/api/v2/languages/default/keys.
Response: {"message":"Duplicate key dot.check.text (attempted merging values Value and Value)"}

Steps to Reproduce

1. log in to the demo site.
2. Go to Content types and click on Language Variable content type.
3. Edit the value field and make it non-unique.
4. now go to content->search portlet and create multiple contentlets of Language Variable with the same key (dot.check.text).
5. Now login to the demo site using the Cognito tab and see the response of Language keys API.
6. It's throwing 400.

Acceptance Criteria

API: https://demo.dotcms.com/api/v2/languages/default/keys.
Language API should not break when there is a duplicate key.
In 23.01 we can't add the same key twice for a language but it will create problems for the customers who will upgrade from old environments.

dotCMS Version

23.01

Proposed Objective

Core Features

Proposed Priority

Priority 2 - Important

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

Assumptions & Initiation Needs

No response

Sub-Tasks & Estimates

No response

[wezell]

PR: #26689

[josemejias11]

Approved: Tested on master_13c2337_SNAPSHOT, Docker, macOS 13.0, FF v113.0