Solved

Data written by Write to Data Store Entity not getting synced in record type.

Forum|Forum|3 years ago
February 6, 2023
12 replies
0 views

Appian documentation at - https://docs.appian.com/suite/help/22.4/records-data-sync.html#smart-services-that-automatically-sync-data mentions following

Data sync will automatically sync any data changed by select smart services.

I have the following database record type with the sync enabled.

I am writing new record to DB using write to DSE smart-service.

The record gets created into DB table, however the record list does not get refreshed. I have to do full-sync manually to retrieve the newly added record.

Am I missing something?

Best answer by abhayd3663

As a first step, check whether the record type is showing the updated record in the list. If it is, then it's a UI refresh issue.

gayathris111098

Quick ques,

"If you use this smart service to add or update data in a database table, and that table is the source of a record type with data sync enabled, those changes will be automatically synced in Appian" - did you verify this? is this table you are updating is the source of that record?

abhayd3663Author

Yes the table is same.

stefanhelzle0001

Brainy

Use the "Write Records" smart service to persist your data. The "WDSE" node bypasses the record and sync.

abhayd3663Author

Thanks Stefan, that's the ideal way to do it. However I was wondering why record does not sync with WDSE.

The Appian documentation clearly mentioned that - "Data sync will automatically sync any data changed by select smart services" and WDSE is one of those.

stefanhelzle0001

Brainy

OK. I had in mind that the WDSE node does not trigger sync and I seem to have ignored you mentioning this in your initial post.

The documentation also mentions the following

"Additionally, your CDT should not contain any fields that accept an array of values. If you write data to a field that accepts an array of values, those changes cannot be synced."

Maybe this is the issue.

Sign up

Login with SSO

Login to the community

Login with SSO