Article - CS366970

How to retrieve the result of SQL query of external DB in custom JavaScript service in ThingWorx Platform?

Modified: 08-Apr-2022   


Applies To

  • ThingWorx Platform 9.0 to 9.3

Description

  • Wrote a SQL statement like below in a SQL(Query) service of a Database Thing and retrieve data successfully upon execution
SELECT count(<ColumnName>) FROM <TableName> 
  • How to write a custom JS service that build on the above query result
  • Tried to call SQL(Query) service and pass the count data to result in JS service but get "No data" when executing the service
This is a printer-friendly version of Article 366970 and may be out of date. For the latest version click CS366970