Concatenating fieldvalues and fieldnames in mapping

[Former Member]

Hi everyone, I need some help from the experts in this forum about mapping in Integration Designer.

I have several parameters in a file (.TXT) that I need to extract then send to a web service. This web service needs to receive these parameters in a format mimicking XML. For example:

(TXT File) 002, Test, A704

these need to transform into

<Fieldname1>002</Fieldname1><Fieldname2>Test</Fieldname2><Fieldname3>A704</Fieldname3>

I can't use WSDL because the web service only receives a single string, not XML formatted. It needs to be a single string formatted by me.

I can concatenate the field values in mapping to create the string:

002TestA704

but I'm having difficulties putting the fieldnames in there. Is there a way to put them there in mapping?

Thanks in advance for your help.

[Former Member · Accepted solution]

Hi Sergio,

Normally, the Web Service should be able to parse out the contents.

If you wish to pass the field names, in the mapping program, you can build the name-value pairs like 'Fieldname1=002&Fieldname2=Test' etc.

Hope this helps,

Bhanu

[Former Member · Accepted solution]

Hi Sergio,

Check this michals weblog and a thread...

/people/michal.krawczyk2/blog/2005/11/01/xi-xml-node-into-a-string-with-graphical-mapping

check if it suits your requirement...

Regards

Anand