I am trying to consume a web service in BLS transaction and want to build a graph over the output. The output of web service is of type string( Complex XML returned in the form of string) which is to be converted in to rowsets format. But i cant see the complex type at design time as the type of output is string and i cant parse the web service output.
I tried to use XSL transformation but that seems to be difficult.
Can any one tell me how to solve this problem ?
Thanks a lot,
I am trying to do what you said. But, i am unable to assign the output of xmldecode() to a local XML property as xmldecode is also returning a string. xmldecode and xmlencode functions take a string as input and give a string as output.
And, can you tell me what should be stored in reference document ? The XML response structure can be directly stored in local XML property and that can be used for design time mapping.
Thanks a lot.
Create a Local XML property and assign the encoded XML string to it via the xmldecode() function. Next assign a reference document to the local property that represents what the XML response will look like, makes it easier to assign links at design time (See Help Docs). That's all that you need to do.