cancel
Showing results for 
Search instead for 
Did you mean: 

Message Mapping Question

Former Member
0 Kudos

Hi,

The Response of a WebService is this string:

<StockQuotes><Stock><Symbol>MSFT</Symbol><Last>28.63</Last>

<Date>8/13/2007</Date> <Name>MICROSOFT CP</Name></Stock></StockQuotes>

This is delivered as an xml:string type.

How do I map this to this structure:

MT_StockQuote_Response

- Symbol

- LastQuoteValue

- Date

- Name

TIA.

Regards.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

When I imported the WSDL of the WebService, I can only see a single element in the message structure, a xml:string. (The WS response is a string which can be parsed as an XML)

But in my response mapping, I need to amp this string to the structure I mentioned above. I dont think this is possible via Graphical Mapping, is it?

Former Member
0 Kudos

take the whole string and use string functions to take data between the fields and map it to target strucutre. you need to use UDF for string maniplution

Former Member
0 Kudos

i guess then there is a problem in importing the wsdl...since once u import the web service u ought to see messages in the 'message' tab. Just try re importing and then tell us if u r facing the same issue

Vaibhav

Former Member
0 Kudos

make sure u r importing the correct wsdl... u have to import one of the 3 wsdls which constitute the zip file of the wsdl

Vaibhav

Former Member
0 Kudos

When u have imported the wsdl as an external definition, in the 'messages' tab u will see the messages imported from wsdl. When u select those messages as sender message type in message mapping then graphical mapping can be done easily.

Vaibhav

Former Member
0 Kudos

karthik,

you can map this one to one directly

MT_StockQuote_Response

- Symbol --->Symbol

- LastQuoteValue--->LastQuoteValue

- Date--->Date

- Name--->Name

but this come only once even though source may come mutiple times . to work as it as source you need to change ur target strucutre

MT_StockQuote_Response

StockQuotes--->StockQuotes

Stock--->Stock

- Symbol --->Symbol

- LastQuoteValue--->LastQuoteValue

- Date--->Date

- Name--->Name