Previous Topic

Next Topic

Book Contents

Book Index

Filtering on Multiple Options

iCal, RSS, and JSON Export allow multiple filters for export of data.

The general format of these exports is:

/export_type/by_method/by_id.xxx?option1=&optionN=...

Where export_type is either iCal, RSS, or jsonp, by_method is calendar_id, item_type_id, resource_type_id, or resource_id. by_id is the id of the object. E.G. the calendar ID. For example, the JSONP export looks like:


/jsonp/calendar_id/3.js?dayspan=7

This would export all events on the calendar with the id of 3 for the next 7 days.

Beginning with version 3.4.15, you can now specify additional filters on the url. Say the ID for the resource "Pepsi Center" is 7, you can now filter for events on that calendar at the Pepsi Center. The format of the URL would be:

/jsonp/calendar_id/3.js?dayspan=7&resource_id=7

You can specify more than one value, and more than one filter. For example, say I have a "Theater" calendar, and two of the venue resources are "Dinner Theaters". I could use the filter like this:

/jsonp/calendar_id/3.js?dayspan=7&resource_id=5,19

To retrieve only those events that are at one of those two venues. I could further refine it to only extract musicals by adding the item_type_id option:

/jsonp/calendar_id/3.js?dayspan=7&resource_id=5,19&item_type_id=11

You can also create exclusionary filters. For example:

/jsonp/calendar_id/3.js?item_type_id=-11

will return events from calendar id=3, except those of item type 11. The negation (minus) sign indicates that it's an exclusionary or negative filter value.

For inclusionary value filters, each additional filter (resource_id and item_type_id in the example) must be matched by at least one value. For exclusionary (negative) filters, any matched value will be excluded. The additional filter options that can be applied are:

See Also: Remotely Extracting Data

See Also

Exporting Data

Comma Separated Value/CSV

Internet Calendar (iCal RFC-5545) Export

JSON Export

RSS Export

Remotely Extracting Data