11-30-2017 07:31 AM
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.
11-30-2017 02:25 PM
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.