Using an array for input to an ESB Service.

Six 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)

Accepted Solutions
Eight 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


All Replies
Eight 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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download