How do I insert data rows into an SQL Database Table that has IDENTITY columns?

WOODY.IO does not directly support persisting data rows to an SQL Database Table that has IDENTITY columns. 

However, there is a workaround to that:

1. Create a new Live Edit Import Template. This one should always be used when Inserting new rows into the Table with Identity Column/s.
2. In the copied Import Template, remove the Identity Column/, then save and publish it.
   • Note: While the column may still appear in the Import, this behavior is unintended and will be addressed in a future fix.
3. In the Import, avoid entering any value in the Identity Column/s for new rows. Save the new row/s.
4. When you press "Persist," your data should be successfully persisted. For each persisted rows, the Database will assign an IDENTITY value automatically.

If you still have questions, don't hesitate to Contact Us.