https://github.com/IDEMSInternational/open-app-builder/issues/2341 also suggests the existence of another possible issue to do with applying the merge operator to data lists that contain nested JSON data. I think it is sensible to handle this case as a follow-up if it does persist after applying the changes of this PR. In that case, a new debug sheet that exhibits the broken behaviour would be required.
Debug sheet: example_data_pipe_merge_nested which merges a data list with a translatable column (which is nested as .json)![image](https://github.com/IDEMSInternational/open-app-builder/assets/74557272/ecfa0528-299f-48e1-b610-7d688700a641)
with another data list. Syncing this gives the error:![image](https://github.com/IDEMSInternational/open-app-builder/assets/74557272/b99eebff-afe3-4ae4-ab8a-ef764ca070f8)
Originally posted by @esmeetewinkel in https://github.com/IDEMSInternational/open-app-builder/issues/2342#issuecomment-2188756018