Outsystems Cloud Platform - Extension calling stored procedure on external database

Outsystems Cloud Platform - Extension calling stored procedure on external database

  

I have a stored procedure that generates XML with a FOR XML clause.  I'm not sure how to get the xml back to the extension so I can return it as a string/xml to the Service Studio.  I see IDataReader, but I don't have an option to use XMLReader.  How would I go about doing this?

Hi Michael. 

To use it in Service Studio you'll have to return it as a text, as there isn't a xml type. 

Maybe this can help with what you are trying to do? https://gist.github.com/jakenuts/7563039