Growing Healthier Churches presents a Connector to enable People data in elvanto to be accessed from Looker Studio.
This connector fetches data from elvanto via the API. The following API endpoint can be used :
The data extracted from elvanto can then be displayed in Looker Studio and analysed to provide insights.
The connector requires the user to select the People data set and authorize with an API Key to access elvanto.
The connector will request an API key from the user to authorize access to the elvanto data.
You can obtain your API key from the Settings page of your elvanto account.
The data from all standard and custom People fields are returned from the API. These fields are defined here.
| Name | Type | Description | Returned Values |
|---|---|---|---|
| id | string | The ID of the person. | |
| date_added | datetime | The date the person was added. | Date is returned in UTC time. |
| date_modified | datetime | The date the person was last modified. | Date is returned in UTC time. |
| category_id | string | The ID of the category this person is in. | |
| firstname | string | The first name of the person. | |
| preferred_name | string | The preferred name of the person. | |
| middle_name | string | The middle name of the person. | |
| lastname | string | The last name of the person. | |
| string | The email address of the person. | ||
| phone | string | The phone number for the person. | |
| mobile | string | The mobile number for the person. | |
| admin | integer | Whether this person is a Super Admin. | 1 if the person is a Super Admin. |
| archived | integer | Whether this person is archived. | 1 if the person is archived. |
| contact | integer | Whether this person is marked as a contact. | 1 if the person is marked as a contact. |
| volunteer | integer | Whether this person is a volunteer. | 1 if the person is a volunteer. |
| status | string | The status of the person's account. | |
| username | string | The username of the person's account. | |
| last_login | datetime | The date the person last logged into their account. | Date is returned in UTC time. |
| country | string | The country of the person. | |
| timezone | string | The time zone of the person. | |
| picture | string | The URL for the persons profile photo | |
| family_id | integer | The unique identifier for this members family, used to link members together | |
| family_relationship | string | The position the user holds within their family |
| Name | Type | Description | Accepted Values |
|---|---|---|---|
| gender | string | The gender of the person. | Male or Female |
| birthday | date | The date the person was born. | 2019-09-20 (yyyy-mm-dd) |
| anniversary | date | The person's anniversary date. | 2019-09-20 (yyyy-mm-dd) |
| school_grade | string | The name of the school grade. | |
| marital_status | string | The person's marital status. | Single, Engaged, Married, Widowed, Divorced, Separated or Defacto |
| development_child | string | Is this a development child? | Yes or No |
| special_needs_child | string | Is this a special needs child? | Yes or No |
| security_code | string | Security code for check-in. | |
| receipt_name | string | The receipt name used for financial records. | |
| giving_number | string | The giving number used for financial records. | |
| mailing_address | string | The person's mailing address. | |
| mailing_address2 | string | Line 2 of the person's mailing address. | |
| mailing_city | string | The person's mailing city. | |
| mailing_state | string | The person's mailing state. | |
| mailing_postcode | string | The person's mailing postal or zip code. | |
| mailing_country | string | The person's mailing country. | |
| home_address | string | The person's home address. | |
| home_address2 | string | Line 2 of the person's home address. | |
| home_city | string | The person's home city. | |
| home_state | string | The person's home state. | |
| home_postcode | string | The person's home postal or zip code. | |
| home_country | string | The person's home country. | |
| access_permissions | string|array | The access permissions this person is assigned to. | More details |
| access_permissions_replace | string|array | Replace current access permissions with new access permissions. | More details |
| access_permissions_remove | string|array | Remove access permissions from person. | More details |
| departments | string|array | The departments this person is assigned to. | More details |
| departments_replace | string|array | Replace current departments with new departments. | More details |
| departments_remove | string|array | Remove departments from person. | More details |
| service_types | string|array | The service types this person is assigned to. | More details |
| service_types_replace | string|array | Replace current service types with new service types. | More details |
| service_types_remove | string|array | Remove service types from person. | More details |
| demographics | string|array | The demographics this person is assigned to. | More details |
| demographics_replace | string|array | Replace current demographics with new demographics. | More details |
| demographics_remove | string|array | Remove demographics from person. | More details |
| locations | string|array | The locations this person is assigned to. | More details |
| locations_replace | string|array | Replace current locations with new locations. | More details |
| locations_remove | string|array | Remove locations from person. | More details |
| family | array | Can only be used when retrieving a person. It will return the person's family members. | |
| reports_to | string | The name of who the person reports to. | |
| custom_ID | string|array | Replace ID with the Custom Field ID to retrieve or update it. You can obtain the ID's of your custom fields by performing a people/customFields/getAll call. | This field must be an array if you are updating a Custom Field that is a Drop Down or Checkbox. All other fields need to be a string. |