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.
The connector requires user to select the Contacts + Children data set and authorize with API Credentials to access ChurchSuite
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.
The data from Contact and Children fields are returned from the API. These fields are defined here.
Name | Type | Note |
---|---|---|
id | string | |
| string | |
middle_name | string | |
last_name | string | |
formal_name | string | |
title | string | |
date_of_birth | date | |
created | date | |
sex | string | |
active | boolean | |
former_name | string | |
marital_status | string | |
spouse_id | date_time | |
address | date_time | |
email | string | |
| boolean |