How to Navigate This SmartConnect Error: Unable to cast object of type ‘System.Int32’ to type ‘System.String’

In this video, we will show you how to navigate the SmartConnect error: Unable to cast object of type 'System.Int32' to type 'System.String'.

You may be getting this error in SmartConnect 21 on-premise, when using an 'after document success' SQL Task to manipulate some SQL data after the record is successfully created. We will show you that this is indeed a SmartConnect error (not a SQL code or data issue) and how to fix this. If you'd rather read a help article on this, click here.