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)

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

curl -X POST "https://<tenantid>.callidusondemand.com/CallidusPortal/services/v2/Tokenization/access_token" -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)