Read a network request and response file

[kandyshandy]

Chetan, So did you get what you wanted?

[chetan.c]

That sounds like a good start. Now that we know you want to store rather than parse it, can you tell us what 'store' means here? Where / how does it need to be stored?

Hi Craig,

Actually i have to parse it and also store it.

By parsing i will be getting values from the XML which along with the field value data apart from the XML(example:RequestTimeEx=2011-12-21T01:27:05.228746Z) and write it into a table.

The XML's from different files need to be appended together and should be stored as one singl XML.

Thanks.

[chetan.c]

The logic is correct, and you can accumulate the XML as a single string in a stage variable. Output it once the closing tag has been processed (that is, if the input value is "</Request>"). ...

Hi Ray,

I have been trying to read as much as possible on stage variables.
Can you please let me know how to output the single string whihc has XML once the closing tag is processed?

Also please post any link for further reading on stage variables if you have any.

Thanks,
Chetan

[chetan.c]

Chetan, So did you get what you wanted?

hi kandy,

Thanks for the help with the logic and implementation!! Really appreciate you response.

Currently i am stuck in the last part where in the XML data is in different rows.
As ray suggested i have to write the XML once the closing tag(</Request>) has been processed.

Since XML is in different rows can you please help me with the logic on how to start reading at the opening tag in stage variable and output it after closing tag has been processd?


I am able to do this if XML is in one single coulmn and one single row.(To make it more clear like A1 cell in excel). But if it is in different rows i do not know how to process it.


Please let me know your thoughts on this.


Thanks,
Chetan

[kandyshandy]

It is something similar to what you have implemented for your non-XML lines

When you read start tag, set a stage variable to empty, otherwise concatenate the input row to the stage variable with some delimiter.

e.g. ''|Row1|Row2|.....

When you encounter the closing tag, write the stage variable to output column (use Index, Len, Field functions if required)

[ray.wurlod]

Can you please let me know how to output the single string whihc has XML once the closing tag is processed?

Place a constraint expression on the output link the specifies that the input field value is "</Request>".

[chetan.c]

Hi kandy,
Can you please paste some sample code for this?
I'm trying but getting confused on the way stage variables are working.


Thanks.

[chetan.c]

Hi ,

Finally succeded in developing the code for the job.
It is working perfectly.

A big thanks to Kandy .

Ray,craig,Muni shekar

Thanks for all the inputs.

Will be posting the entire code here shortly.

Thanks again,
Chetan.C