cancel
Showing results for 
Search instead for 
Did you mean: 

SOAP Execute - formatting the envelope

jkeller
New Contributor III

I’m working on an integration with Explorance Blue - using a soap execute to import data from a csv file (which was created in snaplogic).

In the soap envelope - the syntax for some of the inputs is not working. I’m looking for syntax specifically for the ColumnName and ColumnType strings

<SOAP-ENV:Envelope
xmlns:SOAP-ENV=“http://schemas.xmlsoap.org/soap/envelope/
xmlns:ns0=“http://tempuri.org/
xmlns:ns1=“http://schemas.microsoft.com/2003/10/Serialization/Arrays”>
SOAP-ENV:Header
ns0:APIKeyHeader$APIKeyHeader</ns0:APIKeyHeader>
ns0:ColumnName#foreach($string in $string)
ns1:string$string</ns1:string>#end
</ns0:ColumnName>
ns0:ColumnType#foreach($string in $string)
ns1:string$string</ns1:string>#end
</ns0:ColumnType>

ns0:IncrementalImport$IncrementalImport</ns0:IncrementalImport>
ns0:TransactionID$TransactionID</ns0:TransactionID>
</SOAP-ENV:Header>
SOAP-ENV:Body
ns0:FileStreamTransferRequest
ns0:Data$Data</ns0:Data>
</ns0:FileStreamTransferRequest>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

For the $Data variable I am feeding in the /project//.csv

Any thoughts are much appreciated.

1 REPLY 1

del
Contributor III

@jkeller,

For this post, can you reformat your XML code so that the ML doesn’t confuse the browser? Please put 4 spaces in front of each line so that the angle brackets are not hidden in the final output…

Aside from that, does #foreach($string in $string) work in velocity? I’m not sure, and it may not make a difference, but it seems to me that the variable scope might get confused so I would choose something like #foreach($s in $string) instead.