Five Stars

Using an array for input to an ESB Service.

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

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

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

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

1 REPLY
Six Stars

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

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