[OutSystems Workato Connector] Error in search record action

Forge Component
(4)
Published on 4 Aug (2 days ago) by OutSystems R&D
4 votes
Published on 4 Aug (2 days ago) 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