Skip to main content
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 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.
The stream can be found more easily by typing its name.
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, 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.
  • Determine when to execute an 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 page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.
For you to be able to see it on your Catalog, you need at least one successful source run.

​
Streams and Fields

Below you’ll find all available data streams from Funraisin and their corresponding fields:
FieldTypeDescription
donation_idStringUnique identifier for the donation
member_idStringIdentifier for the member
event_idStringIdentifier for the event
team_idStringIdentifier for the team
history_idStringIdentifier for the history record
d_amountNumberDonation amount
d_emailStringDonor’s email address
d_fnameStringDonor’s first name
d_lnameStringDonor’s last name
d_statusStringDonation status
d_typeStringDonation type
d_anonymousStringIndicates if the donation is anonymous
d_messageStringDonation message
d_phoneStringDonor’s phone number
d_addressStringDonor’s address
d_cityStringDonor’s city
d_stateStringDonor’s state
d_postcodeStringDonor’s postal code
d_countryStringDonor’s country
d_companyStringDonor’s company
date_paidDateTimeDate the donation was paid
date_createdDateTimeDate the donation was created
crm_donor_idStringCRM identifier for the donor
transaction_idStringIdentifier for the transaction
payment_typeStringType of payment
receipt_numberStringReceipt number
FieldTypeDescription
idStringUnique identifier
donation_idStringDonation identifier
member_idStringMember identifier
event_idStringEvent identifier
d_amountNumberDonation amount
d_emailStringDonor’s email address
d_fnameStringDonor’s first name
d_lnameStringDonor’s last name
donation_frequencyStringFrequency of the donation
donation_statusStringStatus of the donation
date_createdDateTimeCreation date
date_nextDateTimeNext donation date
date_endDateTimeEnd date of the donation
FieldTypeDescription
idStringUnique identifier
donation_idStringDonation identifier
member_idStringMember identifier
event_idStringEvent identifier
d_amountNumberDonation amount
d_emailStringDonor’s email address
d_fnameStringDonor’s first name
d_lnameStringDonor’s last name
donation_frequencyStringFrequency of the donation
donation_statusStringStatus of the donation
date_createdDateTimeCreation date
date_nextDateTimeNext donation date
date_endDateTimeEnd date of the donation
FieldTypeDescription
member_idStringMember identifier
m_fnameStringMember’s first name
m_lnameStringMember’s last name
m_emailStringMember’s email
m_phoneStringMember’s phone
m_addressStringMember’s address
m_cityStringMember’s city
m_stateStringMember’s state
m_postcodeStringMember’s postal code
m_countryStringMember’s country
m_dobStringMember’s date of birth
m_genderStringMember’s gender
m_statusStringMember’s status
m_companyStringMember’s company
date_createdDateTimeCreation date
date_updatedDateTimeUpdate date
crm_member_idStringCRM member identifier
FieldTypeDescription
history_idStringHistory identifier
member_idStringMember identifier
event_idStringEvent identifier
team_idStringTeam identifier
m_targetNumberTarget amount
m_raisedNumberAmount raised
total_paidNumberTotal paid
total_pendingNumberTotal pending
is_paidStringIndicates if the participation is paid
m_statusIntegerMember status
date_createdDateTimeCreation date
date_updatedDateTimeUpdate date
crm_history_idStringCRM history identifier
FieldTypeDescription
idStringUnique identifier
history_idStringHistory identifier
member_idStringMember identifier
event_idStringEvent identifier
option_nameStringOption name
option_valueStringOption value
option_typeStringOption type
option_priceNumberOption price
date_createdDateTimeCreation date
FieldTypeDescription
idStringUnique identifier
history_idStringHistory identifier
member_idStringMember identifier
event_idStringEvent identifier
fitness_providerStringFitness provider
fitness_typeStringFitness type
fitness_valueNumberFitness value
fitness_unitStringFitness unit
date_createdDateTimeCreation date
FieldTypeDescription
idStringUnique identifier
history_idStringHistory identifier
member_idStringMember identifier
event_idStringEvent identifier
activity_typeStringActivity type
activity_valueNumberActivity value
activity_unitStringActivity unit
activity_dateDateTimeActivity date
date_createdDateTimeCreation date
FieldTypeDescription
team_idStringTeam identifier
t_nameStringTeam name
t_targetNumberTeam target amount
t_raisedNumberTeam amount raised
event_idStringEvent identifier
captain_idStringCaptain identifier
t_statusStringTeam status
t_membersIntegerNumber of team members
date_createdDateTimeCreation date
date_updatedDateTimeUpdate date
crm_team_idStringCRM team identifier
FieldTypeDescription
event_idStringEvent identifier
event_nameStringEvent name
event_typeStringEvent type
event_dateDateTimeEvent date
event_end_dateDateTimeEvent end date
event_targetNumberEvent target amount
event_raisedNumberEvent amount raised
event_statusStringEvent status
event_locationStringEvent location
event_urlStringEvent URL
date_createdDateTimeCreation date
date_updatedDateTimeUpdate date
crm_event_idStringCRM event identifier
FieldTypeDescription
product_idStringProduct identifier
event_idStringEvent identifier
product_nameStringName of the product
product_priceNumberPrice of the product
product_descriptionStringDescription of the product
is_mandatoryStringIndicates if the product is mandatory
product_statusIntegerStatus of the product
date_createdDateTimeCreation date
FieldTypeDescription
wave_idStringWave identifier
event_idStringEvent identifier
wave_nameStringWave name
wave_dateDateTimeWave date
wave_priceNumberWave price
wave_capacityIntegerWave capacity
wave_registeredIntegerNumber of registrations
wave_statusStringWave status
date_createdDateTimeCreation date
crm_wave_idStringCRM wave identifier
FieldTypeDescription
category_idStringCategory identifier
category_nameStringCategory name
category_descriptionStringCategory description
category_statusStringCategory status
crm_category_idStringCRM category identifier
FieldTypeDescription
product_idStringProduct identifier
product_nameStringProduct name
product_descriptionStringProduct description
product_priceNumberProduct price
product_statusStringProduct status
product_stockIntegerProduct stock quantity
date_createdDateTimeCreation date
crm_product_idStringCRM product identifier
FieldTypeDescription
option_idStringOption identifier
product_idStringProduct identifier
option_nameStringOption name
option_priceNumberOption price
option_stockIntegerOption stock quantity
option_statusStringOption status
date_createdDateTimeCreation date
FieldTypeDescription
sale_idStringSale identifier
member_idStringMember identifier
event_idStringEvent identifier
totalNumberTotal sale amount
sale_statusStringSale status
date_paidDateTimeDate paid
date_createdDateTimeCreation date
crm_sale_idStringCRM sale identifier
FieldTypeDescription
idStringUnique identifier
sale_idStringSale identifier
product_idStringProduct identifier
option_idStringOption identifier
quantityIntegerQuantity sold
priceNumberPrice
totalNumberTotal amount
date_createdDateTimeCreation date
FieldTypeDescription
transaction_idStringTransaction identifier
member_idStringMember identifier
event_idStringEvent identifier
transaction_typeStringTransaction type
transaction_valueNumberTransaction value
transaction_statusStringTransaction status
payment_typeStringPayment type
payment_referenceStringPayment reference
transaction_notesStringTransaction notes
date_createdDateTimeCreation date
date_updatedDateTimeUpdate date
crm_transaction_idStringCRM transaction identifier
FieldTypeDescription
raffle_idStringRaffle identifier
event_idStringEvent identifier
raffle_nameStringRaffle name
raffle_descriptionStringRaffle description
raffle_priceNumberRaffle price
raffle_statusStringRaffle status
date_createdDateTimeCreation date
crm_raffle_idStringCRM raffle identifier
FieldTypeDescription
idStringUnique identifier
raffle_idStringRaffle identifier
member_idStringMember identifier
ticket_numberStringTicket number
ticket_statusStringTicket status
date_createdDateTimeCreation date
FieldTypeDescription
sale_idStringSale identifier
raffle_idStringRaffle identifier
member_idStringMember identifier
quantityIntegerQuantity of tickets
totalNumberTotal amount
sale_statusStringSale status
date_createdDateTimeCreation date
crm_sale_idStringCRM sale identifier
FieldTypeDescription
ticket_idStringTicket identifier
event_idStringEvent identifier
member_idStringMember identifier
ticket_typeStringTicket type
ticket_priceNumberTicket price
ticket_statusStringTicket status
ticket_quantityIntegerTicket quantity
date_createdDateTimeCreation date
FieldTypeDescription
guest_idStringGuest identifier
ticket_idStringTicket identifier
event_idStringEvent identifier
member_idStringMember identifier
g_fnameStringGuest’s first name
g_lnameStringGuest’s last name
g_emailStringGuest’s email
g_phoneStringGuest’s phone
g_statusStringGuest’s status
date_createdDateTimeCreation date
crm_guest_idStringCRM guest identifier