I have a service that executes a Store Procedure that returns 2 results sets. I cannot edit the SP because the client doesn't want to.
How do I handle multiple result sets in Thingworx?
Thank you in advance for your help.
Have you tried to run the service against the store procedure? Is it coming back as one large InfoTable or something different?
Nvm. I created another service in js to call the service that executes the SP. And used a datashape that have multiple info tables. Then in the js service got a specific table and its row and column
Retrieving data ...