Extracting data of all courses present in SAP LMS via API

[RushabhDedhia]

Hi All,

Can anyone help me on how to extract data of all courses present in SAP LMS via API.

I am trying to build a reporting solution outside SAP LMS and hence need to extract data by making API calls.

I need to build a Course dimension table which shall hold details of all courses presnent in LMS along with additional details of each course.

Appreciate your help!

Regards,

Rushabh

[CharlesGirdwood]

Hi Rushabh,

In my experience, using API calls to extract data is not feasible when you have a large amount of data.

We are currently using reports to export CSV files to be read and populate an internal (in company) database. From there, we create views to meet the needs of our internal clients (mainly PowerBI data flows).

This is far from satisfactory, because data extract through reports is also prone to many sort of errors. Therefore, we are looking for a more dependable solution.

Regards,

Charles

[RushabhDedhia]

Thanks Charles for the response!

The solution which you mentioned is what we currently have ( bit compliacted and heavly involves csv files extracted daily hence gives duplication issue as well) on which we are trying to build a warehouse kind of layer to extract data from LMS APIs.

From Learning History and Learning Plan, we are able to get all the factual data about completed and assigened courses for all employees.

I see few API are under Admin area, which probably have dimensional information like all Items, Cirrucula, categories etc on which from LMS I can pull a csv extract too, just wondering how to extract the same via API.

Appreciate your response!

Regards,

Rushabh D