cancel
Showing results for 
Search instead for 
Did you mean: 

Upload xlsx (multi worksheet) to RAP

alikhach
Explorer
1,408

I have a requirement to get *.xlsx file from UI, validate data in it and save to DB table using ABAP RESTful Application Programming Model.

As i understand, I should implement it like this:

1. Create an entity with one field (XSTRING, BLOB?)

2. Using unmanaged scenario create a new oData service based on this entity

3. Create an action.

4. In class read somehow xlsx file and save it to DB table.

But i have a lot of questions:

1. What kind of abap type it is better to use for entity creation. There are no XSTRING and BLOB.

2. Will be possible to read file content using EML or how to get data from oData service?

3. Is there any example how to work with files in RAP?

Best regards,

Alex

robson_soares
Participant
0 Kudos

Hi Alex,

Did you find a solution? I have the same requirement.

Thanks.

Robson

Accepted Solutions (0)

Answers (1)

Answers (1)

maheshpalavalli
Active Contributor
0 Kudos

Not a solution you are looking for, but I think it would be better ot use a separate service to add attachments for now since the support for media type is not yet available in rap

https://github.com/SAP-samples/abap-file-uploader

You can store the data in a temporary table(draft table) and pass that key value as attachmentKey in your RAP service header. This way you can query the data in your bo.

you can also create a odata service to do it, if you don't want to use the above file-uploader.

Or maybe check if you can use the attachment service (not sure how much u can reuse it for your requirement)

https://blogs.sap.com/2019/12/16/attachment-service-to-your-rescue-in-s4hana-fiori-elements-using-re...

regards,.

Mahesh