> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/infusionsoft-now-keap-max-classic/schema-information.md).

# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the Infusionsoft connector:

* [Appointment](#appointment) 
* [Campaign](#campaign) 
* [Commission](#commission) 
* [Companies](#companies) 
* [CompaniesModel](#companiesmodel) 
* [Contact](#contact) 
* [ContactsModel](#contactsmodel) 
* [Email](#email) 
* [OpportunitiesModel](#opportunitiesmodel) 
* [Opportunity](#opportunity) 
* [Order](#order) 
* [Product](#product) 
* [Subscription](#subscription) 
* [Tag](#tag) 
* [Task](#task) 
* [Transaction](#transaction) 
* [User](#user)

#### Appointment 

This API enables the management and scheduling of appointments, making it easier to organize and track appointments efficiently.

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Appointment).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>user</td><td>NUMERIC</td></tr><tr><td>location</td><td>STRING</td></tr><tr><td>url</td><td>STRING</td></tr><tr><td>contact_id</td><td>NUMERIC</td></tr><tr><td>creation_date</td><td>TIMESTAMP</td></tr><tr><td>modification_date</td><td>TIMESTAMP</td></tr><tr><td>start_date</td><td>TIMESTAMP</td></tr><tr><td>end_date</td><td>TIMESTAMP</td></tr><tr><td>remind_time</td><td>STRING</td></tr></tbody></table>

#### Campaign&#x20;

With the Campaign API, you can access and control the data and parameters related to your marketing campaigns, allowing for effective campaign management.

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Campaign).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>error_message</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>active_contact_count</td><td>NUMERIC</td></tr><tr><td>published_status</td><td>BOOLEAN</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>completed_contact_count</td><td>NUMERIC</td></tr><tr><td>published_time_zone</td><td>STRING</td></tr><tr><td>time_zone</td><td>STRING</td></tr><tr><td>published_date</td><td>TIMESTAMP</td></tr></tbody></table>

#### Commission&#x20;

The Commission API handles commission-related data and calculations, making it a vital tool for businesses with commission-based compensation structures.

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Affiliate/operation/listCommissionsUsingGET).

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>description</td><td>STRING</td></tr><tr><td>amount_earned</td><td>NUMERIC</td></tr><tr><td>contact_first_name</td><td>STRING</td></tr><tr><td>contact_last_name</td><td>STRING</td></tr><tr><td>invoice_id</td><td>NUMERIC</td></tr><tr><td>date_earned</td><td>TIMESTAMP</td></tr><tr><td>contact_id</td><td>NUMERIC</td></tr><tr><td>sales_affiliate_id</td><td>NUMERIC</td></tr><tr><td>sold_by_first_name</td><td>STRING</td></tr><tr><td>sold_by_last_name</td><td>STRING</td></tr><tr><td>product_name</td><td>STRING</td></tr></tbody></table>

#### Companies&#x20;

This API allows for the management of company and organization-related information, making it easier to keep track of business contacts and relationships.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Company).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>email_opted_in</td><td>BOOLEAN</td></tr><tr><td>website</td><td>STRING</td></tr><tr><td>address</td><td>RECORD</td></tr><tr><td>email_address</td><td>STRING</td></tr><tr><td>company_name</td><td>STRING</td></tr><tr><td>phone_number</td><td>RECORD</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>email_status</td><td>STRING</td></tr><tr><td>notes</td><td>STRING</td></tr><tr><td>custom_fields</td><td>RECORD</td></tr><tr><td>fax_number</td><td>RECORD</td></tr></tbody></table>

#### CompaniesModel&#x20;

The CompaniesModel API provides programmatic access to company data, enabling seamless integration and manipulation of company records.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Company/operation/retrieveCompanyModelUsingGET).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>label</td><td>STRING</td></tr><tr><td>options</td><td>RECORD</td></tr><tr><td>record_type</td><td>STRING</td></tr><tr><td>field_type</td><td>STRING</td></tr><tr><td>field_name</td><td>STRING</td></tr></tbody></table>

#### Contact&#x20;

Interact with contact information and related data using the Contact API, which is essential for managing customer relationships and communication.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Contact).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>email_addresses</td><td>RECORD</td></tr><tr><td>email_opted_in</td><td>BOOLEAN</td></tr><tr><td>addresses</td><td>RECORD</td></tr><tr><td>last_updated</td><td>TIMESTAMP</td></tr><tr><td>tag_ids</td><td>STRING</td></tr><tr><td>tags</td><td>RECORD</td></tr><tr><td>owner_id</td><td>NUMERIC</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>middle_name</td><td>STRING</td></tr><tr><td>given_name</td><td>STRING</td></tr><tr><td>ScoreValue</td><td>STRING</td></tr><tr><td>email_status</td><td>STRING</td></tr><tr><td>phone_numbers</td><td>RECORD</td></tr><tr><td>last_updated_utc_millis</td><td>TIMESTAMP</td></tr><tr><td>company</td><td>RECORD</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>family_name</td><td>STRING</td></tr><tr><td>birthday</td><td>DATE</td></tr><tr><td>opt_in_reason</td><td>STRING</td></tr><tr><td>preferred_locale</td><td>STRING</td></tr><tr><td>website</td><td>STRING</td></tr><tr><td>notes</td><td>STRING</td></tr><tr><td>prefix</td><td>STRING</td></tr><tr><td>origin</td><td>STRING</td></tr><tr><td>lead_source_id</td><td>STRING</td></tr><tr><td>custom_fields</td><td>RECORD</td></tr><tr><td>source_type</td><td>STRING</td></tr><tr><td>time_zone</td><td>STRING</td></tr><tr><td>suffix</td><td>STRING</td></tr><tr><td>social_accounts</td><td>STRING</td></tr><tr><td>fax_numbers</td><td>RECORD</td></tr><tr><td>relationships</td><td>STRING</td></tr><tr><td>spouse_name</td><td>STRING</td></tr><tr><td>contact_type</td><td>STRING</td></tr><tr><td>company_name</td><td>STRING</td></tr><tr><td>job_title</td><td>STRING</td></tr><tr><td>anniversary</td><td>DATE</td></tr><tr><td>preferred_name</td><td>STRING</td></tr></tbody></table>

#### ContactsModel&#x20;

This API offers programmatic access to contact records, enabling automated management and customization of contact information.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Contact/operation/retrieveContactModelUsingGET).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>label</td><td>STRING</td></tr><tr><td>options</td><td>RECORD</td></tr><tr><td>record_type</td><td>STRING</td></tr><tr><td>field_type</td><td>STRING</td></tr><tr><td>field_name</td><td>STRING</td></tr></tbody></table>

#### Email&#x20;

Manage email-related data and interactions efficiently, including email campaigns and communication history.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Email).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>subject</td><td>STRING</td></tr><tr><td>headers</td><td>STRING</td></tr><tr><td>contact_id</td><td>NUMERIC</td></tr><tr><td>sent_to_address</td><td>STRING</td></tr><tr><td>sent_to_cc_addresses</td><td>STRING</td></tr><tr><td>sent_to_bcc_addresses</td><td>STRING</td></tr><tr><td>sent_from_address</td><td>STRING</td></tr><tr><td>sent_from_reply_address</td><td>STRING</td></tr><tr><td>sent_date</td><td>TIMESTAMP</td></tr><tr><td>received_date</td><td>TIMESTAMP</td></tr><tr><td>opened_date</td><td>TIMESTAMP</td></tr><tr><td>clicked_date</td><td>TIMESTAMP</td></tr><tr><td>original_provider</td><td>STRING</td></tr><tr><td>original_provider_id</td><td>STRING</td></tr></tbody></table>

#### OpportunitiesModel&#x20;

The OpportunitiesModel API provides programmatic access to opportunity records, helping businesses automate and streamline their sales processes.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Opportunity/operation/retrieveOpportunityModelUsingGET).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>label</td><td>STRING</td></tr><tr><td>options</td><td>RECORD</td></tr><tr><td>record_type</td><td>STRING</td></tr><tr><td>field_type</td><td>STRING</td></tr><tr><td>field_name</td><td>STRING</td></tr></tbody></table>

#### Opportunity&#x20;

This API facilitates the management and tracking of sales opportunities, making it easier to monitor and nurture potential leads.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Opportunity).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>last_updated</td><td>TIMESTAMP</td></tr><tr><td>opportunity_notes</td><td>STRING</td></tr><tr><td>affiliate_id</td><td>NUMERIC</td></tr><tr><td>opportunity_title</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>estimated_close_date</td><td>TIMESTAMP</td></tr><tr><td>next_action_notes</td><td>STRING</td></tr><tr><td>stage</td><td>RECORD</td></tr><tr><td>next_action_date</td><td>TIMESTAMP</td></tr><tr><td>contact</td><td>RECORD</td></tr><tr><td>projected_revenue_low</td><td>NUMERIC</td></tr><tr><td>include_in_forecast</td><td>NUMERIC</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>custom_fields</td><td>RECORD</td></tr><tr><td>user</td><td>RECORD</td></tr><tr><td>projected_revenue_high</td><td>NUMERIC</td></tr></tbody></table>

#### Order&#x20;

Handle and manipulate order information and transactions, including tracking and processing orders seamlessly.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/E-Commerce).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>recurring</td><td>STRING</td></tr><tr><td>total</td><td>NUMERIC</td></tr><tr><td>contact</td><td>RECORD</td></tr><tr><td>notes</td><td>STRING</td></tr><tr><td>terms</td><td>STRING</td></tr><tr><td>creation_date</td><td>TIMESTAMP</td></tr><tr><td>modification_date</td><td>TIMESTAMP</td></tr><tr><td>order_date</td><td>TIMESTAMP</td></tr><tr><td>lead_affiliate_id</td><td>NUMERIC</td></tr><tr><td>sales_affiliate_id</td><td>NUMERIC</td></tr><tr><td>total_paid</td><td>NUMERIC</td></tr><tr><td>total_due</td><td>NUMERIC</td></tr><tr><td>shipping_information</td><td>RECORD</td></tr><tr><td>refund_total</td><td>NUMERIC</td></tr><tr><td>allow_payment</td><td>STRING</td></tr><tr><td>allow_paypal</td><td>STRING</td></tr><tr><td>order_items</td><td>RECORD</td></tr><tr><td>payment_plan</td><td>RECORD</td></tr></tbody></table>

#### Product&#x20;

Access and manage product-related data and details, aiding in inventory management and sales operations.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Product).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>url</td><td>STRING</td></tr><tr><td>status</td><td>NUMERIC</td></tr><tr><td>sub_category_id</td><td>NUMERIC</td></tr><tr><td>product_name</td><td>STRING</td></tr><tr><td>product_desc</td><td>STRING</td></tr><tr><td>product_price</td><td>NUMERIC</td></tr><tr><td>product_short_desc</td><td>STRING</td></tr><tr><td>subscription_only</td><td>BOOLEAN</td></tr><tr><td>product_options</td><td>STRING</td></tr><tr><td>subscription_plans</td><td>RECORD</td></tr></tbody></table>

#### Subscription&#x20;

Manage subscription-related data and interactions, making it simpler to handle subscription-based services or products.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/E-Commerce/operation/listSubscriptionsUsingGET).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>quantity</td><td>NUMERIC</td></tr><tr><td>active</td><td>BOOLEAN</td></tr><tr><td>contact_id</td><td>NUMERIC</td></tr><tr><td>product_id</td><td>NUMERIC</td></tr><tr><td>subscription_plan_id</td><td>NUMERIC</td></tr><tr><td>billing_amount</td><td>NUMERIC</td></tr><tr><td>auto_charge</td><td>BOOLEAN</td></tr><tr><td>billing_frequency</td><td>NUMERIC</td></tr><tr><td>billing_cycle</td><td>STRING</td></tr><tr><td>start_date</td><td>DATE</td></tr><tr><td>next_bill_date</td><td>DATE</td></tr><tr><td>end_date</td><td>DATE</td></tr><tr><td>payment_gateway_id</td><td>NUMERIC</td></tr><tr><td>credit_card_id</td><td>NUMERIC</td></tr><tr><td>use_default_payment_gateway</td><td>BOOLEAN</td></tr><tr><td>allow_tax</td><td>BOOLEAN</td></tr><tr><td>sale_affiliate_id</td><td>NUMERIC</td></tr></tbody></table>

#### Tag&#x20;

Control and interact with tags assigned to contacts or entities, allowing for organized categorization and segmentation of data.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Tags).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr></tbody></table>

#### Task&#x20;

Handle tasks, to-do lists, and task-related data, helping users stay organized and on top of their responsibilities.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Task).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>priority</td><td>NUMERIC</td></tr><tr><td>completed</td><td>BOOLEAN</td></tr><tr><td>contact</td><td>RECORD</td></tr><tr><td>url</td><td>STRING</td></tr><tr><td>due_date</td><td>TIMESTAMP</td></tr><tr><td>creation_date</td><td>TIMESTAMP</td></tr><tr><td>modification_date</td><td>TIMESTAMP</td></tr><tr><td>completion_date</td><td>TIMESTAMP</td></tr><tr><td>remind_time</td><td>STRING</td></tr><tr><td>user_id</td><td>NUMERIC</td></tr></tbody></table>

#### Transaction&#x20;

Access and manage transaction data and records, crucial for financial and accounting operations.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/E-Commerce/operation/listTransactionsUsingGET).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>test</td><td>BOOLEAN</td></tr><tr><td>amount</td><td>NUMERIC</td></tr><tr><td>currency</td><td>STRING</td></tr><tr><td>gateway</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>errors</td><td>STRING</td></tr><tr><td>orders</td><td>RECORD</td></tr><tr><td>contact_id</td><td>NUMERIC</td></tr><tr><td>transaction_date</td><td>TIMESTAMP</td></tr><tr><td>gateway_account_name</td><td>STRING</td></tr><tr><td>order_ids</td><td>NUMERIC</td></tr><tr><td>collection_method</td><td>STRING</td></tr><tr><td>payment_id</td><td>NUMERIC</td></tr></tbody></table>

#### User&#x20;

Interact with user profiles, permissions, and user-related data, making it possible to manage user access and roles within the system.&#x20;

For more information, see this [link](https://developer.infusionsoft.com/docs/rest/#tag/Users).

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>address</td><td>RECORD</td></tr><tr><td>website</td><td>STRING</td></tr><tr><td>partner</td><td>BOOLEAN</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>company_name</td><td>STRING</td></tr><tr><td>email_address</td><td>STRING</td></tr><tr><td>phone_numbers</td><td>RECORD</td></tr><tr><td>fax_numbers</td><td>RECORD</td></tr><tr><td>given_name</td><td>STRING</td></tr><tr><td>family_name</td><td>STRING</td></tr><tr><td>middle_name</td><td>STRING</td></tr><tr><td>preferred_name</td><td>STRING</td></tr><tr><td>time_zone</td><td>STRING</td></tr><tr><td>job_title</td><td>STRING</td></tr><tr><td>infusionsoft_id</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>created_by</td><td>NUMERIC</td></tr><tr><td>last_updated</td><td>TIMESTAMP</td></tr><tr><td>last_updated_by</td><td>NUMERIC</td></tr><tr><td>global_user_id</td><td>NUMERIC</td></tr><tr><td>id</td><td>NUMERIC</td></tr></tbody></table>