topic Re: Sending internal table data to Application server using XML format in Application Development and Automation Discussions

Sending internal table data to Application server using XML format

former_member308418 — Tue, 29 Jun 2021 15:20:38 GMT

Dear All,

Good day.

I am trying to send data from my internal table to the application server in XML format. I have used CALL TRANSFORMATION for this purpose. My report is generating XML data but when I am trying to put that XML file in XML Validator, I am getting errors like data is broken and going to another line. So, users actually cannot use that data. Please tell me a way to solve this from my end.

Here is my piece of code for the conversion.

DATA : itab TYPE swbhtmltable,

lv_xml_result TYPE string,

lv_file TYPE string.

CALL FUNCTION 'SWA_STRING_TO_TABLE'
EXPORTING
character_string = lv_xml_result
IMPORTING
character_table = itab.

OPEN DATASET lv_file FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

LOOP AT itab INTO DATA(wa).
TRANSFER wa-linedata TO lv_file.
ENDLOOP.

CLOSE DATASET lv_file.

Re: Sending internal table data to Application server using XML format

Gourab_Dey — Tue, 29 Jun 2021 15:32:33 GMT

Hi Ferdaus,

Did you try downloading the data to your local system to make sure the transformation is correct? Also what is the length of the internal table line?

Thanks,

Gourab

Re: Sending internal table data to Application server using XML format

former_member308418 — Tue, 29 Jun 2021 16:21:46 GMT

Dear Sandra Rossi,

Thanks for the prompt reply. The error says as below. Also, I am attaching my file here. Please check.text.txt

Re: Sending internal table data to Application server using XML format

former_member308418 — Tue, 29 Jun 2021 16:25:18 GMT

Hi Gourab,

Thanks for your reply. Internal table line has a length of char255. Did you mean to convert from my transported xml file to internal table again ?

Re: Sending internal table data to Application server using XML format

Gourab_Dey — Tue, 29 Jun 2021 16:30:57 GMT

The error you are getting is due to new line character. There are couple of line break.

Re: Sending internal table data to Application server using XML format

Gourab_Dey — Tue, 29 Jun 2021 16:33:53 GMT

See the attached file, I have removed the line break and tested with XML validator, it passed the validation.

xmltxt.txt

Re: Sending internal table data to Application server using XML format

Gourab_Dey — Tue, 29 Jun 2021 16:38:20 GMT

Can you please do one thing. Dont split the string into table. Write the string directly to AL11 and see how it's working.Also, how you are seeing the generated file? Are you downloading from AL11. If so, dont use tcode "CG3Y". Becuase CG3Y has length constrain of 255 i guess. So, if you wish to download the data from AL11, create a new report program and read the dataset and download to local file.Let us know if this works.Thanks,Gourab

Re: Sending internal table data to Application server using XML format

Sandra_Rossi — Tue, 29 Jun 2021 17:37:43 GMT

I see in your file that you have copied the file from the output of AL11. You must not do that (because of line breaks as explained by Gourab). You must create a program to download the file from the application server to user's laptop or anywhere else.

Re: Sending internal table data to Application server using XML format

former_member308418 — Wed, 30 Jun 2021 03:41:20 GMT

Dear Gourab,

I am not splitting the string into table. But the structure SWBHTMLINE has data type of 255 char length. Is there any other FM to do the same? Another thing is that, I am working with third party . I dont know how they are fatching data from server. But from their end they complained of the line breaking error. I can create a new report program for my clarity but it will be of no use for the other party software.

Re: Sending internal table data to Application server using XML format

Gourab_Dey — Wed, 30 Jun 2021 05:11:30 GMT

Hi Ferdaus,

The issue basically due to the line break. So, we will not use the function module "SWA_STRING_TO_TABLE", rather will transfer the XML string, which will ensure there will not be any line split.

DATA : itab TYPE swbhtmltable,
lv_xml_result TYPE string,
lv_file TYPE string.
"Start of comment by Gourab
*CALL FUNCTION 'SWA_STRING_TO_TABLE'
*EXPORTING
*character_string = lv_xml_result
*IMPORTING
*character_table = itab.
"End of comment by Gourab
OPEN DATASET lv_file FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.
"Start of comment by Gourab
*LOOP AT itab INTO DATA(wa).
*TRANSFER wa-linedata TO lv_file.
*ENDLOOP.
"End of comment by Gourab
"Start of addition by Gourab
TRANSFER lv_xml_result TO lv_file.
"End of addition by Gourab

CLOSE DATASET lv_file.

Alternately, the third party application which is reading the file can also remove the new line character before validation.

Thanks,

Gourab

Re: Sending internal table data to Application server using XML format

former_member308418 — Wed, 30 Jun 2021 09:16:42 GMT

Thanks Gourab. I have sent data as per this idea and found no error.

Best regards,

Ferdaus.