what should i fill in each blank of smart service in process model, or in interface smart service code?
Discussion posts and replies are publicly visible
Only guessing but is there a 1 to 1 relationship between the column headers in your excel spreadsheet and the columns in your table? Do you have an auto increment primary key column? Is any column marked as required in the database?
I have heard that auto increment primary key columns can cause issues if they are created from Appian rather than from the database. Was the table you are importing into created from a CDT in Appian?
I create datatypes from existing table of appian back end database, precautiously not let it couldn't insert duplicated data, i create a rowid which as number to be auto increment. Is this because i don't have any column called rowid since it as primary key? But i let it auto increment show have a number input in by itself successfully since my previous case did like this.