Technical Articles
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 👈
- User should have SAP Commission RestAPI Access (Refer : How to generate Token)
- 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 -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)
thanks for sharing the info.
Thanks Minjie Lao !! Keep sharing articles to your friends
Thanks for the info.
Thanks, Rakesh!! Keep sharing articles to your friends.
Excelent information, thanks for sharing. Do you know if it is posibble to generate the access token with a JWT authorization user?
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/
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).
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
Olivier Franco
I have provided now with other example from Visual Studio Code.. you can try it in different way.