My GHC

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 :

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.

NameTypeNote
idprimary_key
given_namestring
first_namestring
nicknamestring
middle_namestring
last_namestring
birthdatedate
anniversarydate
genderstring
gradeinteger
childboolean
graduation_yearinteger
site_administratorboolean
accounting_administratorboolean
people_permissionsstring
membershipstring
inactivated_atdate_timeSet to an ISO 8601 date or time to make the profile inactive. Set to "null" to reactivate the profile.
statusstringSet 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_notesstring
created_atdate_time
updated_atdate_time
avatarstringFile UUID (see File Uploads section)
namestring
demographic_avatar_urlstring
directory_statusstring
remote_idinteger
search_namestringSearch by Name (first, last, combination)
search_name_or_emailstringSearch by Name (first, last, combination) or Email
search_name_or_email_or_phone_numberstringSearch by Name (first, last, combination), Email, or Phone Number
passed_background_checkboolean
school_typestring

Access member content by logging in here.

or create your account here

Growing Healthier Churches Logo