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

1. Sign in to Daton

2. Select SugarCRM from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. In the next step you will be asked to enter sugar CRM site url, sugar CRM username and password

5. Post successful authentication you will be prompted to choose required tables from the list

6. Then select all required fields

7. Submit the integration

Workflow

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

2. Users would be able to edit/pause/re-activate/delete integration anytime

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