Human Capital Management Blogs by SAP
Get insider info on HCM solutions for core HR and payroll, time and attendance, talent management, employee experience management, and more in this SAP blog.
Showing results for 
Search instead for 
Did you mean: 
Product and Topic Expert
Product and Topic Expert

Hi All

Over the past months, customers were interested on how to get file Job status  Success/failed/awaiting for the files been pushed to GoAnywhere Dropbox(sFTP)..

The Only way was through logging through SAP Commission Portal > Commission Data Loader > Job Status.

The purpose of this article is to demonstrate and explain how it works through API and Admin can automate further more without logging into Portal for the file status.

High-Level flow for CDL Job File Status

CDL API Documentation 👈


Prerequisite :

  1. User should have SAP Commission RestAPI Access (Refer : How to generate Token)
  2. User should have access to CDL[Commission Data Loader] (Applies only to HANA cust)

Step 1 : Get token from SAP Commissions tenant with your Basic Auth
2nd Step : Pass the token with your Basic Auth to get the Job details

-- Curl Command for Basic Auth token from SAP Commissions----

curl -X POST "https://<tenantid>" -H 'authorization: Basic cnJhanU6UnJhanVAMTIz' -H 'content-type: application/json' -d '{ "username": "<username>", "password": "<password>"}'

-- Curl Command for CDL OData API using above Auth token for the filename----

user should copy Access token from the above result and consume it CDL OData API (example below)

User should provide the filename which is sent for processing (example below)

curl -X GET https://<CDL URL>/cdl/odata.svc/getJob(fileName='0089_PIPELINE_DEV_October_2015A.txt') -H 'Content-Type: application/json' -H 'access-token: 2c277bc2-5792-482c-ad08-84d59f71f762' -H 'tenant: <tenantid>'

-- Sample Demo ---

Thank you for reading!. I feel much better. It's good to be liked. (Hit Like Button)