# 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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/infusionsoft-now-keap-max-classic/schema-information.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.