Trying to use string input in my query to return the columns based on the tableName input provided but i'm seeing error

[aseaton]

I'm trying to use a string input in my query to return the columns based on the tableName input provided but i'am  seeing this error result and here is my script:

When the query service is called with the input the query executed looks like:

and so i think this syntax should be correct. Any advice on this?

Thanks

Message was edited by: Sushant Pandey branched from https://community.thingworx.com/message/59921#59921 as new question

[supandey · Accepted solution]

Hi Andrew,

For String substitution you'd want to use << >> instead of [[ ]]. I believe this is discussed more at length here under the topic JDBC Extensibility (at the end of that documentation)

Hope this'd help.