Skip to main content
S
svisveswaraiya_2859881-Visitor
1-Visitor
August 9, 2018
Question

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

  • August 9, 2018
  • 1 reply
  • 1045 views

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

M
mnarang5-Regular Member
5-Regular Member
August 10, 2018

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

Terms & ConditionsCookie settingsAccessibility statement