I’m using REST API to export data from my database to suiteCRM with pentaho, the problem so far is when I did that with salesforce they have a option called external ID where you can choose a field to be the external id of that table like for example social security number and that whay the data will be compared with the external ID and make a UPDATE instead a insert if that field is alredy on the CRM there is anything related in suiteCRM.
Another question that I have is can I make a field UNIQUE?