I'm using this connector for workato integration, I have shared outsystems entity and try to get its records from workato.
I'm facing following error:
Error in advanced query ExecuteSelectOnSQL in ReadEntityByFilter in WorkatoConnector (SELECT top @MaxRecords @SelectStatement from OS@TableName where @WhereStatement @OptionalSort FOR JSON AUTO): Incorrect syntax near 'JSON'.
We have on premise outsystems environment and we are using SQL server version older than 2016 which I believe is a problem because it works in my personal Outsystems environment.
Is there any solution for this problem while using SQL server 2014