Schema Information
This topic provides a structured reference to assist you in working with Daton's Infusionsoft connector and the associated fields and tables.
Last updated
Was this helpful?
Daton
This topic provides a structured reference to assist you in working with Daton's Infusionsoft connector and the associated fields and tables.
Last updated
Was this helpful?
The following is the list of tables or APIs associated with the Infusionsoft connector:
This API enables the management and scheduling of appointments, making it easier to organize and track appointments efficiently.
FIELDS
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
With the Campaign API, you can access and control the data and parameters related to your marketing campaigns, allowing for effective campaign management.
FIELDS
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
The Commission API handles commission-related data and calculations, making it a vital tool for businesses with commission-based compensation structures.
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
This API allows for the management of company and organization-related information, making it easier to keep track of business contacts and relationships.
FIELDS
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
The CompaniesModel API provides programmatic access to company data, enabling seamless integration and manipulation of company records.
FIELDS
id
NUMERIC
label
STRING
options
RECORD
record_type
STRING
field_type
STRING
field_name
STRING
Interact with contact information and related data using the Contact API, which is essential for managing customer relationships and communication.
FIELDS
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
This API offers programmatic access to contact records, enabling automated management and customization of contact information.
FIELDS
id
NUMERIC
label
STRING
options
RECORD
record_type
STRING
field_type
STRING
field_name
STRING
Manage email-related data and interactions efficiently, including email campaigns and communication history.
FIELDS
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
The OpportunitiesModel API provides programmatic access to opportunity records, helping businesses automate and streamline their sales processes.
FIELDS
id
NUMERIC
label
STRING
options
RECORD
record_type
STRING
field_type
STRING
field_name
STRING
This API facilitates the management and tracking of sales opportunities, making it easier to monitor and nurture potential leads.
FIELDS
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
Handle and manipulate order information and transactions, including tracking and processing orders seamlessly.
FIELDS
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
Access and manage product-related data and details, aiding in inventory management and sales operations.
FIELDS
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
Manage subscription-related data and interactions, making it simpler to handle subscription-based services or products.
FIELDS
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
Control and interact with tags assigned to contacts or entities, allowing for organized categorization and segmentation of data.
FIELDS
id
NUMERIC
name
STRING
Handle tasks, to-do lists, and task-related data, helping users stay organized and on top of their responsibilities.
FIELDS
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
Access and manage transaction data and records, crucial for financial and accounting operations.
FIELDS
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
Interact with user profiles, permissions, and user-related data, making it possible to manage user access and roles within the system.
FIELDS
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
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .
For more information, see this .