Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

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

svisveswaraiya
17-Peridot

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

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.

1 REPLY 1

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

Announcements


Top Tags