Hi, I have a case in our application where we consume data from pulsar via Pulsar Message Consumer, but what I noticed is that record type for the table which we are storing the data is not synchronizing automatically and after researching I saw that not all smart services can sync the record automatically.
So, my question is: can I add a Write Records node after Pulsar Message Consumer node so that the record will be synced, and if not what can be the best solution to this as scheduling a full sync is not an option because the process runs every 30 min each day, and we can schedule a full sync once a day.
Thank you
Discussion posts and replies are publicly visible
I suggest to use the "Sync Records" smart service to do that.
In any case where your data is coming into Appian and then you are writing it, then sync will happen automatically as you will be using one of the supported smart services, but if you are directly interacting with the Database via an external system, them you might need to explicitly sync the records using the Sync Records smart service.
but the data we are getting is in the JSON format and we have a process variable of type Text, then when I added the Sync Records smart service I needed to add something as identifier, I added this variable and the process normally failed.
Can you propose what can I add as identifier?
You will need to create a rule that converts that JSON into your recordtype and finally save it in the record type process variable. Then simply use the write record smart service and get rid of explicit sync.
AFAIK that pulsar node returns some data that should include the primary key of the inserted row. That should qualify as an identifier.
Can we use 'Sync Records' smart service to sync less than 1000 data?
Yes. It will only sync the records that you provide the primary key value for.
works, thanks