Schema Information

This topic provides a structured reference to assist you in working with Daton's Infusionsoft connector and the associated fields and tables.

Tables/APIs

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

• Appointment

• Campaign

• Commission

• Companies

• CompaniesModel

• Contact

• ContactsModel

• Email

• OpportunitiesModel

• Opportunity

• Order

• Product

• Subscription

• Tag

• Task

• Transaction

• 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.

FIELDS

Field Name	Data Type
id	NUMERIC
title	STRING
description	STRING
user	NUMERIC
location	STRING
url	STRING
contact_id	NUMERIC
creation_date	TIMESTAMP
modification_date	TIMESTAMP
start_date	TIMESTAMP
end_date	TIMESTAMP
remind_time	STRING

Campaign

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.

FIELDS

Field Name	Data Type
error_message	STRING
date_created	TIMESTAMP
name	STRING
active_contact_count	NUMERIC
published_status	BOOLEAN
id	NUMERIC
completed_contact_count	NUMERIC
published_time_zone	STRING
time_zone	STRING
published_date	TIMESTAMP

Commission

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.

Field Name	Data Type
description	STRING
amount_earned	NUMERIC
contact_first_name	STRING
contact_last_name	STRING
invoice_id	NUMERIC
date_earned	TIMESTAMP
contact_id	NUMERIC
sales_affiliate_id	NUMERIC
sold_by_first_name	STRING
sold_by_last_name	STRING
product_name	STRING

Companies

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

For more information, see this link.

FIELDS

Field Name	Data Type
email_opted_in	BOOLEAN
website	STRING
address	RECORD
email_address	STRING
company_name	STRING
phone_number	RECORD
id	NUMERIC
email_status	STRING
notes	STRING
custom_fields	RECORD
fax_number	RECORD

CompaniesModel

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

For more information, see this link.

FIELDS

Field Name	Data Type
id	NUMERIC
label	STRING
options	RECORD
record_type	STRING
field_type	STRING
field_name	STRING

Contact

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

For more information, see this link.

FIELDS

Field Name	Data Type
email_addresses	RECORD
email_opted_in	BOOLEAN
addresses	RECORD
last_updated	TIMESTAMP
tag_ids	STRING
tags	RECORD
owner_id	NUMERIC
date_created	TIMESTAMP
middle_name	STRING
given_name	STRING
ScoreValue	STRING
email_status	STRING
phone_numbers	RECORD
last_updated_utc_millis	TIMESTAMP
company	RECORD
id	NUMERIC
family_name	STRING
birthday	DATE
opt_in_reason	STRING
preferred_locale	STRING
website	STRING
notes	STRING
prefix	STRING
origin	STRING
lead_source_id	STRING
custom_fields	RECORD
source_type	STRING
time_zone	STRING
suffix	STRING
social_accounts	STRING
fax_numbers	RECORD
relationships	STRING
spouse_name	STRING
contact_type	STRING
company_name	STRING
job_title	STRING
anniversary	DATE
preferred_name	STRING

ContactsModel

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

For more information, see this link.

FIELDS

Field Name	Data Type
id	NUMERIC
label	STRING
options	RECORD
record_type	STRING
field_type	STRING
field_name	STRING

Email

Manage email-related data and interactions efficiently, including email campaigns and communication history.

For more information, see this link.

FIELDS

Field Name	Data Type
id	NUMERIC
subject	STRING
headers	STRING
contact_id	NUMERIC
sent_to_address	STRING
sent_to_cc_addresses	STRING
sent_to_bcc_addresses	STRING
sent_from_address	STRING
sent_from_reply_address	STRING
sent_date	TIMESTAMP
received_date	TIMESTAMP
opened_date	TIMESTAMP
clicked_date	TIMESTAMP
original_provider	STRING
original_provider_id	STRING

OpportunitiesModel

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

For more information, see this link.

FIELDS

Field Name	Data Type
id	NUMERIC
label	STRING
options	RECORD
record_type	STRING
field_type	STRING
field_name	STRING

