Get Schedules
To configure the URL, use the below items together
Method | Base URL | End Point |
GET | https://api.viewcentral.com | /api/dataexchange/schedules |
Headers
- Username=(Enter your username)
- Password = (Enter your password)
- CompanyLoginId=(enter your LTO company login id)
- ProductId=1
Parameters
- scheduleId
- scheduleStatus
- startDate YYYY/MM/DD
- endDate
- applicationId
- attendeeGroup
- Category
- locationGroup
- country
- productId
- languageCategory
- courseName
- courseType
- locationName
- scheduleCustomText
Sample Request
https://api.viewcentral.com/api/dataexchange/schedules?scheduleId=&scheduleStatus=&startDate=2016-05-01&endDate=&applicationId=&attendeeGroup=&Category=&locationGroup=&country=&productId=&languageCategory=&courseName=&courseType=&locationName&scheduleCustomText=
Sample Response
DB Field Name (API) | UI/Export Field Name | Data Type | Length | Description |
event_schedule_id | Schedule ID | INT | 4 | The schedule ID is the id number of the schedule record. This id is system generated unique when a schedule record is created. |
schedule_name | Schedule name | Varchar | 255 | Schedule name |
event_id | Course id | int | 4 | System generated course record ID |
start_date | Schedule start date | datetime | 8 | On this date course is scheduled to start |
end_date | Schedule end date | datetime | 8 | On this date course is scheduled to end |
start_time | Schedule start time | datetime | 8 | On this time course is scheduled to start |
end_time | Schedule end time | datetime | 8 | On this time course is scheduled to end |
custom_text_1 | Custom Text 1 | VARCHAR | 200 | Custom Text 1 is a user defined text that can be used for any additional schedule profile information needed. |
custom_text_2 | Custom Text 2 | VARCHAR | 200 | Custom Text 2 is a user defined text that can be used for any additional schedule profile information needed. |
custom_text_3 | Custom Text 3 | VARCHAR | 200 | Custom Text 3 is a user defined text that can be used for any additional schedule profile information needed. |
custom_text_4 | Custom Text 4 | VARCHAR | 200 | Custom Text 4 is a user defined text that can be used for any additional schedule profile information needed. |
custom_text_5 | Custom Text 5 | VARCHAR | 200 | Custom Text 5 is a user defined text that can be used for any additional schedule profile information needed. |
custom_text_6 | Custom Text 6 | VARCHAR | 200 | Custom Text 6 is a user defined text that can be used for any additional schedule profile information needed. |
timezone | Schedule Time zone | VARCHAR | 72 | In this time zone schedule date/time is set |
schedule_status | Schedule status | VARCHAR | 50 | Schedule status = Avialable, Cancelled, Full , Done, INACTIVE |
max_seats | ||||
min_seats | ||||
cancel_date | Cancel date | datetime | 8 | Schedule cancel date |
number_of_attendees | Number of Attendee | Int | 4 | No of attendee scheduled |
event_type | Course Type | VARCHAR | 50 | For which course type schedule is set , e,g – for seminars or reporting |
event_address_id | Location Id | int | 4 | Location id is number of the location record. This id is system generated unique when a location record is created. |
sublocation_id | Sub location Id | int | 4 | Sub Location id is number of the location record. This id is system generated unique when a sub location record is created. |
language_cat | Language category | VARCHAR | 50 | Language selected from pre saved drop down value( defined under definition->pull down values->language category) |
summary_description | Summary description | text | 16 | Schedule description |
duration_value | Duration value | Numeric | 9 | For how long Schedule duration is |
duration_type | Duration type | VARCHAR | 50 | Duration type : hours / Days |
training_hours | Training hours | Numeric | 9 | Schedule training hours |
approval_status | Approval status | VARCHAR | 50 | Schedule approval status : Approved, Pending approval. |
registration_total | Registration Total | int | 4 | Number of registrations for this schedule |
registration_total_attended | Number of Attended attendees | int | 4 | Number of attendees attended the course |
maximum_seats | Maximum Seats | int | 4 | Maximum seats allowed |
minimum_seats | Minimum Seats | int | 4 | Minimum seats allowed |
seats_taken | Seats Taken | int | 4 | Seats used/registered for this schedule |
schedule_name1 | Schedule Name | Varchar | 255 | Schedule name |
event_name | Course Name | VARCHAR | 255 | Course Name is the name of the course used to identify the course in the admin and attendee views. Course names are unique in the system. |
summary_description3 | Summary Description | VARCHAR | 2048 | Content in the course Summary Description field |
description | Full Description | VARCHAR | 2048 | Content in the course full Description field |
product_id | Product ID | VARCHAR | 50 | The Product ID field is used to stor and display a user created Product ID number on the record. The product id can be used as your id for the course record. |
event_url | Course name URL | VARCHAR | 255 | URL from Course Image url field |
event_url2 | Course Image URL | VARCHAR | 255 | URL from Course Image url field |
event_url3 | Course Image URL | VARCHAR | 255 | URL from Course Image url field |
duration_value4 | Duration value | Numeric | 9 | For how long Schedule duration is |
duration_type5 | Duration type | VARCHAR | 50 | Duration type : hours / Days |
event_detail_1 | Custom Course Detail 1 | VARCHAR | 2048 | Custom Course Detail 1 is an open text field on the course record to be used as needed. |
event_detail_2 | Custom Course Detail 2 | VARCHAR | 2048 | Custom Course Detail 2 is an open text field on the course record to be used as needed. |
event_detail_3 | Custom Course Detail 3 | VARCHAR | 2048 | Custom Course Detail 3 is an open text field on the course record to be used as needed. |
event_detail_4 | Custom Course Detail 4 | VARCHAR | 2048 | Custom Course Detail 4 is an open text field on the course record to be used as needed. |
event_detail_5 | Custom Course Detail 5 | VARCHAR | 2048 | Custom Course Detail 5 is an open text field on the course record to be used as needed. |
event_detail_6 | Custom Course Detail 6 | VARCHAR | 2048 | Custom Course Detail 6 is an open text field on the course record to be used as needed. |
Categories | Course Category | VARCHAR | 255 | Course categories |
event_address_id | Location Id | int | 4 | Location id is number of the location record. This id is system generated unique when a location record is created. |
location_name | Location Name | VARCHAR | 250 | Location name |
street1 | Street1 | VARCHAR | 50 | Location address- street1 |
street2 | Street2 | VARCHAR | 50 | Location address- street2 |
city | City | VARCHAR | 100 | Location address – City |
state_province | State | VARCHAR | 100 | Location address – State |
other_state | Other state | VARCHAR | 100 | Location address – Other State |
country | Country | VARCHAR | 100 | Location address – Country |
country_code | Country Code | VARCHAR | 10 | Location Country code |
postal_code | Postal Code | VARCHAR | 20 | Location address – postal code |
phone | phone number | VARCHAR | 50 | Location phone number |
fax | Fax number | VARCHAR | 50 | Location Fax number |
location_group | Location Group | VARCHAR | 255 | Location group name |
sublocation_id | Sub Location Id | int | 4 | Sub Location id is number of the location record. This id is system generated unique when a location record is created. |
sublocation_name | Sub Location Name | VARCHAR | 250 | Sub Location name |
event_address_id | Location Id | int | 4 | Location id is number of the location record. This id is system generated unique when a location record is created. |
id | Instructor Id | int | 4 | Instructor id is number of the location record. This id is system generated unique when a instructor record is created. |
first_name | Instructor First name | VARCHAR | 100 | Instructor First name |
middle_name | Instructor Middle name | VARCHAR | 100 | Instructor Middle name |
last_name | Instructor Last Name | VARCHAR | 100 | Instructor last name |
Instructor Email | VARCHAR | 100 | Instructor email id |