Data model: Json data type limitations

Forum|Forum|1 year ago
September 3, 2024
4 replies
86 views

Hi Team,

I was looking for any limitations to length or any other limitations for Json data type for properties in the data model but was unable to find it in the documentation.

Do we have any limitations? If yes, we would want to know. We are planning to use the json data type in the model to store values for an ongoing project as part of our solution.

Thanks,

Akash

@Aditya Kotiyal

Best answer by Thomas Sjolshagen

Hi,

From the API documentation for DM Containers:

The JSON fragments have to be valid JSON objects. If JSON arrays are to be stored, these must be wrapped in a JSON object. JSON values (such as string, number, boolean) should use their respective primitive form instead. The maximum allowed size for a JSON object is 40960 bytes

See https://api-docs.cognite.com/20230101/tag/Containers/operation/ApplyContainers#!path=items/properties/containerPropertyIdentifier*/type&t=request

T

Thomas SjolshagenAnswer

Lead Product Manager

Hi,

From the API documentation for DM Containers:

The JSON fragments have to be valid JSON objects. If JSON arrays are to be stored, these must be wrapped in a JSON object. JSON values (such as string, number, boolean) should use their respective primitive form instead. The maximum allowed size for a JSON object is 40960 bytes

See https://api-docs.cognite.com/20230101/tag/Containers/operation/ApplyContainers#!path=items/properties/containerPropertyIdentifier*/type&t=request

Jørgen Lund

Product Manager

Hi @Akash Sood, please use the Developer Comminity group on Hub for questions not related to Data Workflows. You’ll get quicker and better responses there :-)

Akash SoodAuthor

MVP ⭐️⭐️⭐️⭐️⭐️

Thanks @Thomas Sjølshagen

Akash

Akash SoodAuthor

MVP ⭐️⭐️⭐️⭐️⭐️

@Jørgen Lund sure will use the correct group. I incorrectly asked on the wrong group

Akash

Sign up

Welcome to Cognite Hub