inserting to sql getting error "Unable To Parse JSON Request"
‎Aug 09, 2018
09:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Aug 09, 2018
09:10 AM
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.
Labels:
1 REPLY 1
‎Aug 10, 2018
01:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Aug 10, 2018
01:14 AM
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