App Connect

 View Only

 Facing Couchbase Retrieving Json Data issue

KR Saiteja Sekhar's profile image
KR Saiteja Sekhar posted Tue December 09, 2025 02:01 AM

Hi 

I am trying to retrieve JSON data from Couchbase in which the JSON array is coming as object string as attached below.
Can I please know the solution for the same.

Srihari Ananda Kumar's profile image
Srihari Ananda Kumar

Hello Saiteja,

Can you share the schema / structure of the record, Wanted to understand if this is an Array of Strings or Array of Objects or any further combinations of the same

Thomas leonlaim's profile image
Thomas leonlaim

This usually happens when the JSON is stored or read as a string instead of an array.
In Couchbase (N1QL), you can fix it by using JSON_PARSE() or by correcting the field type in your model.

I faced a similar thing while working on my site Tipos de Flores, where flower data (categories, lists) must stay as proper JSON arrays—otherwise the app treats them like plain text.
Once the data type is correct, Couchbase returns clean JSON instead of a string. 🌸