How to handle multiple result sets

[wsuen]

Hi There,

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.

[jjohnson-21]

Hello Wendy,

Have you tried to run the service against the store procedure? Is it coming back as one large InfoTable or something different?

[wsuen · Accepted solution]

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