Error executing sql query in creatio using VSCODE
08:42 Apr 24, 2025
Hi Community,
Any idea why I am getting this error executing sql query in creatio using VSCODE?
Unexpected token '', "<?xml ver"... is not valid JSON
Like
2 comments
17:20 Apr 24, 2025
I do wish that Clio Explorer would show the actual error returned.
As for the error, I assume the database is Postgresql, not MSSQL. Postgresql has case sensitive table/column names and must be enclosed in quotes (or they are assumed lower case, which won't match your tables/columns). For example:
select "Id" from "Account" where "Name" = 'Something'
Ryan
Show all comments