Javascript in Google sheets for importing Json using REST Api from a public catalogue

Job ID: 35447792

Budget: €8 – €30 EUR

The API is secured by OAuth, to gain access to the API the customer receives a ClientId and a ClientSecret

A JWT token can be obtained via https://www.importr.be/importrapi/OAuth/v1/token.
This token should be used in the Authorization header with a Bearer schema.
e.g. "Bearer Ad2ze10..."

API ExportingCourse
Only 2 endpoints are available:
* all : This endpoint returns an ExportingCourseExportingEntityResult object.
In this way, all training information in the ecosystem, uploaded by the providers, is made available.
At the moment there is no filter or sorting available, only paging can be applied so that the data can be retrieved in a fragmented way.
skip=0
take=50


* count : This endpoint indicates the number of courses.

The only goal is to have a Google Sheet with a script so i can periodically import the JSON data
Related categories: JavaScript Google Spreadsheets