inserting to sql getting error "Unable To Parse JSON Request"

[svisveswaraiya]

Hi,

I am trying to insert values from thingworx to sql table but on testing of insert stmt written in thingworx am getting an error "Unable to Invoke Service Insert_WaitingReason_Details on Kirloskar_DB_Access : The statement did not return a result set."

How can I sort this issue. Please provide some idea.

Thanks,

V Shalini.

[mnarang]

The problem is you have created the service as SQL Query type in the selection ,but ideally it should be as SQL Command type (Third selection in the dropdown ) .Run it with as SQL command type you will be able to insert if the written query is correct .

Thanks ,

Mukul Narang