How to convert XML to CSV format?

[Former Member]

I am facing some issue while converting XML format output into CSV format and sending it through mail.

I tried using HTTP_POST block but the problem is I want to change the URL dynamically while running in different servers.

Can anyone give some inputs on this? Is there any other way out?

[Former Member]

I want to change the port no. dynamically in the URL of http post action block.

The port no. is maintained in the netweaver administration.

Can anyone suggest any method on how to dynamically fetch the port no. from netweaver administration.

[Former Member]

Hi,

Are you using http post action block to convert XML to CSV format?

Your problem statement seems a bit confusing.

Regards,

Anushree

[Former Member]

Hi,

Yes I am using http post action block to convert XML to CSV format.I am getting the output in CSV format but I want to dynamically change the URL in http post action block when I am running the transaction in different servers.How can it be done?

Regards,

Shitikantha Nanda

[Former Member]

Hi Shitikantha,

If you want to hit the local server always using the http post use server:// in the URL instead of using <protocol>://server:port.

This works in web service action block so should also work in http action block.

Regards,

Rohit Negi.