Data Structure Field Type Limitations

[Taylor W]

Are there are any big limitations to using the Data Structure field type? Can I simply store a large JSON Object in this field and all is well? It was hard to find documentation on this subject so any information would be helpful. Thanks!

[Michael Jones -]

That particular field type is essentially only used on one table; wf_element_activity used in the Flow Activity Designer I believe. It is meant to hold the definition of a data structure, not an actual complex data object itself. There really isn't much to go on for this data type, but I've looked at it before and haven't found a way to use it the way you're indicating. 

If you're looking to store a large JSON object you would be better served using a large string field and JSON.stringify() / JSON.parse. 

I hope this helps!

If this was helpful or correct, please be kind and remember to click appropriately!

Michael Jones - Proud member of the CloudPires team!

[Jocel_s]

I was looking at this and I think you're right. It holds a "definition" and not an actual data that you can push and use on sysparm_query queries. 

problem with JSON as well is you can't use it either to filter data. 

[Michael Jones - · Accepted solution]

Just following up to see if my answer was helpful, or if you needed any further information. 

I hope this helps!

If this was helpful or correct, please be kind and remember to click appropriately!

Michael Jones - Proud member of the CloudPires team!