Planning Centre Connector for Data Studio

Growing Healthier Churches presents a Connector to enable People data in Planning Center to be accessed from Data Studio.

This connector fetches data from Planning Center via the API. The following API endpoint can be used :

• People

The data extracted from Planning Center can then be displayed in Data Studio and analysed to provide insights.

Setup

The connector requires user to select the People data set and authorize with OAUTH to access Planning Center.

OAUTH authorization

The connector will request the user to authorize access to the Planning Center data and specify what data is to be extracted.

Data Fields

The data from People fields are returned from the API. These fields are defined here.

Name	Type	Note
id	primary_key
given_name	string
first_name	string
nickname	string
middle_name	string
last_name	string
birthdate	date
anniversary	date
gender	string
grade	integer
child	boolean
graduation_year	integer
site_administrator	boolean
accounting_administrator	boolean
people_permissions	string
membership	string
inactivated_at	date_time	Set to an ISO 8601 date or time to make the profile inactive. Set to "null" to reactivate the profile.
status	string	Set to "inactive" to set "inactivated_at" to the current time and make the profile inactive. Set to anything else to clear "inactivated_at" and reactivate the profile.
medical_notes	string
created_at	date_time
updated_at	date_time
avatar	string	File UUID (see File Uploads section)
name	string
demographic_avatar_url	string
directory_status	string
remote_id	integer
search_name	string	Search by Name (first, last, combination)
search_name_or_email	string	Search by Name (first, last, combination) or Email
search_name_or_email_or_phone_number	string	Search by Name (first, last, combination), Email, or Phone Number
passed_background_check	boolean
school_type	string