TCI App Parsing Error for SQL Query % symbol

[srid b]

Hi,

I am new to TCI and created one TCI app where I am sending the "SQL query" as input(body)to the target service.

For normal queries it is working fine, but if my query ends with % symbol example: like '123%'then getting the parsing error as below

{"errors":[{"message":"Cannot parse the query [null]","type":"INVALID_DATA"}],"responseStatus":"FAILURE"}

Can you please let me know how to resolve this

Appreciate any quick help.

Thank You,

Sreedhar

[Ash Arendsz]

- Are you using TCI Connect (Scribe) or Businessworks

 

For a TCI Connect (Scribe) APP: Possible alternative solution:

Trycreating a SQL VIEW and calling the View from the Query block.

See TCI Connect (Scribe) SQL connector docomentation on using SQL views.

https://help.scribesoft.com/v2/en/index.htm#conn/sqlserver.htm