WCONLINE | The Management Solution for Academic Centers

In Global System Settings (which you'll find under the "System Configuration" section of the Welcome menu), you can define a variety of system-wide settings and controls. Within the "Area Tools" menu, you'll find links to a variety of tools that also enable global changes throughout your WCONLINE site. The first tool, "API Configuration," allows you to automatically export WCONLINE data for use on an institutional website or within an institutional data warehouse.

API Access

API Configuration Modal WCONLINE includes built-in reports and an export, all of which work quickly and report up-to-the moment data whenever used. WCONLINE's API allows you to request and receive system data in JSON format without being logged into the system. This is mostly useful to IT departments that wish to import WCONLINE data regularly into another system, such as into a learning management or advising tool (where email address can be used as the key field to sync data between the systems). Your IT department can set up the API to make the following datasets available:

APPT: This is a list of appointment data for a given date. The following fields are returned for this API call: Client First Name, Last Name, and Email Address; Schedule Title; Staff or Resource Name; Appointment Date, Start Time, and End Time; Walk-In; No-Show; Placeholder; Online; and, Focus (if focus is required).
CRF: This is a list of client report form data for a given date. The following fields are returned for this API call: Client First Name, Last Name, and Email Address; Schedule Title; Staff or Resource Name; Appointment Date, Start Time, End Time, and Length (as recorded on the client report form); and, Off-Schedule (for off-schedule reports).
ORPHAN: This is a list of appointment data for a given date for appointments which do not have associated client report forms. The following fields are returned for this API call: Client First Name, Last Name, and Email Address; Schedule Title; Staff or Resource Name; Appointment Date, Start Time, and End Time; Walk-In; No-Show; Placeholder; Online; and, Focus (if focus is required).
AVAIL: This is a list of appointments currently available (to non-administrators) for a given date. The following fields are returned for this API call: Schedule Title; Appointment Date and Start Time; and, Staff or Resource.

As with all control panels, be sure to hover over the question mark icons next to each option for more information about each entry.

While the section contains extensive information, there are only two values to enter:

API KEY ($KEY): This is the case-sensitive, ten-or-more-character string that is shared by the institution and WCONLINE in order to independently construct the key (as above). We recommend using a long and random value (which should be treated and secured like a password).

IP ADDRESS ($IP): This is the public IP address of the computer which will be requesting data from WCONLINE's API. Requests that originate from a different IP (or that are not crafted properly) will be ignored.

Once configured, data is pulled by sending a request to this specific URL:

https://[xxxx].mywconline.[yyy]/api.php?type=[TYPE]&date=[DATE]&key=[KEY]

Note that "[xxxx]" and "[yyy]" above are not tokens. These simply mean the unique parts of your WCONLINE URL, including your school domain or name or similar, and "com" or "net." For example, for our demo, the entire value to be included would be "demo.mywconline.com" (without quotes).

The tokens in the URL are:

[TYPE]:The dataset being requested (as listed above).
[DATE]: The date of the dataset being requested in the format YYYYMMDD.
[KEY]:A time based, encrypted key that authenticates the request. While any language can be used, in PHP, the key is constructed as:
md5($KEY.''.date('mdY').'?'.date('H').'!'.$IP)
using $KEY and $IP the variables entered below. Note that WCONLINE's time is static and does not observe daylight savings. Therefore, adjust your programming to ensure that WCONLINE's current time as displayed in this control panel.

Accessing, using, and displaying data from APIs require advanced knowledge of web programming and the JSON programming language. Most likely, this data will be pulled from WCONLINE and made available for use by an institutional IT department. Additionally, questions about pulling and using the data accessed through the API would need to be directed to the institution's IT department, as we do not have access to the tools and systems available to work with data pulled from WCONLINE. Note that you are responsible for the use and security of the data once it is accessed and pulled from WCONLINE. Also note that the API system will only allow sixty or less queries per hour. Subsequent queries (and errors) will be ignored and will result in the return of no data.