SugarCRM
SugarCRM ETL connector for data replication
SugarCRM
SugarCRM ETL connector for data replication
Snapshot
| Features | Details |
Release Status |
Released |
Source API Version |
V10 |
Table Selection |
Yes |
Column Selection |
Yes |
Edit Integration |
Yes |
Replication Type Selection |
No |
Authentication Parameters |
None |
Replication Type |
Key Based Replication, Full Replication |
Replication Key |
date_modified |
Suggested Replication Frequency |
24 hours |
Tables/APIs Supported
accounts |
currencies |
meetings |
contacts |
cases |
calendar |
emails |
calculated_fields_updated_queue |
tags |
product_catalog |
purchases |
tasks |
calls |
notes |
| purchased_line_items |
Integrate SugarCRM with Daton
- Sign in to Daton
- Select SugarCRM from Integrations page
- Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
- In the next step you will be asked to enter sugar CRM site url, sugar CRM username and password
- Post successful authentication you will be prompted to choose required tables from the list
- Then select all required fields
- Submit the integration
Workflow
- Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
- Users would be able to edit/pause/re-activate/delete integration anytime
- Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Sugar CRM Data
accounts
Purpose: This API is used to fetch all the accounts for the given credentials
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
business_center_id |
STRING |
campaign_id |
STRING |
campaign_name |
STRING |
campaign_accounts |
RECORD |
next_renewal_date |
STRING |
widget_next_renewal_date |
STRING |
hint_account_size |
STRING |
hint_account_industry |
STRING |
hint_account_location |
STRING |
hint_account_industry_tags |
STRING |
hint_account_founded_year |
STRING |
hint_account_facebook_handle |
STRING |
hint_account_logo |
STRING |
hint_account_pic |
STRING |
hint_account_naics_code_lbl |
STRING |
hint_account_fiscal_year_end |
STRING |
geocode_status |
STRING |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
email1 |
STRING |
email2 |
STRING |
invalid_email |
STRING |
email_opt_out |
STRING |
email_addresses_non_primary |
STRING |
is_escalated |
BOOLEAN |
prosperworks_id_c |
STRING |
days_since_last_activity_c |
NUMERIC |
interaction_count_c |
NUMERIC |
channel_c |
STRING |
most_recent_opportunity_c |
STRING |
first_closed_won_opp_c |
STRING |
type_visibility_c |
STRING |
custom_type_c |
STRING |
last_activity_date_c |
DATE |
first_order_c |
STRING |
last_order_date_c |
STRING |
date_converted_c |
STRING |
days_since_last_order_c |
NUMERIC |
master_type_c |
STRING |
_module |
STRING |
currencies
Purpose: This API is used to fetch the currencies associated with the account
Replication: Full Replication
Replication Key: NA
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
symbol |
STRING |
iso4217 |
STRING |
conversion_rate |
NUMERIC |
status |
STRING |
deleted |
BOOLEAN |
hide |
STRING |
unhide |
STRING |
my_favorite |
BOOLEAN |
_module |
STRING |
meetings
Purpose: This API is used to fetch all the meetings for the given credentials
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
accept_status |
STRING |
set_accept_links |
STRING |
location |
STRING |
password |
STRING |
join_url |
STRING |
host_url |
STRING |
displayed_url |
STRING |
creator |
STRING |
external_id |
STRING |
duration_hours |
NUMERIC |
duration_minutes |
NUMERIC |
date_start |
TIMESTAMP |
date_end |
TIMESTAMP |
parent_type |
STRING |
status |
STRING |
type |
STRING |
direction |
STRING |
parent_id |
STRING |
reminder_checked |
STRING |
reminder_time |
NUMERIC |
email_reminder_checked |
STRING |
email_reminder_time |
NUMERIC |
email_reminder_sent |
BOOLEAN |
outlook_id |
STRING |
sequence |
NUMERIC |
contact_name |
STRING |
contacts |
RECORD |
parent_name |
STRING |
accept_status_users |
STRING |
internal_notes |
STRING |
contact_id |
STRING |
repeat_type |
STRING |
repeat_interval |
NUMERIC |
repeat_dow |
STRING |
repeat_until |
STRING |
repeat_count |
NUMERIC |
repeat_selector |
STRING |
repeat_days |
STRING |
repeat_ordinal |
STRING |
repeat_unit |
STRING |
repeat_parent_id |
STRING |
recurrence_id |
STRING |
recurring_source |
STRING |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
type_of_meeting_c |
STRING |
_module |
STRING |
contacts
Purpose: This API is used to fetch all the contacts associated in the account
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
salutation |
STRING |
first_name |
STRING |
last_name |
STRING |
full_name |
STRING |
title |
STRING |
facebook |
STRING |
twitter |
STRING |
googleplus |
STRING |
department |
STRING |
do_not_call |
BOOLEAN |
phone_home |
STRING |
phone_mobile |
STRING |
phone_work |
STRING |
phone_other |
STRING |
phone_fax |
STRING |
primary_address_street |
STRING |
primary_address_street_2 |
STRING |
primary_address_street_3 |
STRING |
primary_address_city |
STRING |
primary_address_state |
STRING |
primary_address_postalcode |
STRING |
primary_address_country |
STRING |
alt_address_street |
STRING |
alt_address_street_2 |
STRING |
alt_address_street_3 |
STRING |
alt_address_city |
STRING |
alt_address_state |
STRING |
alt_address_postalcode |
STRING |
alt_address_country |
STRING |
assistant |
STRING |
assistant_phone |
STRING |
picture |
STRING |
email_and_name1 |
STRING |
lead_source |
STRING |
account_name |
STRING |
accounts |
RECORD |
account_id |
STRING |
dnb_principal_id |
STRING |
opportunity_role_fields |
STRING |
opportunities |
RECORD |
opportunity_role_id |
STRING |
opportunity_role |
STRING |
reports_to_id |
STRING |
report_to_name |
STRING |
reports_to_link |
RECORD |
birthdate |
STRING |
portal_name |
STRING |
portal_active |
BOOLEAN |
portal_app |
STRING |
portal_user_company_name |
STRING |
preferred_language |
STRING |
cookie_consent |
BOOLEAN |
cookie_consent_received_on |
STRING |
business_center_name |
STRING |
business_centers |
RECORD |
business_center_id |
STRING |
dp_consent_last_updated |
DATE |
campaign_id |
STRING |
campaign_name |
STRING |
campaign_contacts |
RECORD |
c_accept_status_fields |
STRING |
calls |
RECORD |
m_accept_status_fields |
STRING |
meetings |
RECORD |
accept_status_id |
STRING |
accept_status_name |
STRING |
accept_status_calls |
STRING |
accept_status_meetings |
STRING |
accept_status_messages |
STRING |
hint_account_size |
STRING |
hint_account_industry |
STRING |
hint_account_location |
STRING |
hint_account_description |
STRING |
hint_industry_tags |
STRING |
hint_account_founded_year |
STRING |
hint_account_facebook_handle |
STRING |
hint_account_twitter_handle |
STRING |
hint_account_logo |
STRING |
hint_contact_pic |
STRING |
hint_photo |
STRING |
hint_phone_1 |
STRING |
hint_phone_2 |
STRING |
hint_account_website |
STRING |
hint_account_naics_code_lbl |
STRING |
hint_account_sic_code_label |
STRING |
hint_account_fiscal_year_end |
STRING |
hint_account_annual_revenue |
STRING |
geocode_status |
STRING |
sync_contact |
BOOLEAN |
market_interest_prediction_score |
STRING |
mkto_sync |
BOOLEAN |
entry_source |
STRING |
site_user_id |
STRING |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
email |
RECORD |
email1 |
STRING |
email2 |
STRING |
invalid_email |
BOOLEAN |
email_opt_out |
BOOLEAN |
email_addresses_non_primary |
STRING |
source_id |
STRING |
source_type |
STRING |
source_meta |
STRING |
denorm_account_name |
STRING |
last_activity_date_c |
DATE |
prosperworks_id_c |
STRING |
contact_status_c |
STRING |
interaction_count_c |
NUMERIC |
create_opportunity_c |
STRING |
linkedin_c |
STRING |
lead_created_c |
STRING |
_module |
STRING |
cases
Purpose: This API is used to fetch all the cases associated with the given account
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
case_number |
NUMERIC |
type |
STRING |
status |
STRING |
priority |
STRING |
resolution |
STRING |
work_log |
STRING |
follow_up_datetime |
TIMESTAMP |
widget_follow_up_datetime |
STRING |
resolved_datetime |
STRING |
pending_processing |
BOOLEAN |
account_name |
STRING |
accounts |
RECORD |
account_id |
STRING |
service_level |
STRING |
business_center_name |
STRING |
business_centers |
RECORD |
business_center_id |
STRING |
source |
STRING |
request_close |
BOOLEAN |
request_close_date |
STRING |
portal_viewable |
BOOLEAN |
widget_status |
STRING |
primary_contact_name |
STRING |
case_contact |
RECORD |
primary_contact_id |
STRING |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
source_id |
STRING |
source_type |
STRING |
source_meta |
STRING |
first_response_target_datetime |
STRING |
first_response_actual_datetime |
STRING |
first_response_sla_met |
STRING |
first_response_user_id |
STRING |
first_response_user_name |
STRING |
first_response_user_link |
RECORD |
first_response_sent |
BOOLEAN |
is_escalated |
BOOLEAN |
denorm_account_name |
STRING |
type_other_details_c |
STRING |
cases_cases_1_name |
STRING |
cases_cases_1_right |
RECORD |
cases_cases_1cases_ida |
STRING |
order_number_c |
STRING |
carrier_c |
STRING |
subcategory_c |
STRING |
in_progress_status_c |
STRING |
product_temp_class_c |
STRING |
root_cause_c |
STRING |
closed_reason_other_c |
STRING |
closed_reason_c |
STRING |
category_c |
STRING |
_module |
STRING |
calendar
Purpose: This API is used to fetch all the calendar details for the given account
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
subject |
STRING |
calendar_module |
STRING |
event_start |
STRING |
event_end |
STRING |
duration_minutes |
STRING |
duration_hours |
STRING |
duration_days |
STRING |
calendar_type |
STRING |
color |
STRING |
dblclick_event |
STRING |
allow_create |
BOOLEAN |
allow_update |
BOOLEAN |
allow_delete |
BOOLEAN |
event_tooltip_template |
STRING |
day_event_template |
STRING |
week_event_template |
STRING |
month_event_template |
STRING |
agenda_event_template |
STRING |
timeline_event_template |
STRING |
schedulermonth_event_template |
STRING |
ical_event_template |
STRING |
calendar_filter |
STRING |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
_module |
STRING |
emails
Purpose: This API is used to fetch all the emails for the given credentials
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
deleted |
BOOLEAN |
from_addr_name |
STRING |
to_addrs_names |
STRING |
description_html |
STRING |
description |
STRING |
date_sent |
TIMESTAMP |
message_id |
STRING |
message_uid |
STRING |
name |
STRING |
type |
STRING |
status |
STRING |
flagged |
BOOLEAN |
reply_to_status |
BOOLEAN |
intent |
STRING |
mailbox_id |
STRING |
mailbox_name |
STRING |
mailbox |
RECORD |
state |
STRING |
reply_to_id |
STRING |
parent_name |
STRING |
parent |
RECORD |
parent_type |
STRING |
parent_id |
STRING |
direction |
STRING |
total_attachments |
NUMERIC |
sync_key |
STRING |
my_favorite |
BOOLEAN |
following |
BOOLEAN |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
_acl |
RECORD |
_module |
STRING |
product_catalog
Purpose: This API is used to fetch all the product catalogs for the given credentials
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
type_id |
STRING |
manufacturer_id |
STRING |
manufacturer_name |
STRING |
manufacturer_link |
RECORD |
category_id |
STRING |
category_name |
STRING |
category_link |
RECORD |
type_name |
STRING |
type_link |
RECORD |
mft_part_num |
STRING |
vendor_part_num |
STRING |
date_cost_price |
STRING |
cost_price |
STRING |
discount_price |
STRING |
list_price |
STRING |
cost_usdollar |
STRING |
discount_usdollar |
STRING |
list_usdollar |
STRING |
status |
STRING |
tax_class |
STRING |
active_status |
STRING |
date_available |
STRING |
website |
STRING |
support_name |
STRING |
support_description |
STRING |
support_contact |
STRING |
support_term |
STRING |
pricing_formula |
STRING |
service_duration_unit |
STRING |
renewable |
BOOLEAN |
service |
BOOLEAN |
lock_duration |
BOOLEAN |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
currency_id |
STRING |
base_rate |
STRING |
currency_name |
STRING |
currencies |
RECORD |
currency_symbol |
STRING |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
_module |
STRING |
tags
Purpose: This API is used to fetch all the tags for the given account
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
name_lower |
STRING |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
source_id |
STRING |
source_type |
STRING |
source_meta |
STRING |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
_module |
STRING |
purchases
Purpose: This API is used to fetch all the purchases for the given credentials
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
start_date |
DATE |
end_date |
DATE |
service |
BOOLEAN |
total_revenue |
STRING |
total_quantity |
NUMERIC |
pli_count |
NUMERIC |
renewable |
BOOLEAN |
product_template_id |
STRING |
product_template_name |
STRING |
product_templates |
RECORD |
account_name |
STRING |
accounts |
RECORD |
account_id |
STRING |
type_id |
STRING |
type_name |
STRING |
product_types |
RECORD |
category_id |
STRING |
category_name |
STRING |
categories |
RECORD |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
currency_id |
STRING |
base_rate |
STRING |
currency_name |
STRING |
currencies |
RECORD |
currency_symbol |
STRING |
_module |
STRING |
tasks
Purpose: This API is used to fetch all the tasks for the given credentials
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
status |
STRING |
date_due_flag |
BOOLEAN |
date_due |
TIMESTAMP |
time_due |
STRING |
date_start_flag |
BOOLEAN |
date_start |
TIMESTAMP |
parent_type |
STRING |
parent_name |
STRING |
parent |
RECORD |
parent_id |
STRING |
contact_id |
STRING |
contact_name |
STRING |
contacts |
RECORD |
contact_phone |
STRING |
contact_email |
STRING |
priority |
STRING |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
update_status_button_c |
STRING |
_module |
STRING |
calls
Purpose: This API is used to fetch all the calls for the given credentials
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
internal_notes |
STRING |
duration_hours |
NUMERIC |
duration_minutes |
NUMERIC |
date_start |
TIMESTAMP |
date_end |
TIMESTAMP |
parent_type |
STRING |
parent_name |
STRING |
email_reminder_checked |
STRING |
email_reminder_time |
NUMERIC |
email_reminder_sent |
BOOLEAN |
outlook_id |
STRING |
accept_status |
STRING |
set_accept_links |
STRING |
contact_name |
STRING |
contacts |
RECORD |
lead_id |
STRING |
leads |
RECORD |
lead_name |
STRING |
accept_status_users |
STRING |
contact_id |
STRING |
repeat_type |
STRING |
repeat_interval |
NUMERIC |
repeat_dow |
STRING |
repeat_until |
STRING |
repeat_count |
NUMERIC |
repeat_selector |
STRING |
repeat_days |
STRING |
repeat_ordinal |
STRING |
repeat_unit |
STRING |
repeat_parent_id |
STRING |
recurrence_id |
STRING |
recurring_source |
STRING |
transcript |
STRING |
aws_contact_id |
STRING |
call_recording_url |
STRING |
call_recording |
STRING |
aws_lens_data |
STRING |
sentiment_score_agent_string |
STRING |
sentiment_score_customer_string |
STRING |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
call_type_c |
STRING |
contact_c |
STRING |
next_steps_c |
STRING |
_module |
STRING |
notes
Purpose: This API is used to fetch all the notes for the given credentials
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
file_mime_type |
STRING |
file_ext |
STRING |
file_source |
STRING |
file_size |
NUMERIC |
file_url |
STRING |
filename |
STRING |
upload_id |
STRING |
email_type |
STRING |
email_id |
STRING |
note_parent_id |
STRING |
parent_type |
STRING |
parent_id |
STRING |
contact_id |
STRING |
portal_flag |
BOOLEAN |
embed_flag |
BOOLEAN |
parent_name |
STRING |
parent |
RECORD |
contact_name |
STRING |
contact |
RECORD |
contact_phone |
STRING |
contact_email |
STRING |
account_id |
STRING |
opportunity_id |
STRING |
acase_id |
STRING |
lead_id |
STRING |
product_id |
STRING |
quote_id |
STRING |
user_name |
STRING |
external_user |
RECORD |
external_id |
STRING |
entry_source |
STRING |
attachment_flag |
BOOLEAN |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
source_id |
STRING |
source_type |
STRING |
source_meta |
STRING |
_module |
STRING |
purchased_line_items
Purpose: This API is used to fetch all the purchased line items for the given credentials
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Data Type |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
annual_revenue |
STRING |
book_value_usdollar |
STRING |
cost_price |
STRING |
cost_usdollar |
STRING |
date_closed |
DATE |
date_closed_timestamp |
NUMERIC |
deal_calc |
STRING |
deal_calc_usdollar |
STRING |
discount_amount |
STRING |
discount_amount_signed |
STRING |
discount_amount_usdollar |
NUMERIC |
discount_price |
STRING |
discount_select |
BOOLEAN |
discount_usdollar |
STRING |
list_usdollar |
STRING |
mft_part_num |
STRING |
revenue |
STRING |
revenue_usdollar |
STRING |
total_amount |
STRING |
subtotal |
STRING |
category_id |
STRING |
category_name |
STRING |
categories |
RECORD |
manufacturer_id |
STRING |
manufacturer_name |
STRING |
manufacturer |
RECORD |
product_template_id |
STRING |
product_template_name |
STRING |
product_templates |
RECORD |
lock_duration |
BOOLEAN |
product_type_id |
STRING |
product_type_name |
STRING |
product_type |
RECORD |
purchase_id |
STRING |
purchase_name |
STRING |
purchase |
RECORD |
revenuelineitem_id |
STRING |
revenuelineitem_name |
STRING |
revenuelineitem |
RECORD |
account_id |
STRING |
account_name |
STRING |
account_link |
RECORD |
status |
STRING |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
asset_number |
STRING |
book_value |
STRING |
book_value_date |
STRING |
date_purchased |
STRING |
date_support_expires |
STRING |
date_support_starts |
STRING |
list_price |
STRING |
pricing_formula |
STRING |
quantity |
NUMERIC |
serial_number |
STRING |
renewable |
BOOLEAN |
service |
BOOLEAN |
service_duration_value |
NUMERIC |
service_duration_unit |
STRING |
catalog_service_duration_unit |
STRING |
service_duration_multiplier |
NUMERIC |
service_end_date |
DATE |
service_start_date |
DATE |
support_contact |
STRING |
support_description |
STRING |
support_name |
STRING |
support_term |
STRING |
tax_class |
STRING |
vendor_part_num |
STRING |
website |
STRING |
renewal |
BOOLEAN |
currency_id |
STRING |
base_rate |
STRING |
currency_name |
STRING |
currencies |
RECORD |
currency_symbol |
STRING |
denorm_account_name |
STRING |
_module |
STRING |
calculated_fields_updater_queue
Purpose: This API is used to fetch all the calculated fields updater queue for the given credentials
Replication: Key Based Incremental
Replication Key: date_modified
Fields
| Name | Text |
id |
STRING |
name |
STRING |
date_entered |
TIMESTAMP |
date_modified |
TIMESTAMP |
modified_user_id |
STRING |
modified_by_name |
STRING |
modified_user_link |
RECORD |
created_by |
STRING |
created_by_name |
STRING |
created_by_link |
RECORD |
description |
STRING |
deleted |
BOOLEAN |
target_module |
STRING |
parent_name |
STRING |
parent |
RECORD |
parent_type |
STRING |
parent_id |
STRING |
record_state |
STRING |
processed_date |
TIMESTAMP |
pre_update_record_structure |
STRING |
post_update_record_structure |
STRING |
queue_number |
NUMERIC |
processed_fields |
STRING |
wcfu_config_name |
STRING |
wsys_wcfuconfigs_wsys_wcfuqueue |
RECORD |
wcfu_config_id |
STRING |
wcfu_log_name |
STRING |
wsys_wcfulogs_wsys_wcfuqueue |
RECORD |
wcfu_log_id |
STRING |
db_parent_name |
STRING |
following |
BOOLEAN |
my_favorite |
BOOLEAN |
sync_key |
STRING |
team_count |
STRING |
team_count_link |
RECORD |
team_name |
RECORD |
assigned_user_id |
STRING |
assigned_user_name |
STRING |
assigned_user_link |
RECORD |
wsys_wcfuconfigs_wsys_wcfuqueue_name |
STRING |
wsys_wcfuconfigs_wsys_wcfuqueuewsys_wcfuconfigs_ida |
STRING |
wsys_wcfulogs_wsys_wcfuqueue_name |
STRING |
wsys_wcfulogs_wsys_wcfuqueuewsys_wcfulogs_ida |
STRING |
_module |
STRING |
