Hi

I'm trying to add multiple rows at a time to a SQL table for a persistent object, but I can't seem to get the syntax correct. When I try the below it doesn't work.

INSERT INTO Sample_Table.Accounts (Account, AccountName, Bank) 
VALUES 
('123456', 'AccountNameOne', 'BANK1'),
('654321', 'AccountNameTwo', 'BANK2')

Thanks

Peter

After invoking a SOAP call in a SOAP Outbound Adapter Operation, how do we get the header information? For example, the HTTP 200 response code.

In SoapUI we can read the header information, but we're trying to view it in Production.

For our WSDL the portType value is being suffixed with "Soap" at the end.

When i update the the SERVICENAME parameter. in the Service I can update the start of the portType value. Is there a way to prevent the suffix being added?

WSDL segment

<portType name="BillingDocumentRequestConfirmation_OutSoap">
<operation name="BillingDocumentRequestConfirmationOut">
<input message="s0:BillingDocumentRequestConfirmationOutSoapIn"/>
<output message="s0:BillingDocumentRequestConfirmationOutSoapOut"/>
</operation>
</portType>
<binding name="BillingDocumentRequestConfirmation_OutSoap"

When I put a trace on a datastream that is a JSON object, I use the .%ToJSON(). Is there an equivalent to working with XML objects to view in the trace?