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 |