Skip to Content
Technical Articles
Author's profile photo Yogananda Muthaiah

Commission Data Loader[CDL] API’s


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>.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)

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Minjie Lao
      Minjie Lao

      thanks for sharing the info.

      Author's profile photo Yogananda Muthaiah
      Yogananda Muthaiah
      Blog Post Author

      Thanks Minjie Lao !! Keep sharing articles to your friends

      Author's profile photo Rakesh Rayineni
      Rakesh Rayineni

      Thanks for the info.

      Author's profile photo Yogananda Muthaiah
      Yogananda Muthaiah
      Blog Post Author

      Thanks, Rakesh!! Keep sharing articles to your friends.

      Author's profile photo Olivier Franco
      Olivier Franco

      Excelent information, thanks for sharing. Do you know if it is posibble to generate the access token with a JWT authorization user?

      Author's profile photo Yogananda Muthaiah
      Yogananda Muthaiah
      Blog Post Author

      Yes Olivier Franco Its possible. User Authentication needs to be JWT Authentication..

      Detailed blog is below

      https://blogs.sap.com/2021/03/26/sap-commissions-jwt-authentication/

      Author's profile photo Olivier Franco
      Olivier Franco

      Another excelent info Yogananda Muthaiah , thanks again.

      We could authenticate to api:  https://XXXX.callidusondemand.com/CallidusPortal/services/v2/Tokenization/access_token using a JWT user, but we still need to provide an username & password as body of the api call (This user is different to JWT user).

      {
          "username": "xxxxxx",
          "password": "xxxxxx"
      }

      Do you know with field names we need to include  in order to use the same JWT information as user for api call body (We can't provide a password for this user of course). If it is not possible, do you know how to use encrypted password in the api call body?

      Thanks again

      Regards

       

      Author's profile photo Yogananda Muthaiah
      Yogananda Muthaiah
      Blog Post Author

      Olivier Franco

      I have provided now with other example from Visual Studio Code.. you can try it in different way.