Hi,
I am trying to use "Sync Records" smart service after using "Execute Stored Procedure"
I found in the documentation that in order to use "Sync Records" smart service with a service-backed record type, you must first configure a Sync Expression on your record type.
As per the documentation, in order to generate a new Sync Expression, I have to follow the below steps
docs.appian.com/.../records-data-sync.html
But, unfortunately I am not able to find the "GENERATE EXPRESSION RULE" under Sync Changed Records.
Any advise here.
Discussion posts and replies are publicly visible
When you write about a stored procedure, I assume that your synced record connects to a database as well. Then you do not need any expressions.
Using my stored procedure, I am inserting data into two different tables. But, the tables data is not reflecting immediately into respective RecordTypes.
Then where is the need to create a Sync Expression if the source of your recordType is just a Database table and not a web service. If both of these Record types have sync enabled then automatic sync using Sync Records smart service should work without any additional setup. Is manual sync working as expected? please make sure that your structure is same in DB and Record Type look for the column definition of primary key column and ensure that it is not UNSIGNED or BIGINT and what do you mean by "not reflecting immediately", is it getting synced without triggering a manual sync but taking more time than what you expect?
You need to add the sync records smart service.
This is explained in the documentation: docs.appian.com/.../Sync_Records_Smart_Service.html