All
Accepted answers
Guilherme Koerber · Jul 12, 2022 go to post

Hi Oliver,

There is a possibility that you create a table in IRIS that connects to an external table. I've done tests with the ODBC format, it works well I believe JDBC too.

In this case, I recommend using a JDBC connection to communicate the IRIS database with Java.

SQL Gateway via JDBC: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=BS…
How to use the table wizard: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=BS…

Guilherme Koerber · Aug 1, 2022 go to post

Hi Jordan!

You can write the html as if it were a string inside TextData.Write()

Set tEmail = ##class(%Net.MailMessage).%New()
Set tEmail.IsHTML=1Set tSC = tEmail.TextData.Write("<h2 style='color: #5e9ca0;'>Hello World!</h2>")
Set tSC = ..Adapter.SendMail(tEmail)

Hope this helps :)

Guilherme Koerber · Jul 20, 2023 go to post

Thank you for the comment, Michael! Even though all the properties are filled, I did it the way you mentioned, but it still didn't work. I also tried adding an initial expression, but the content still appears empty. The solution was to set the extended request class as %XML.Adaptor, but either way, I appreciate your help.

Guilherme Koerber · Jul 20, 2023 go to post

Great news!
I thought this extension was only for cases where the call was with XML/SOAP, but in my case, it's JSON/REST. However, using it this way, the properties appear as I wanted them to. Thank you very much for your help!