SQL Server Service: - SQL table with a dot in the name only shows List method
Issue
When create a SQL Server Service Instance SmartObject from a table in SQL with a dot in the name, the SmartObject only has a List method available.
Symptoms
Example: The SmartObject based off a table with the name [dbo].[My.Test.Table] will only expose the List method.
Resolution
To resolve this issue, complete the following steps:
- Rename the Table in SQL and use underscore instead of dots in the table names. ([dbo].[ My_Test_Table] for the example above)
- Using the SmartObject Services Tester Tool, refresh the SQL Server Service Instance.
- Recreate the SmartObject