Hello everyone,
I'm encountering an issue with record type. I have a table in my database responsible for storing HTML template code for each user. When retrieving the data through records, I'm not receiving the full length of the HTML code; it's breaking. The column in the database has a VARCHAR data type with a limit of approximately 65,000 characters, while the length of the HTML code string is only 4000 characters. In DB we have full length code.Can anyone provide assistance or suggest a workaround for this problem?
Discussion posts and replies are publicly visible
Sure. Synced records are limited to 4000 characters for text fields. Switch off sync to allow more.
https://docs.appian.com/suite/help/24.1/records-data-sync.html#when-to-use-data-sync
Thank you, Stefan, for your response. However, in addition to the retrieval issue, I also need synchronization. This is crucial because users have the ability to add new HTML templates for new joiners through their external system. Without synchronization, how can I ensure that the current data is reflected accurately? Should we implement a scheduler to sync the records at specific time intervals?
Not sure what you mean. With enabled sync, Appian keeps a copy of the data in the internal data server. Then, a sync mechanism is needed to keep that copy in sync with the backend system. If you disable sync, any query will always hit the backend system directly.
Got it , thank you so much for your time