How do I use the CRD API?

The CRD API is used for collaboration and other system functions. CRD API allows you to run schedules as well as control the scheduling services. Here is how to install and configure it if needed.

Options - CRD API

CRD's API allows you to run schedules as well as control the scheduling services. You can use any programming language of your choice to query the API.

The CRD API is a RESTful API based on HTTP requests and JSON responses. The easiest way to start using the CRD API is by using Postman, a free tool which helps developers run and debug API requests, and is the source of truth for this documentation. 

How to Install the CRD API?

• Go to Options.

• Go to REST API.

• The API Settings section is used for collaboration and other system functions.
• Click Install API.

• Enter your windows credentials to install the API.
• Click OK.

• Click Yes.

• Click OK.

• The CRD API is installed.
• Click Start to start the CRD API Service.

• The CRD API is configured and CRD API Service is running.

API Clients

• The API Clients section is used to give another application access to the CRD API.
• Click Add.
• You only need to provide the Client name as the Client ID and Secret are automatically generated by CRD.
• Once the Client name is added, click Save & Close.

How do I use the CRD API?

Getting Started

CRD's API allows you to run schedules as well as control the scheduling services. You can use any programming language of your choice to query the API.

The CRD API is a RESTful API based on HTTP requests and JSON responses. The easiest way to start using the CRD API is by using Postman, a free tool which helps developers run and debug API requests, and is the source of truth for this documentation. 

 You can also create multiple SSRS single schedules using the API so that a JSON file can be picked with their definitions.

Authentication and Authorization

The CRD API can use OAuth2 Client Credentials or Username and Password authentication and authorization flow. All API endpoints except the /api/service/ping require a valid access token for authorization.

Get Token

Username and Password Flow

To request an access token using the credentials of a CRD user, make a POST request as follows:

http://[crdserver]:9000/login/token

POST http://[crdserver]:9000/login/token

POST Body

string username
string password

Example Result

{
    "UserId": "jd",
    "FirstName": "John",
    "LastName": "Doe",
    "role": "Administrator",
    "ExpiryDateEpoch": 1617803400,
    "token": "VEw+8f/9N1D8ZiJOmOses38Wad0RD/NU9jUDIVVK8CeUcmIjErSZDn965NVmSlEZJd3gfRbkUajd5dCNm87c295S1TO4RKbeJUho6t6XEJUdiJSs1T4WY2xEaR75RqufM3Xi3u55Pp3AsQX0jmN0wcOe/26k1y3feM8hZmnjffbDYZT7azIpiebLBPaXhY6dAA==",
    "token_type": "custom"
}

Client Credentials Flow

In order to obtain an access token, you must first add the Client application to CRD. This is done under the Configuration/CRD API screen.

You only need to provide the Client name as the Client ID and Secret are automatically generated by CRD.

To request an access token, make a POST request as follows:

http://[crdserver]:9000/oauth2/token

POST http://[crdserver]:9000/oauth2/token

POST Body

string grant_type: client_credentials
string client_id
string client_secret

Result

{
string access_token
string token_type: bearer
int expires_in
}

Below is an example of what a successful authentication result looks like:

{
    
  "access_token": "AQAAANCMnd8BFdERjHoAwE_...",
    
  "token_type": "bearer",
    
  "expires_in": 86399
}

Once the access token has been obtained, it must be included as part of your API request headers.

For the username and password flow, the request header must include:

Authorization: token {access_token}

For client credentials flow include:

Authorization: bearer {access_token}

EndPoints

The API is accessed by making HTTP requests to a specific URL endpoint, in which GET or POST variables contain information about what you wish to access. Every endpoint is accessed via the port and protocol configured in CRD. The CRD API Service must also be running on the CRD server.

The default starting endpoint for the API is:

http://[crdserver]:9000/api

Service EndPoint

The Service Endpoint allows you to query and control the CRD services.

Ping

To check if the API is up and running, you can use Ping. The call will return 1 when the API is running.

GET /api/service/ping

Result:

int i

IsSchedulerRunning

To check if the CRD scheduler is running:

GET /api/service/isschedulerrunning

Result:

{
bool Result
}

StartScheduler 

GET /api/service/startscheduler

Ok 200

StopScheduler

GET /api/service/stopscheduler

Ok 200

GetConfigPath

To get the path to the CRD config file:

GET /api/service/getconfigpath

Result:

{
string Result
}

Schedule Endpoint

The Schedule endpoint allows you to control CRD schedules. Where a schedule type must be specified, the following are valid:

•  "report" or “single”: all Single and Data-Driven Schedules               

• "automation": all Automation schedules

• "package": all Single and Data-Driven Package schedules

• "event": all Event-Based schedules

• “event-package" or “eventpackage”: all Event-Based Package schedules

The schedule’s unique Id can be obtained from the schedule’s properties screen in the application GUI.

ExecuteSchedule

Synchronously kicks off a schedule and waits for its completion.

POST api/schedule/executeschedule

POST Body

string ScheduleType
int UniqueId
string RunBy

Result

{
bool Result
string ErrorMessage
int ErrorNumber
}

ExecuteScheduleOnTimeAsync

Asynchronously kicks off the schedule as if it is being run by the scheduler. At completion, the schedule’s NextRun date will be incremented.

POST api/schedule/executescheduleontimeasync

POST Body

string ScheduleType
int UniqueId
string RunBy

Result

{
string ExecutionId
}

ExecuteScheduleAsync

Asynchronously kicks off a schedule and does not wait for its completion. The resulting ExecutionId can be used to query the execution status

POST api/schedule/executescheduleasync

POST Body

string ScheduleType
int UniqueId
string RunBy

Result

{
string ExecutionId

SingleSchedule Endpoint

The SingleSchedule endpoint allows you to carry out CRUD operations related to CRD single schedules.

Create

This is to create single schedules.

POST api/schedule/CreateSingleReport

Dependent Models

RenderingSettingsModel

BasicFilterModel

This model inherits from the FilterBaseModel.

AdvancedFilterModel

This model inherits from the FilterBaseModel.

TimeScheduleBaseModel

DataDriverModel