AnsweredAssumed Answered

Workflow - Next Value Node Delimiter

Question asked by Alex Grant on Dec 9, 2019
Latest reply on Dec 9, 2019 by Steve Alexandre

Hi folks,

 

Attempting to loop through a SQL selected array of XML values to perform IGL web service calls. The structure of an individual XML block is as follows:

 

<AccountChange>
   <operation>Disable</operation>
   <businessSource>Active Directory</businessSource>
   <account>CN=TestUser,OU=TestOU,DC=test,DC=com</account>
</AccountChange>

 

When I feed this array into a Next Value node, it splits by default on the comma character - this results in splitting the above XML into:

 

[<AccountChange><operation>Disable</operation><businessSource>Active Directory</businessSource><account>CN=TestUser],
[OU=TestOU],
[DC=test],
[DC=com</account></AccountChange>]

 

Is there a way to amend the Next Value node delimiter? If so, I could make sure to append my selected values with the delimiter character which I could be confident would not exist in the string.

 

Cheers,
Alex.

Outcomes