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
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 |
Last updated