ChurchSuite Connector

Growing Healthier Churches presents a Community Connector to enable Contact & Children data in ChurchSuite to be accessed from Looker Studio.

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

The data extracted from ChurchSuite  can then be displayed in Looker Studio and analysed to provide insights.

Setup

The connector requires user to select the Contacts + Children data set and authorize with API Credentials to access ChurchSuite 

API authorization

The connector will request the user to authorize access to the ChurchSuite data by entering API credentials. After setting up the API Authorisation credentials in ChurchSuite, the Client Identifier should be copied to the username field and the Client Secret should be copied into the token field to authorise the Connector.

Data Fields

The data from Contact and Children fields are returned from the API. These fields are defined here.

NameTypeNote
idstring
first_namestring
middle_namestring
last_namestring
formal_namestring
titlestring
date_of_birthdate
createddate
sexstring
activeboolean
former_namestring
marital_statusstring
spouse_id date_time
addressdate_time
emailstring
mobileboolean