I need the Adapter State and Status of the business operation, which I do not see in the provided query.

How can I retrieve the Job Status when it is an error, along with the adapter text? In my case, I am looking for 'Error' and 'Disconnected' from my above image.

Thanks

What would the SQL query look like to retrieve the individual schema names from this list? Ideally, I want to export each of these as a separate objects instead of the one large object under ^EnsHL7.Schema

Perfect. Thank you.

Exactly what I needed. Thank you.

Exactly what I needed. Thank you :)

Just what I was looking for. Thanks

That was the issue. I did not have a production process specified for my SOAP service. I wanted to test connectivity before building other components like the process operation. Good to know!

Here is what I have now:

And the response via a successful web request: HTTP/1.1 202 Accepted

Thank you for this :)

Adding in the port allowed me to hit the service but still returning the 500 error. Here is the error from the service:

Using URL: http://localhost:52773/csp/soappassthrough/EnsLib.SOAP.GenericService.c…

I have configured unauthorized access for our applications as you mentioned and still no luck reaching the service. I think my URL formatting is incorrect. 

What am I missing here?

Class ECUH.BPL.ClassMethods.X509CredentialAlias Extends %String
{

Parameter VALUELIST As COSEXPRESSION = "..GetValueList()";

ClassMethod GetValueList() As %String
{
	Set sql = "SELECT LIST(Alias) As ValueList FROM %SYS.X509Credentials"
	Set resultSet = ##class(%SQL.Statement).%ExecDirect(,sql)

	If (resultSet.%Next())
	{
		Return $char(34) _ "," _ resultSet.ValueList _ $char(34)
	}
	Return ""
}

}

This currently returns:

Not sure I understand how a method can be passed into a COSEXPRESSION even after reading the ref. materials.

I now have an issue with the App settings list within the Business Process not updating once a cert is removed from the certificate credentials manager. If I add a cert, it reflects in the list but once removed, the cert alias stays in the settings list. Any ideas on how I can update the property list that's being stored to reflect the current list state?

This worked perfectly. I had  modify the string output of GetValueList() to wrap the list in quotes like this:  ",Flight Vector,test"

ClassMethod GetValueList() As %String
{
	Set sql = "SELECT LIST(Alias) As ValueList FROM %SYS.X509Credentials"
	Set resultSet = ##class(%SQL.Statement).%ExecDirect(,sql)

	If (resultSet.%Next())
	{   
		Return $char(34) _ "," _ resultSet.ValueList _ $char(34)
	}
	Return ""
}