Skip to Content
Product Information
Author's profile photo Saksham Jain

A Comprehensive Guide to Downloading Files in SAP Build Process Automation


SAP Process Automation (SAP PA) is a powerful tool that allows organizations to automate their business processes, increase efficiency, and reduce manual effort. One common task in SAP PA is downloading files from the SAP system or the Web. While seemingly straightforward, there are certain best practices and considerations to keep in mind to ensure a smooth and effective file download process. In this blog, we will explore the right way to download a file in SAP Process Automation.

The file that we will be downloading is saved within the SAP BTP Document Management Service.

How to Download a File


Step 1: Create a variable to hold the name of the folder where your file resides in DMS, Leave it empty if the file is in the root folder.

Step 2: Create a variable to hold the name of the file you want to download.

Step 3: Create a variable to hold the ClientID.

Step 4: Create a variable to hold the ClientSecret

Step 5: Use the Encode String Activity to encode the ClientID and ClientSecret in base64 format.

Step 6: To access the DMS (Document Management Service) system and download the file, it is necessary to acquire authorization. In this stage, we will utilize the Customer Script Activity to set up configurations for calling the Auth Service, enabling us to obtain the necessary authorization.

var authRequestOptions = {
    method: 'GET',
    responseType: 'json',
    headers: {
        'Accept': 'application/json',
        'Authorization': 'Basic '+ base64EncodedUsernamePassword,
        'Content-Type': 'application/json'
    'resolveBodyOnly': true

return authRequestOptions;

Step 7: Now we’ll call the Auth Service using the Call Web Service with Destination Activity which will provide us with an authentication token.

Step 8: In this step, we’ll again use Customer Script Activity to set up configurations to Download the File.

var requestParams = {
    url: folderName ? folderName + '/' + uploadedFileName : uploadedFileName,
    method: 'GET',
    headers: {
        'Authorization': 'Bearer ' +authToken,
    resolveBodyOnly: true,
    responseType: 'buffer'

return requestParams;

Step 9: Finally, we will employ the Download File Activity to carry out the actual downloading of the file from the DMS (Document Management Service). Subsequently, we will save the downloaded file in our system.


Downloading files using SAP Process Automation (SPA) can be a straightforward and efficient process if you follow the right steps. By understanding the download requirements, utilizing the appropriate SPA activities, and ensuring proper authentication and authorization, you can achieve successful file downloads with ease.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Rui Jin
      Rui Jin

      HI Jain,


      Could you please let me know what happens under the hood when setting "responseType"? I'm trying to replicate exactly same work in SAP CAP. I would like SDM return me a buffer like what automation did. Does "responseType" help the request setting some headers? or basically what happened when we ask it to return us a buffer.