Upload/download File in SAP UI5 Application using Gateway

As I was working with functionality for upload and download by following the blog but facing  issues in downloading.I applied a different approach in this blog.Please find below step by step how you can upload and download file.

please note that i am implementing this on Central Hub Gateway  Deployment so will be explaining this in two sections

Section I: Back End

Step-1 : Create Table

First I created a table on back-end system that will contain the uploaded files.you can add many fields you want but  your table must contain Filename,Value and mimetype.

after creating table we developed three Function Modules.

Step-2: Function Modules

Please note all functions are RFC Enabled.

1. Upload

In this function you will import following parameters and store values in table.

DATA: TEMP_WO LIKE ZBM_WORKORDERAPP-WORKORDER.
  DATA: WA_UPLOAD TYPE ZBM_FILEUPLOAD.

*  SELECT SINGLE WORKORDER INTO TEMP_WO FROM ZBM_WORKORDERAPP
*    WHERE WORKORDER EQ IM_WORKORDER.
*
*  CHECK TEMP_WO IS NOT INITIAL.

  WA_UPLOAD-MANDT = SY-MANDT.
  WA_UPLOAD-WORKORDER = IM_WORKORDER.
  WA_UPLOAD-FILENAME = IM_FILENAME.
  WA_UPLOAD-VALUE = IM_MEDIA_RESOURCE.
  WA_UPLOAD-MIMETYPE = IM_MIME_TYPE.
  WA_UPLOAD-DATESTAMP = SY-DATUM.
  WA_UPLOAD-TIME = SY-UZEIT.

  INSERT INTO ZBM_FILEUPLOAD VALUES WA_UPLOAD.
  IF SY-SUBRC <> 0.
    RAISE DATA_NOT_INSERTED.
  ENDIF.

ENDFUNCTION.

please note this function module is for Create Odata service implementation

2. Get List of files

In my case user can add multiple files for specific workorder. To implement this functionality i created  function module which returns table with file name and file type.

please note this function module is for GetEntitySet Odata service implementation

3. Download

In this function i pass two parameters and get related file.

please note this function module is for GetEntity Odata service implementation

Section II: Front-End SAP Gateway

Step-1: Service Creation

I have created a project in SEGW and an entity type based upload function

following properties were created.

Step-2 : Service Implementation

we will  use mapping

we have implement following services

For Create we used upload function,

for Get Entity we used download

and for Get Entity Set we used Get file names function

thats it !

lets generate.

So we have implemented odata service successfully.

Section III: WebIDE

In this section we will see we can use above service in UI5 application

In this Ist we will upload the file to back end system,and the we will download file using UI5 application.

Step-1: Upload file using file uploader.

I will be using file uploader component.

On upload i have implemented  postFiletobackend

we have used JavaScript function btoa for encoding the file content

question arise from where filename,filetype and content come from.below is the code how get details from uploader.

onUpload: function (oEvent) {
var oFileUpload = this.getView().byId("fileUploader");
var domRef = oFileUpload.getFocusDomRef();
var file = domRef.files[0];
var that = this;
this.fileName = file.name;
this.fileType = file.type;
var reader = new FileReader();
reader.onload = function (e) {var vContent = e.currentTarget.result.replace("data:" + file.type + ";base64,", "");
that.postFileToBackend(workorderId, that.fileName, that.fileType, vContent);
};
reader.readAsDataURL(file);
}

once the file uploaded you will get success message

Step-2: Download file

I didn’t use upload collection.Instead of that i have just list down the file related to workorder using list object.

and by using get entity set we will get following view.

Now i have implemented download function on click of row.

I have tried to use sap.ui.core.util.File.save() function but only getting blank or corrupt file.only text file was working fine.

To achieve the goal i have used native JavaScript functionality by creating blob from the file “Value”  and open the blob by using url

Thats it.  Feel free to ask question