Hi,
I need to store multiple records in a single table of the database.
Is this possible using "Write to Data Store Entity" or do I need to use "Write to Multiple Data Store Entity".
Thanks
Discussion posts and replies are publicly visible
In this case you're writing multiple records but one table or entity, so Write to Data Store Entity works here. If you've created a synced record type from this table you also have the choice to use the Write Records smart service instead.
I have used "Write to Data Store Entity" in my process model and even though I passed multiple rows of data (database records), only one row of data is getting saved.
Not sure why.
Any idea why it is happening like this. Do I need to use any kind of loop?
Make sure that the rule input for your CDT that gets saved has the "Multiple" checkbox checked, both on the write to datastore node and in the definition of the Process Variable. Either one of those off, and it will treat it as a singular value and boom only 1 row written.