Previous Topic

Next Topic

Book Contents

Book Index

Remotely Extracting Data

connectDaily allows you to remotely extract data via HTTP. You can extract data in CSV, iCalendar, JSONP, and RSS format.

The URL to extract data from connectDaily is:

[/calendar path]/ [format] /[by method]/(object id | list).extension[?URLOption=value[&URLOption...=value]]

if the requested file name is "list.extension", then a list of items of (by method) will be returned. E.G. a list of calendars. Otherwise, a list of events matching (by_method)/(object id) are returned.

See Also: Filtering on Mulitple Options

[format] Values

Format Value

Description

csv

Comma-Separated Value - Recommended extension: .csv

jsonp

JSON - Recommended extension: .js

iCal

iCalendar / RFC-5545 - Recommended extension: .ics

rss

RSS 2.0/XML - Recommended extension: .xml

[by method] Values

By Method Value

Description

calendar_id

The ID of the calendar to extract events for. (object id) is the calendar ID.

cal_item_id

The cal_item_id of a specific event to retrieve data for.

item_type_id

The event type id to extract events for.

location_id

The id of the location to extract events for.

resource_id

Resource ID to extract events for.

resource_type_id

Resource Type ID to extract events for.

URL Parameters

Parameter Name

Formats

Description

allow_duplicates

jsonp
rss

The default behavior is to export each event only one time, no matter how many times the event occurs during the dayspan. If you want every occurrence of an event to be exported, add allow_duplicates=1 as an argument.

callback

jsonp

JSON only. Callback function to send data to. If you're using jQuery, the format for the callback function would be ?callback=?

CDSearchText

jsonp

Text to search for. You can pass this value to limit the returned events to those containing the specified text. Normal connectDaily search logic applies.

chkIncludeText

csv

If 1, include the long description. If 0, or not present, do not include the long description.

dayspan

csv
jsonp
rss

# of days to retrieve events for. If not specified, uses the Default # of Days to Export value from System | Configuration | Sync/Export Options. Using this parameter, you can increase or decrease the number of days that events are returned for.

RSS Notes

If this parameter is -1, then all one time or specific dates events in the candidate set (calendar, resource, etc) will be returned. This includes events that are in the past. Recurring events (other than specific dates) will not be included in the output set.

This parameter is ignored if newest is specified.

Regardless of how many times an event occurs during the specified period, the entry will only be returned one time. Refer to allow_duplicates.

htmldescription

iCal

Default 0. The default behavior for iCal export is to strip HTML from the long description of an event. If this parameter is present and set to 1, the iCal event will have the HTML formatted description returned.

include_past

iCal

The default behavior is to export future events, and those that happened within the last 30 days. If you want all events regardless of date, add "include_past=1" as a URL argument.

integral_days

jsonp

Default 1. Say you set maxcount=12 and the 13th event is on the same day as the 12th event. If integral_days=1 (the default), then all events that happen on the same day as the item specified by maxcount are included. To disable this, pass integral_days=0 as an argument.

maxcount

jsonp
rss

Maximum number of events to return. If not specified, uses the Default Max Events to Export value from System | Configuration | Sync/Export Options. The number of returned elements is also impacted by integral_days.

newest

rss

1 - If this value is specified, rather than returning the next dayspan days of events, the maxcount newest events will be returned. In other words, the maxcount most recently edited events will be returned.

nodefaultcontact

iCal

If this argument is present, and the value is 1, then the event owner will not be added to the iCal entry as the ORGANIZER/CONTACT.

noresourcesindesc

iCal

If this argument is present and the value is 1, then the resources used by the event will not be added as text to the event description.

offset

csv
jsonp
rss

Offset number of day to retrieve events for. For example, if you want tomorrow's events, you would pass offset=1&dayspan=0.

pubdate

rss

0 - The pubdate element of the item entry will be the last update of the event. The event start/stop date will be placed in the event description entry.

If you specify pubdate=0, then the description will include the event start times for one time events, or the recurrence description for recurring events.

1 - Default. The pubdate element of the Item entry will be the event date time.

reverse

jsonp
rss

If reverse=1, reverse the default order of the returned events. maxcount is applied before the reverse operation is performed.

rollup

all

0 - Don't roll up events from included calendars into this export.

1 - Default. Follow the option set at the calendar level for rollup.

show_resources

all

If show_resources=1 then resource names assigned to the event will be suffixed to the event title. If this value is not specified, the user level preference will be used. Regardless of this setting, resources are exported on the event as an array of resource objects.

start

csv
jsonp
rss

Start Date in yyyy-mm-dd, request locale, or Julian day number format.

startdate

enddate

csv
jsonp

Dates for start and end of exported data. This should be either in yyyy-mm-dd format, or the correct format for the request's first accept-language.

strip_html

csv

If 1, strip any HTML from the long description. Implies chkIncludeText=1.

user_id

etoken

all

The presence of the user_id and token parameters allow you to specify a URL to data that would not otherwise be visible. Users can invalidate their export token by going to any of the data export screens and selecting the icon to re-generate the access code.

Examples

Retrieve a list of calendar the user can view:

http://calendar.yourdomain.com/jsonp/calendar_id/list.js

Retrieve the next 7 days of events from a specific calendar.

http://calendar.yourdomain.com/jsonp/calendar_id/3.js?dayspan=7

Retrieve a maximum of 12 events for a specific resource and send it to a Javascript function named MyCallbackFunction:

http://calendar.yourdomain.com/jsonp/resource_id/3.js?callback=MyCallbackFunction&maxcount=12

See Also

Exporting Data

Comma Separated Value/CSV

Internet Calendar (iCal RFC-5545) Export

JSON Export

RSS Export

Filtering on Multiple Options