Opportunity

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

For more information, see this link.

FIELDS

Field Name	Data Type
last_updated	TIMESTAMP
opportunity_notes	STRING
affiliate_id	NUMERIC
opportunity_title	STRING
date_created	TIMESTAMP
estimated_close_date	TIMESTAMP
next_action_notes	STRING
stage	RECORD
next_action_date	TIMESTAMP
contact	RECORD
projected_revenue_low	NUMERIC
include_in_forecast	NUMERIC
id	NUMERIC
custom_fields	RECORD
user	RECORD
projected_revenue_high	NUMERIC

Order

Handle and manipulate order information and transactions, including tracking and processing orders seamlessly.

For more information, see this link.

FIELDS

Field Name	Data Type
id	NUMERIC
title	STRING
status	STRING
recurring	STRING
total	NUMERIC
contact	RECORD
notes	STRING
terms	STRING
creation_date	TIMESTAMP
modification_date	TIMESTAMP
order_date	TIMESTAMP
lead_affiliate_id	NUMERIC
sales_affiliate_id	NUMERIC
total_paid	NUMERIC
total_due	NUMERIC
shipping_information	RECORD
refund_total	NUMERIC
allow_payment	STRING
allow_paypal	STRING
order_items	RECORD
payment_plan	RECORD

Product

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

For more information, see this link.

FIELDS

Field Name	Data Type
id	NUMERIC
sku	STRING
url	STRING
status	NUMERIC
sub_category_id	NUMERIC
product_name	STRING
product_desc	STRING
product_price	NUMERIC
product_short_desc	STRING
subscription_only	BOOLEAN
product_options	STRING
subscription_plans	RECORD

Subscription

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

For more information, see this link.

FIELDS

Field Name	Data Type
id	NUMERIC
quantity	NUMERIC
active	BOOLEAN
contact_id	NUMERIC
product_id	NUMERIC
subscription_plan_id	NUMERIC
billing_amount	NUMERIC
auto_charge	BOOLEAN
billing_frequency	NUMERIC
billing_cycle	STRING
start_date	DATE
next_bill_date	DATE
end_date	DATE
payment_gateway_id	NUMERIC
credit_card_id	NUMERIC
use_default_payment_gateway	BOOLEAN
allow_tax	BOOLEAN
sale_affiliate_id	NUMERIC

Tag

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

For more information, see this link.

FIELDS

Field Name	Data Type
id	NUMERIC
name	STRING

Task

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

For more information, see this link.

FIELDS

Field Name	Data Type
id	NUMERIC
title	STRING
description	STRING
type	STRING
priority	NUMERIC
completed	BOOLEAN
contact	RECORD
url	STRING
due_date	TIMESTAMP
creation_date	TIMESTAMP
modification_date	TIMESTAMP
completion_date	TIMESTAMP
remind_time	STRING
user_id	NUMERIC

Transaction

Access and manage transaction data and records, crucial for financial and accounting operations.

For more information, see this link.

FIELDS

Field Name	Data Type
id	NUMERIC
test	BOOLEAN
amount	NUMERIC
currency	STRING
gateway	STRING
type	STRING
status	STRING
errors	STRING
orders	RECORD
contact_id	NUMERIC
transaction_date	TIMESTAMP
gateway_account_name	STRING
order_ids	NUMERIC
collection_method	STRING
payment_id	NUMERIC

User

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

For more information, see this link.

FIELDS

Field Name	Data Type
address	RECORD
website	STRING
partner	BOOLEAN
status	STRING
company_name	STRING
email_address	STRING
phone_numbers	RECORD
fax_numbers	RECORD
given_name	STRING
family_name	STRING
middle_name	STRING
preferred_name	STRING
time_zone	STRING
job_title	STRING
infusionsoft_id	STRING
date_created	TIMESTAMP
created_by	NUMERIC
last_updated	TIMESTAMP
last_updated_by	NUMERIC
global_user_id	NUMERIC
id	NUMERIC