[OutSystems Workato Connector] Error in search record action
Question
Forge component by OutSystems R&D

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

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.