Fluxx

Fluxx is a cloud-based grants management platform designed to streamline and automate the entire grantmaking process for foundations, corporations, governments, and other funding organizations.

ingestr supports Fluxx as a source.

URI format

The URI format for Fluxx is:

plaintext

fluxx://<instance>?client_id=<client_id>&client_secret=<client_secret>

URI parameters:

instance: Your Fluxx instance subdomain (e.g., mycompany.preprod for https://mycompany.preprod.fluxxlabs.com)
client_id: OAuth 2.0 client ID for authentication
client_secret: OAuth 2.0 client secret for authentication

Example usage

Basic usage - all fields

Assuming your instance is myorg.preprod, you can ingest grant requests into DuckDB using:

bash

ingestr ingest \
--source-uri 'fluxx://myorg.preprod?client_id=your_client_id&client_secret=your_client_secret' \
--source-table 'grant_request' \
--dest-uri duckdb:///fluxx.duckdb \
--dest-table 'raw.grant_request'

Custom field selection

You can select specific fields to ingest using the colon syntax:

bash

ingestr ingest \
--source-uri 'fluxx://myorg.preprod?client_id=your_client_id&client_secret=your_client_secret' \
--source-table 'grant_request:id,amount_requested,amount_recommended,granted' \
--dest-uri duckdb:///fluxx.duckdb \
--dest-table 'raw.grant_request'

Tables

Fluxx source allows ingesting the following sources into separate tables:

Table	PK	Inc Key	Inc Strategy	Details
`claim`	id	updated_at	merge	Grant claims and payment requests with approval status, amounts, and dates
`claim_expense`	id	updated_at	merge	Claim expense forms and templates for financial tracking
`claim_expense_datum`	id	updated_at	merge	Individual data entries within claim expense forms with budget category details
`claim_expense_row`	id	updated_at	merge	Specific line items or rows within claim expense forms
`concept_initiative`	id	updated_at	merge	Concept initiatives linking programs, initiatives, and sub-programs/sub-initiatives
`dashboard_theme`	id	updated_at	merge	Dashboard theme configurations for UI customization
`etl_claim_expense_datum`	id	updated_at	merge	ETL data for claim expense items with comprehensive budget tracking details
`etl_grantee_budget_tracker_actual`	id	updated_at	merge	ETL data for actual grantee budget tracker amounts and expenses
`etl_grantee_budget_tracker_period_datum`	id	updated_at	merge	ETL data for grantee budget tracker period information with detailed financial tracking
`etl_relationship`	id	updated_at	merge	ETL data for entity relationships tracking connections between users, organizations, requests, and other entities
`etl_request_budget`	id	updated_at	merge	ETL budget data for request funding sources with comprehensive financial details
`etl_request_transaction_budget`	id	updated_at	merge	ETL budget data for request transaction funding sources including payment tracking
`exempt_organization`	id	updated_at	merge	Tax-exempt organization data including EIN, classification, and financial information
`geo_city`	id	updated_at	merge	City geographic data with coordinates and postal codes
`geo_county`	id	updated_at	merge	County geographic data with FIPS codes
`geo_place`	id	updated_at	merge	Geographic places with ancestry and location data
`geo_region`	id	updated_at	merge	Geographic regions
`geo_state`	id	updated_at	merge	State geographic data with abbreviations and FIPS codes
`grant_request`	id	updated_at	merge	Grant applications and requests with comprehensive details (300+ fields)
`grantee_budget_category`	id	updated_at	merge	Budget category definitions used by grantees for expense tracking
`grantee_budget_tracker`	id	updated_at	merge	Budget tracking documents for grantee financial management
`grantee_budget_tracker_period`	id	updated_at	merge	Time periods for budget tracking with start and end dates
`grantee_budget_tracker_period_datum`	id	updated_at	merge	Budget data entries for specific tracking periods
`grantee_budget_tracker_period_datum_actual`	id	updated_at	merge	Actual expenses and amounts recorded for budget tracking periods
`grantee_budget_tracker_row`	id	updated_at	merge	Individual budget line items and categories within budget trackers
`integration_log`	id	updated_at	merge	Integration and system logs for tracking data processing and errors
`mac_model_type_dyn_financial_audit`	id	updated_at	merge	Dynamic financial audit models with audit tracking, compliance status, and financial variance analysis
`mac_model_type_dyn_mel`	id	updated_at	merge	Dynamic Monitoring, Evaluation & Learning (MEL) models with performance indicators, baseline tracking, and evaluation metrics
`mac_model_type_dyn_tool`	id	updated_at	merge	Dynamic tool management models for tracking deployment status, usage metrics, and tool effectiveness
`machine_category`	id	updated_at	merge	Machine category definitions for workflow state management
`model_attribute_value`	id	updated_at	merge	Model attribute values with hierarchical data and dependencies
`model_document`	id	updated_at	merge	Document metadata including file information, storage details, and document relationships
`model_document_sub_type`	id	updated_at	merge	Document sub-type definitions and categories
`model_document_type`	id	updated_at	merge	Document type configurations including DocuSign integration and permissions
`model_theme`	id	updated_at	merge	Model themes for categorization and program hierarchy organization
`organization`	id	updated_at	merge	Organizations (grantees, fiscal sponsors, etc.) with contact information and tax details
`population_estimate`	id	updated_at	merge	Population estimates by geographic area with demographic data
`population_estimate_year`	id	updated_at	merge	Yearly population estimates with income and demographic breakdowns
`program`	id	updated_at	merge	Funding programs and initiatives
`request_report`	id	updated_at	merge	Reports submitted for grants
`request_transaction`	id	updated_at	merge	Financial transactions and payments
`request_transaction_funding_source`	id	updated_at	merge	Funding source details for specific request transactions
`request_user`	id	updated_at	merge	Relationships between requests and users with roles and descriptions
`salesforce_authentication`	id	updated_at	merge	Salesforce authentication configurations with OAuth tokens, connection management, and API usage tracking
`sub_initiative`	id	updated_at	merge	Sub-initiatives for detailed planning
`sub_program`	id	updated_at	merge	Sub-programs under main programs
`ui_version`	id	updated_at	merge	User interface version information and system configuration
`user`	id	updated_at	merge	User accounts and profiles
`user_organization`	id	updated_at	merge	Relationships between users and organizations with roles, departments, and contact details

Use these as --source-table parameter in the ingestr ingest command.

Field Selection

Each resource contains numerous fields. You can:

Ingest all fields: Use the resource name directly (e.g., grant_request)
Select specific fields: Use colon syntax (e.g., grant_request:id,name,amount_requested)

The field selection feature is particularly useful for large resources like grant_request which has over 300 fields.

Authentication

Fluxx uses OAuth 2.0 with client credentials flow. To obtain credentials:

Contact your Fluxx administrator to create an API client
You'll receive a client_id and client_secret
Note your Fluxx instance subdomain (the part before .fluxxlabs.com)

Fluxx ​

URI format ​

Example usage ​

Basic usage - all fields ​

Custom field selection ​

Tables ​

Field Selection ​

Authentication ​