Skip to main content
New Participant
Apr 16, 2024 6:45 AM UTC
Question

CDT has more than 150+ columns

I have a use case that requires keeping the API response in CDT and the API response would have more than 150+ fields. It's only for keeping the values in CDT and we are not storing/retrieving them into the Database.? These changes impact any performance and data break into our system. Also, provide your regards regarding these changes.

[mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]  

[mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] 

 [mention:92ac9d4559ff43edb28eaa01ed77691b:e9ed411860ed4f2ba0265705b8793d05] 

2 replies

karumurua531442
Participating Frequently
Apr 16, 2024 6:51 AM UTC

Hi [mention:2e86986b0ad242328df4bac5ffba014f:e9ed411860ed4f2ba0265705b8793d05] Appian official guidance just recommends less than 100 fields you go through this link design guidance  you get better idea on designing data types.

mikes0011
Brainy
Apr 17, 2024 2:24 PM UTC

Sorry, I'm not really clear what actual answer or advice you're asking for.  Have you tried something and found it to not be working, or...?

The Expression Guru