Meeting attendance

Usage tips of Web Application Programming Interface (API)

Note:
When Chinese characters are used in a web api command, please perform URL encoding for it first, or use a browser such as Chrome that can encode Chinese characters automatically.

The web api provides the following information:

1. TAttendance (Records of attendance)

Corresponding to the above information, the open data web api can be run at:

https://app.legco.gov.hk/OpenData/AttendanceDB/TAttendance (JSON format)
https://app.legco.gov.hk/OpenData/AttendanceDB/TAttendance?$format=xml (XML format)

To get the meta data schema of the dataset, please run the following:

https://app.legco.gov.hk/OpenData/AttendanceDB/$metadata

The following query string options can be applied:

• $format - specify whether the data to be returned in json or xml format, e.g. $format=json
• $top=N - select only the first N entries of the set, where N is a positive integer, e.g. $top=10
• $skip=N - select only the remaining entries (starting with Entry N+1) where N is a positive integer, e.g. $skip=10
• $orderby - what values are used to order the retrieved data, e.g. $orderby=meeting_start_date_time
• $select - select specific fields to be returned, e.g. $select=meeting_start_date_time,meeting_name_english,member_name_english,present_absent
• $filter - select specific entries according to provided conditions, e.g. $filter=substringof('Meeting of House Committee',meeting_name_english) eq true
• $inlinecount - specify "$inlinecount=allpages" to include the total number of records in the returned data
• $expand - link up data

For available operators and functions to be used with $filter option, please refer to the documentation of the Open Data Protocol.

Examples

The following examples illustrate some of the ways to retrieve data according to the Open Data Protocol.

• To select the 301st to 320th attendance records (by default in JSON format):
  https://app.legco.gov.hk/OpenData/AttendanceDB/TAttendance?$skip=300&$top=20
• To select the meeting date/time, English meeting name, and English Member name, attendance in XML format from the first 20 attendance records of the meetings of the Panel on Manpower ordered by the meeting date/time:
  https://app.legco.gov.hk/OpenData/AttendanceDB/TAttendance?$top=20& $format=xml&$select=meeting_start_date_time,meeting_name_english, member_name_english,present_absent&$orderby=meeting_start_date_time&
  $filter=substringof('Panel on Manpower',meeting_name_english) eq true
• To select all attendance records of Hon Abraham SHEK Lai-him in January 2019 ordered by the English meeting name and the meeting start date/time in XML format, together with the total number of records that match the criteria:
  https://app.legco.gov.hk/OpenData/AttendanceDB/TAttendance?$format=xml&$inlinecount=allpages&$filter=substringof('Abraham SHEK',member_name_english) eq true and meeting_start_date_time ge datetime'2019-01-01' and meeting_start_date_time lt datetime'2019-02-01'&$orderby=meeting_name_english,meeting_start_date_time