go to post Marc Mundt · May 5, 2022 Can you clarify a bit? Do you want to use curl to make an HTTP request to a web service running in Ensemble? Or do you want Ensemble to launch curl to make an HTTP request to an external web service?
go to post Marc Mundt · Apr 29, 2022 You can put something similar to Jeffrey's logic directly in the Value of the Set action. Instead of using $E ($EXTRACT) you would use DTL's built-in SubString function: ..SubString("123456789",1,3)_"-"_..SubString("123456789",4,5)_"-"_..SubString("123456789",6,9)
go to post Marc Mundt · Apr 26, 2022 Since this is a new design you should use persistent classes (SQL tables/objects) instead of writing directly to globals. A Data Transformation can use any persistent class as it's target, so this is also easier than storing directly in globals. https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.UI...
go to post Marc Mundt · Apr 26, 2022 Is there already a defined structure for these globals/do these globals already exist? Or will you design something new?
go to post Marc Mundt · Apr 26, 2022 Can you explain more about your use case? What is the purpose of copying these fields directly into globals? Is there another application that will read the values from the globals?
go to post Marc Mundt · Apr 25, 2022 All persistent classes will save their data in globals automatically. It will save using the standard structures of the IRIS SQL layer. If you have an existing global structure that you need to maintain you'll need to map your classes to your global structure. See this series of articles on how to do that.
go to post Marc Mundt · Apr 25, 2022 Have a look at this previous thread. And there's a built-in capability in IRIS to see ports in use by different components.
go to post Marc Mundt · Apr 22, 2022 I messed up the syntax: &sql(select LIST(MessageName), LIST(Identifier) INTO :tMsgNmList, :tIdentList from GMECC_DocmanConnect_Tables.ParisConnecMessagetSettings)
go to post Marc Mundt · Apr 22, 2022 How about this? Do the values returned in tMsgNmList and tIdentList match the values you're searching for? &sql(select LIST(MessageName) INTO :tMsgNmList, LIST(Identifier) INTO :tIdentList from GMECC_DocmanConnect_Tables.ParisConnecMessagetSettings) write SQLCODE, ":", tMsgNmList,":",tIdentList,!
go to post Marc Mundt · Apr 21, 2022 If you try this what does it return? &sql(select count(*) INTO :tCount from GMECC_DocmanConnect_Tables.ParisConnecMessagetSettings Where MessageName = :tMessageName and Identifier = :tIdentifier) write SQLCODE, ":", tCount,!