> ## Documentation Index
> Fetch the complete documentation index at: https://docs.nekt.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Funraisin as a data source

> Bring data from Funraisin to Nekt.

Funraisin is an online fundraising platform that enables nonprofits and charities to create and manage fundraising campaigns, events, and peer-to-peer fundraising pages. It provides tools for donation management, participant tracking, team coordination, and event organization.

## Configuring Funraisin as a Source

In the [Sources](https://app.nekt.ai/sources) tab, click on the "Add source" button located on the top right of your screen. Then, select the Funraisin option from the list of connectors.

Click **Next** and you'll be prompted to add your access.

### 1. Add account access

You'll need to provide your Funraisin API credentials. To obtain an API key, create a user with "API Access" enabled in the User Admin section of your Funraisin dashboard.

The following configurations are available:

* **Domain**: Your Funraisin domain (e.g., `yourorg.funraisin.co`).

* **API Key**: The API key generated from your Funraisin admin panel for a user with API Access enabled.

* **Start Date**: (Optional) The earliest date from which records will be synced. Only applies to incremental streams (donations, sales, transactions).

Once you're done, click **Next**.

### 2. Select streams

Choose which data streams you want to sync. For faster extractions, select only the streams that are relevant to your analysis. You can select entire groups of streams or pick specific ones.

<Tip>The stream can be found more easily by typing its name.</Tip>

Select the streams and click **Next**.

### 3. Configure data streams

Customize how you want your data to appear in your catalog. Select the desired layer where the data will be placed, a folder to organize it inside the layer, a name for each table (which will effectively contain the fetched data) and the type of sync.

* **Layer**: choose between the existing layers on your catalog. This is where you will find your new extracted tables as the extraction runs successfully.
* **Folder**: a folder can be created inside the selected layer to group all tables being created from this new data source.
* **Table name**: we suggest a name, but feel free to customize it. You have the option to add a **prefix** to all tables at once and make this process faster!
* **Sync Type**: you can choose between INCREMENTAL and FULL\_TABLE.
  * Incremental: every time the extraction happens, we'll get only the new data, which is good if you want to keep every record ever fetched.
  * Full table: every time the extraction happens, we'll get the current state of the data, which is good if you don't want to have deleted data in your catalog.

Once you are done configuring, click **Next**.

### 4. Configure data source

Describe your data source for easy identification within your organization, not exceeding 140 characters.

To define your [Trigger](https://docs.nekt.com/runs/scheduling-and-triggers), consider how often you want data to be extracted from this source. This decision usually depends on how frequently you need the new table data updated (every day, once a week, or only at specific times).

Optionally, you can define some additional settings:

* Configure Delta Log Retention and determine for how long we should store old states of this table as it gets updated. Read more about this resource [here](https://docs.nekt.com/get-started/core-concepts/resource-control).
* Determine when to execute an **Additional [Full Sync](https://docs.nekt.com/get-started/core-concepts/types-of-sync#additional-full-sync)**. This will complement the incremental data extractions, ensuring that your data is completely synchronized with your source every once in a while.

Once you are ready, click **Next** to finalize the setup.

### 5. Check your new source

You can view your new source on the [Sources](https://app.nekt.ai/sources) page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.

<Warning>For you to be able to see it on your [Catalog](https://app.nekt.ai/catalog), you need at least one successful source run.</Warning>

# Streams and Fields

Below you'll find all available data streams from Funraisin and their corresponding fields:

<AccordionGroup>
  <Accordion title="Donations">
    | Field            | Type     | Description                            |
    | :--------------- | :------- | :------------------------------------- |
    | `donation_id`    | String   | Unique identifier for the donation     |
    | `member_id`      | String   | Identifier for the member              |
    | `event_id`       | String   | Identifier for the event               |
    | `team_id`        | String   | Identifier for the team                |
    | `history_id`     | String   | Identifier for the history record      |
    | `d_amount`       | Number   | Donation amount                        |
    | `d_email`        | String   | Donor's email address                  |
    | `d_fname`        | String   | Donor's first name                     |
    | `d_lname`        | String   | Donor's last name                      |
    | `d_status`       | String   | Donation status                        |
    | `d_type`         | String   | Donation type                          |
    | `d_anonymous`    | String   | Indicates if the donation is anonymous |
    | `d_message`      | String   | Donation message                       |
    | `d_phone`        | String   | Donor's phone number                   |
    | `d_address`      | String   | Donor's address                        |
    | `d_city`         | String   | Donor's city                           |
    | `d_state`        | String   | Donor's state                          |
    | `d_postcode`     | String   | Donor's postal code                    |
    | `d_country`      | String   | Donor's country                        |
    | `d_company`      | String   | Donor's company                        |
    | `date_paid`      | DateTime | Date the donation was paid             |
    | `date_created`   | DateTime | Date the donation was created          |
    | `crm_donor_id`   | String   | CRM identifier for the donor           |
    | `transaction_id` | String   | Identifier for the transaction         |
    | `payment_type`   | String   | Type of payment                        |
    | `receipt_number` | String   | Receipt number                         |
  </Accordion>

  <Accordion title="Scheduled Donations">
    | Field                | Type     | Description               |
    | :------------------- | :------- | :------------------------ |
    | `id`                 | String   | Unique identifier         |
    | `donation_id`        | String   | Donation identifier       |
    | `member_id`          | String   | Member identifier         |
    | `event_id`           | String   | Event identifier          |
    | `d_amount`           | Number   | Donation amount           |
    | `d_email`            | String   | Donor's email address     |
    | `d_fname`            | String   | Donor's first name        |
    | `d_lname`            | String   | Donor's last name         |
    | `donation_frequency` | String   | Frequency of the donation |
    | `donation_status`    | String   | Status of the donation    |
    | `date_created`       | DateTime | Creation date             |
    | `date_next`          | DateTime | Next donation date        |
    | `date_end`           | DateTime | End date of the donation  |
  </Accordion>

  <Accordion title="Recurring Donations">
    | Field                | Type     | Description               |
    | :------------------- | :------- | :------------------------ |
    | `id`                 | String   | Unique identifier         |
    | `donation_id`        | String   | Donation identifier       |
    | `member_id`          | String   | Member identifier         |
    | `event_id`           | String   | Event identifier          |
    | `d_amount`           | Number   | Donation amount           |
    | `d_email`            | String   | Donor's email address     |
    | `d_fname`            | String   | Donor's first name        |
    | `d_lname`            | String   | Donor's last name         |
    | `donation_frequency` | String   | Frequency of the donation |
    | `donation_status`    | String   | Status of the donation    |
    | `date_created`       | DateTime | Creation date             |
    | `date_next`          | DateTime | Next donation date        |
    | `date_end`           | DateTime | End date of the donation  |
  </Accordion>

  <Accordion title="Participants">
    | Field           | Type     | Description            |
    | :-------------- | :------- | :--------------------- |
    | `member_id`     | String   | Member identifier      |
    | `m_fname`       | String   | Member's first name    |
    | `m_lname`       | String   | Member's last name     |
    | `m_email`       | String   | Member's email         |
    | `m_phone`       | String   | Member's phone         |
    | `m_address`     | String   | Member's address       |
    | `m_city`        | String   | Member's city          |
    | `m_state`       | String   | Member's state         |
    | `m_postcode`    | String   | Member's postal code   |
    | `m_country`     | String   | Member's country       |
    | `m_dob`         | String   | Member's date of birth |
    | `m_gender`      | String   | Member's gender        |
    | `m_status`      | String   | Member's status        |
    | `m_company`     | String   | Member's company       |
    | `date_created`  | DateTime | Creation date          |
    | `date_updated`  | DateTime | Update date            |
    | `crm_member_id` | String   | CRM member identifier  |
  </Accordion>

  <Accordion title="Participants Events">
    | Field            | Type     | Description                            |
    | :--------------- | :------- | :------------------------------------- |
    | `history_id`     | String   | History identifier                     |
    | `member_id`      | String   | Member identifier                      |
    | `event_id`       | String   | Event identifier                       |
    | `team_id`        | String   | Team identifier                        |
    | `m_target`       | Number   | Target amount                          |
    | `m_raised`       | Number   | Amount raised                          |
    | `total_paid`     | Number   | Total paid                             |
    | `total_pending`  | Number   | Total pending                          |
    | `is_paid`        | String   | Indicates if the participation is paid |
    | `m_status`       | Integer  | Member status                          |
    | `date_created`   | DateTime | Creation date                          |
    | `date_updated`   | DateTime | Update date                            |
    | `crm_history_id` | String   | CRM history identifier                 |
  </Accordion>

  <Accordion title="Participants Options">
    | Field          | Type     | Description        |
    | :------------- | :------- | :----------------- |
    | `id`           | String   | Unique identifier  |
    | `history_id`   | String   | History identifier |
    | `member_id`    | String   | Member identifier  |
    | `event_id`     | String   | Event identifier   |
    | `option_name`  | String   | Option name        |
    | `option_value` | String   | Option value       |
    | `option_type`  | String   | Option type        |
    | `option_price` | Number   | Option price       |
    | `date_created` | DateTime | Creation date      |
  </Accordion>

  <Accordion title="Participants Fitness">
    | Field              | Type     | Description        |
    | :----------------- | :------- | :----------------- |
    | `id`               | String   | Unique identifier  |
    | `history_id`       | String   | History identifier |
    | `member_id`        | String   | Member identifier  |
    | `event_id`         | String   | Event identifier   |
    | `fitness_provider` | String   | Fitness provider   |
    | `fitness_type`     | String   | Fitness type       |
    | `fitness_value`    | Number   | Fitness value      |
    | `fitness_unit`     | String   | Fitness unit       |
    | `date_created`     | DateTime | Creation date      |
  </Accordion>

  <Accordion title="Participants Fitness Activity">
    | Field            | Type     | Description        |
    | :--------------- | :------- | :----------------- |
    | `id`             | String   | Unique identifier  |
    | `history_id`     | String   | History identifier |
    | `member_id`      | String   | Member identifier  |
    | `event_id`       | String   | Event identifier   |
    | `activity_type`  | String   | Activity type      |
    | `activity_value` | Number   | Activity value     |
    | `activity_unit`  | String   | Activity unit      |
    | `activity_date`  | DateTime | Activity date      |
    | `date_created`   | DateTime | Creation date      |
  </Accordion>

  <Accordion title="Teams">
    | Field          | Type     | Description            |
    | :------------- | :------- | :--------------------- |
    | `team_id`      | String   | Team identifier        |
    | `t_name`       | String   | Team name              |
    | `t_target`     | Number   | Team target amount     |
    | `t_raised`     | Number   | Team amount raised     |
    | `event_id`     | String   | Event identifier       |
    | `captain_id`   | String   | Captain identifier     |
    | `t_status`     | String   | Team status            |
    | `t_members`    | Integer  | Number of team members |
    | `date_created` | DateTime | Creation date          |
    | `date_updated` | DateTime | Update date            |
    | `crm_team_id`  | String   | CRM team identifier    |
  </Accordion>

  <Accordion title="Events">
    | Field            | Type     | Description          |
    | :--------------- | :------- | :------------------- |
    | `event_id`       | String   | Event identifier     |
    | `event_name`     | String   | Event name           |
    | `event_type`     | String   | Event type           |
    | `event_date`     | DateTime | Event date           |
    | `event_end_date` | DateTime | Event end date       |
    | `event_target`   | Number   | Event target amount  |
    | `event_raised`   | Number   | Event amount raised  |
    | `event_status`   | String   | Event status         |
    | `event_location` | String   | Event location       |
    | `event_url`      | String   | Event URL            |
    | `date_created`   | DateTime | Creation date        |
    | `date_updated`   | DateTime | Update date          |
    | `crm_event_id`   | String   | CRM event identifier |
  </Accordion>

  <Accordion title="Event Products">
    | Field                 | Type     | Description                           |
    | :-------------------- | :------- | :------------------------------------ |
    | `product_id`          | String   | Product identifier                    |
    | `event_id`            | String   | Event identifier                      |
    | `product_name`        | String   | Name of the product                   |
    | `product_price`       | Number   | Price of the product                  |
    | `product_description` | String   | Description of the product            |
    | `is_mandatory`        | String   | Indicates if the product is mandatory |
    | `product_status`      | Integer  | Status of the product                 |
    | `date_created`        | DateTime | Creation date                         |
  </Accordion>

  <Accordion title="Waves">
    | Field             | Type     | Description             |
    | :---------------- | :------- | :---------------------- |
    | `wave_id`         | String   | Wave identifier         |
    | `event_id`        | String   | Event identifier        |
    | `wave_name`       | String   | Wave name               |
    | `wave_date`       | DateTime | Wave date               |
    | `wave_price`      | Number   | Wave price              |
    | `wave_capacity`   | Integer  | Wave capacity           |
    | `wave_registered` | Integer  | Number of registrations |
    | `wave_status`     | String   | Wave status             |
    | `date_created`    | DateTime | Creation date           |
    | `crm_wave_id`     | String   | CRM wave identifier     |
  </Accordion>

  <Accordion title="Themes">
    | Field                  | Type   | Description             |
    | :--------------------- | :----- | :---------------------- |
    | `category_id`          | String | Category identifier     |
    | `category_name`        | String | Category name           |
    | `category_description` | String | Category description    |
    | `category_status`      | String | Category status         |
    | `crm_category_id`      | String | CRM category identifier |
  </Accordion>

  <Accordion title="Products">
    | Field                 | Type     | Description            |
    | :-------------------- | :------- | :--------------------- |
    | `product_id`          | String   | Product identifier     |
    | `product_name`        | String   | Product name           |
    | `product_description` | String   | Product description    |
    | `product_price`       | Number   | Product price          |
    | `product_status`      | String   | Product status         |
    | `product_stock`       | Integer  | Product stock quantity |
    | `date_created`        | DateTime | Creation date          |
    | `crm_product_id`      | String   | CRM product identifier |
  </Accordion>

  <Accordion title="Product Options">
    | Field           | Type     | Description           |
    | :-------------- | :------- | :-------------------- |
    | `option_id`     | String   | Option identifier     |
    | `product_id`    | String   | Product identifier    |
    | `option_name`   | String   | Option name           |
    | `option_price`  | Number   | Option price          |
    | `option_stock`  | Integer  | Option stock quantity |
    | `option_status` | String   | Option status         |
    | `date_created`  | DateTime | Creation date         |
  </Accordion>

  <Accordion title="Sales">
    | Field          | Type     | Description         |
    | :------------- | :------- | :------------------ |
    | `sale_id`      | String   | Sale identifier     |
    | `member_id`    | String   | Member identifier   |
    | `event_id`     | String   | Event identifier    |
    | `total`        | Number   | Total sale amount   |
    | `sale_status`  | String   | Sale status         |
    | `date_paid`    | DateTime | Date paid           |
    | `date_created` | DateTime | Creation date       |
    | `crm_sale_id`  | String   | CRM sale identifier |
  </Accordion>

  <Accordion title="Sales Items">
    | Field          | Type     | Description        |
    | :------------- | :------- | :----------------- |
    | `id`           | String   | Unique identifier  |
    | `sale_id`      | String   | Sale identifier    |
    | `product_id`   | String   | Product identifier |
    | `option_id`    | String   | Option identifier  |
    | `quantity`     | Integer  | Quantity sold      |
    | `price`        | Number   | Price              |
    | `total`        | Number   | Total amount       |
    | `date_created` | DateTime | Creation date      |
  </Accordion>

  <Accordion title="Transactions">
    | Field                | Type     | Description                |
    | :------------------- | :------- | :------------------------- |
    | `transaction_id`     | String   | Transaction identifier     |
    | `member_id`          | String   | Member identifier          |
    | `event_id`           | String   | Event identifier           |
    | `transaction_type`   | String   | Transaction type           |
    | `transaction_value`  | Number   | Transaction value          |
    | `transaction_status` | String   | Transaction status         |
    | `payment_type`       | String   | Payment type               |
    | `payment_reference`  | String   | Payment reference          |
    | `transaction_notes`  | String   | Transaction notes          |
    | `date_created`       | DateTime | Creation date              |
    | `date_updated`       | DateTime | Update date                |
    | `crm_transaction_id` | String   | CRM transaction identifier |
  </Accordion>

  <Accordion title="Raffles">
    | Field                | Type     | Description           |
    | :------------------- | :------- | :-------------------- |
    | `raffle_id`          | String   | Raffle identifier     |
    | `event_id`           | String   | Event identifier      |
    | `raffle_name`        | String   | Raffle name           |
    | `raffle_description` | String   | Raffle description    |
    | `raffle_price`       | Number   | Raffle price          |
    | `raffle_status`      | String   | Raffle status         |
    | `date_created`       | DateTime | Creation date         |
    | `crm_raffle_id`      | String   | CRM raffle identifier |
  </Accordion>

  <Accordion title="Raffle Tickets">
    | Field           | Type     | Description       |
    | :-------------- | :------- | :---------------- |
    | `id`            | String   | Unique identifier |
    | `raffle_id`     | String   | Raffle identifier |
    | `member_id`     | String   | Member identifier |
    | `ticket_number` | String   | Ticket number     |
    | `ticket_status` | String   | Ticket status     |
    | `date_created`  | DateTime | Creation date     |
  </Accordion>

  <Accordion title="Raffle Sales">
    | Field          | Type     | Description         |
    | :------------- | :------- | :------------------ |
    | `sale_id`      | String   | Sale identifier     |
    | `raffle_id`    | String   | Raffle identifier   |
    | `member_id`    | String   | Member identifier   |
    | `quantity`     | Integer  | Quantity of tickets |
    | `total`        | Number   | Total amount        |
    | `sale_status`  | String   | Sale status         |
    | `date_created` | DateTime | Creation date       |
    | `crm_sale_id`  | String   | CRM sale identifier |
  </Accordion>

  <Accordion title="Tickets">
    | Field             | Type     | Description       |
    | :---------------- | :------- | :---------------- |
    | `ticket_id`       | String   | Ticket identifier |
    | `event_id`        | String   | Event identifier  |
    | `member_id`       | String   | Member identifier |
    | `ticket_type`     | String   | Ticket type       |
    | `ticket_price`    | Number   | Ticket price      |
    | `ticket_status`   | String   | Ticket status     |
    | `ticket_quantity` | Integer  | Ticket quantity   |
    | `date_created`    | DateTime | Creation date     |
  </Accordion>

  <Accordion title="Ticketholders">
    | Field          | Type     | Description          |
    | :------------- | :------- | :------------------- |
    | `guest_id`     | String   | Guest identifier     |
    | `ticket_id`    | String   | Ticket identifier    |
    | `event_id`     | String   | Event identifier     |
    | `member_id`    | String   | Member identifier    |
    | `g_fname`      | String   | Guest's first name   |
    | `g_lname`      | String   | Guest's last name    |
    | `g_email`      | String   | Guest's email        |
    | `g_phone`      | String   | Guest's phone        |
    | `g_status`     | String   | Guest's status       |
    | `date_created` | DateTime | Creation date        |
    | `crm_guest_id` | String   | CRM guest identifier |
  </Accordion>
</AccordionGroup>