Discussions

So we created a custom table and got the REST working, but when we create a BO based on the table with the same name, I don't know how to set it up so that the BO when pushing to the table is not trying to insert a new ID/primary key and just let the table auto increment.

My table had a column set as primary key and indentity turned on with auto increment. But the BO is trying to post an ID to the table causing an "Cannot insert explicit value for identity column in table 'XXXX' when IDENTITY_INSERT is set to OFF" error in the backend.

If there is a better way to handle the BO to custom table with the same names, please let me know. I know this is somewhat outside of the SDK, but trying to use the REST to push data into a custom table and then using the imis tools to pull the data out. I know I could turn around and pull it all back out via REST.