Using an array for input to an ESB Service.

Anonymous — Sat, 16 Nov 2024 09:06:14 GMT

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

Re: Using an array for input to an ESB Service.

Anonymous — Fri, 03 Nov 2017 12:34:34 GMT

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

topic Using an array for input to an ESB Service. in Talend Studio

Using an array for input to an ESB Service.

Re: Using an array for input to an ESB Service.