Question
REST API request for SQL Query on Thingworx
Hello everyone,
Currently I am working with Thingworx and Javascript. I am trying to do an API request from a SQL Query in Thingworx, having the following data:
Thing: Test WP
SQL (Query) Service: getTest
Service content:
Select * from public.countries
no inputs required
output infotable (i changed to json, but got an error, infotable is successfull)
Using Postman to try to test it:
GET [Thingworx_Server]Thingworx/Things/Test%20WP/Services/getTest
Params:
Accept=application/json
Content-Type=application/json
Headers:
appKey: Application Krey created on Thingworx
Using GET I got 405 response, if I change it to POST, I got:
<head>
<title>Unexpected Error</title>
<script>
function clickAndDisable(link) {
link.onclick = function(event) {
event.preventDefault();
}
}
</script>
</head>
Anyone knows how i can fix it?