storing json text in multiple fields in crm

(0) Share

Report

Posted on by Community Member

Hello guys,
I have a Multiple lines of text field in CRM which is used to store JSON from an API call. This field is set to its maximum length. The issue is sometimes the json is too big and am thrown a validation error that the length of json exceeds the maximum length of the field.
How can I solve this issue? I cannot cut down on the properties the json is storing. I was thinking of adding another field to store the extra characters of the json in that field. But am thrown a " fail to serialize object".

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

Jeet Gandhi 320 on at

Like (1)

Report
Copy link

Link copied!

Hi Donald,

The maximum length of the multi line text field in CRM can be 1,048,576 characters for any entity. We can not override this constraint in any manner OOB.

As per your issue is concerned, I suggest you to use a Text file as an attachment in the entity "Notes" to store the JSON response from the API call.

Hope above information resolves your issue.

Please mark the answer if you feel helpful.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Jeet,

thanks for the response. Can you think of any other solution other than attaching it to notes?

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report
Copy link

Link copied!

How big is your json response? I would think 1M characters is more than enough.

Is CRM, the proper place to store this if you have larger JSON string?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

very valid question Aric :) Thing is, its never exceeded the maximum length of the field. However, I brought up this issue(that it is possible to exceed the maximum length) to my team and they want me to find a solution...

Was this reply helpful? Yes No
Guido Preite 54,086 Moderator on at

Like (1)

Report
Copy link

Link copied!

happened or not that you exceeded the maximum length or not? in your initial post you wrote that happened and in your last post that never happened

because I really doubt that a JSON response of an API call is bigger than 1MB.

Was this reply helpful? Yes No
ashlega 34,477 on at

Like (0)

Report
Copy link

Link copied!

Maybe we need to see some screenshots/numbers:

- What's the current length of that field?

- What's the actual length of that json?

If you really do have a problem with 1 MB (which I agree looks suspicious), createa another field, you'll have 2 MB.. Would it be enough?

Just don't forget that you need to concatenate those fields to get your actual json.. and you need to split before storing it in those fields..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hey guys,

Thank you all for the responses. I ended up using Jeet's idea to implement. I added a validation to check if the JSON is more than the maximum length of the field. If it is, I am storing the JSON as an attachment in the notes section.

Was this reply helpful? Yes No