Using an array for input to an ESB Service.

[Anonymous]

I have an ESB Service that currently accepts a single param of type String that is a comma delimited string of ID's. 

My Service needs to query a MSSQL DB but somehow map the ID's passed into the Service to ID's in a table. I currently have a ESBProviderRequest -> tXMLMap -> tESBProviderReponse but I don't know how to utilize that String of ID's to do what I'm wanting to do.

I'd appreciate some design help on this.

Thanks

[Anonymous · Accepted solution]

Hi there,

This can be done using a tNormalize component to split your string of IDs, resulting in a separate row in the output flow for each ID.

You'll find this under Processing/Fields in the component palette.

Regards,

Chris