Main Export Fields
Threads(Export::ContentThreads
)
-
Export name: threads
-
Incremental availability: Yes
-
Time filtering: Creation time, Last content time
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
id | ID | ObjectId | 523ffffb7aa58d1b6700000f | |
foreign_id | External ID | String | 102423 | |
source_id | Source ID | ObjectId | 523ffffb7aa58d1b6700000f | |
source_type | Source type | String | ||
source_name | Source Name | String | My Facebook Page | |
created_at | Creation date | Datetime | 23/09/2013 18:23 | |
updated_at | Update date | Datetime | 23/09/2013 20:45 | |
closed | Thread locking status | Boolean | true | |
first_categorization_at | Date of first categorization | Datetime | 24/09/2013 19:00 | |
last_content_id | ID of last message | String | 5240b1bca90ffbb6c7000006 | |
last_content_at | Date of last content | Datetime | 24/09/2013 19:00 | |
title | Title | String | How can I unlock my simcard ? | Sensitive |
contents_count | Messages count | Integer | 12 | |
all_categories | Categories | Array | Mobile, Adsl, TV | |
categories | Categories | Array | Mobile, Adsl, TV | Contains only global categories of the thread |
first_content_id | ID of first message | String | 5240b1bca90ffbb6c7000006 | |
first_content_author_id | ID of first message author | String | 5240b1bca90ffbb6c7000006 | |
languages | Languages | Array | fr, en | |
interventions_count | Interventions count | Integer | 4 | |
intervention_user_ids | Agents IDs | Array | 5240b1bca90ffbb6c7000006, 4340b1bca90debb6c7003333 | |
opened_intervention_user_ids | Active agents IDs | Array | 5240b1bca90ffbb6c7000006, 4340b1bca90debb6c7003333 | |
ratings | Rating of individual messages in the thread, uniquified | Array | 1, 3 , 4, 5 |
Optional fields
Other custom data can be present in the thread export depending on the source type, which will result in additional columns in the export.
Source Chat
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
trigger_id | Trigger ID | ObjectId | 54e1fb7077656269ea110200 | Sensitive |
trigger_name | Trigger name | String | Chat Button | Sensitive |
close_cause | Close cause | String | visitor_closed | Sensitive Possible values :
|
closed_at | Time of chat closing | Datetime | 8/5/2016 14:29:45 | Sensitive |
page_title | Page title | String | Activity and Sleep Wristband | Sensitive |
page_url | Page URL | String | http://example.com/ | Sensitive |
page_visit_count | Page visit count | Integer | 4 | Sensitive |
page_visit_started_at | Page visit start time | Timestamp | 1470400259 | Sensitive |
visit_count | Website visit count | Integer | 21 | Sensitive |
visit _started_at | Website visit start time | Timestamp | 1470399681 | Sensitive |
{custom_variable_name} | Chat custom variable | Depends on the chat custom variable type | 12 | Sensitive Columns corresponding to the chat custom variables will also be available |
intervention_user_names | Agent user names | Array | John Doe, Leo Major | Sensitive |
| opened_intervention_user_names | Active agent user names | Array | John Doe, Leo Major | Sensitive |
Message(Export::Contents
)
-
Export name: messages
-
Incremental availability: Yes
-
Time filtering: Creation time
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
created_at | Creation date | Datetime | 20/09/2013 13:15 | Creation date on the source |
source_id | Source ID | ObjectId | 193731f8a90ffbd442000b2a | |
source_type | Source type | String | Dimelo Answers | |
source_name | Source Name | String | My Assistance | |
content_thread_id | Thread id | ObjectId | 512631f8a90ffbd442000037 | |
type | Type | String | Réponse publique | |
id | ID | ObjectId | abc631f8a9b24d442002397 | |
private_message | Private message ? | Boolean | true / false (or 1 / 0 for BI) | |
created_from | Created from | String | Synchronizer | |
auto_submitted | Auto submitted | Boolean | true / false (or 1 / 0 for BI) | If true, it means the message is an automatic reply: ask a user to follow (twitter), send a survey to a customer,... |
status | Status | String | New | Possible values :
|
ignored_from | Archived by | String | Ice | Possible values :
|
categories | Categories | Array | Mobile, Adsl, TV | |
intervention_id | Intervention id | ObjectId | 512631f8a90ffbd442000037 | |
initial_created_at | Initial creation date | Datetime | 20/09/2013 13:15 | Creation date in Dimelo database |
creator_id | Creator id | ObjectId | 512631f8a90ffbd442000037 | ID of the agent that created the message |
creator_name | Creator name | String | Jack Dupont | Name of the agent that created the message |
author_id | Author ID | ObjectId | 512631f8a90ffbd442000037 | ID of the identity author of the message |
author_name | Author Name | String | Michelle Michu | Sensitive Name of the identity author of the message |
anonymized | Right to be forgotten used | Boolean | true | Sensitive |
body | Message | Text | Hi, I need help to unlock my sim card, how can I do it ? | Sensitive |
body_as_text | Message | Text | Hi, I need help to unlock my sim card, how can I do it ? | Sensitive |
body_as_html | Message in HTML format | Text | Hi, I need help to unlock my sim card, how can I do it ? |
Sensitive |
title | Title | String | How can I unlock my simcard ? | Sensitive |
foreign_categories | External categories | Array | Orange mobile, Unlock Simcard, | e.g. forum room for Lithium, Dimelo communities categories … |
foreign_id | External ID | String | ‘1234’ | |
rating | Rating of the message (for reviews) | Integer | 3 | |
published | Message has been published | Boolean | true | |
approval_required | When user reply, his answers will need approval by supervisor | Boolean | false | |
remotely_deleted | Message has been deleted on the source | Boolean | false | |
language | Detected language | String | fr | Format is ISO 369-1 |
in_reply_to_id | Source ID | ObjectId | 523ffffb7aa58d1b6700000f | |
in_reply_to_author_id | Source ID | ObjectId | 523ffffb7aa58d1b6700000f | |
attachments_count | Number of attachments | Integer | 1 | |
structured_reply_payload | Payload of the structured reply | String | my_payload | Sensitive |
synchronization_status | Synchronization status of the message | String | success | Possible values :
|
synchronization_error | Error message if the synchronization failed or has been aborted | String | hard_bounce - The server was unable to deliver your message (ex: unknown user, mailbox not found). | This field is the concatenation of content.synchronization_error and content.synchronization_error_custom fields |
Journal(Exports::Events
)
-
Export name: journal
-
Incremental availability: Yes
-
Time filtering: Creation time
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
id | Event ID | ObjectId | 512631f8a90ffbd442000037 | |
created_at | Creation date | Datetime | 20/09/2013 13:15 | |
user_id | Agent id | ObjectId | 512631f8a90ffbd442000037 | |
user_name | Agent | String | Adrien Jarthon | |
name | Name | String | content.replied | |
message | Message | Text | Adrien Jarthon a répondu à Sébastien Luquet | Sensitive |
content_thread_id | Thread ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
content_source _id | Source ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
intervention_id | Intervention ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
content_id | Content ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
category_ids | Categories IDs | Array | 5240b1bca90ffbb6c7000006, 4340b1bca90debb6c7003333 | |
task_id | Task ID | ObjectId | 4f4f3a08a90ffb27ee000583 | Sensitive See the full list of events below |
action | Optional field describing the action leading to the event | String | deferred | Sensitive |
step | Task topology step when it expired | String | realtime_default_target | |
rules_engine_rule_id | ID of the Rule which triggered the event | ObjectId | 5a4bbf3713047d6d123061d0 | Sensitive |
entry_id | Reply Assistant Entry ID | ObjectId | 5a4bbf3713047d6d123061d0 | Sensitive |
version_id | Reply Assistant Version ID | ObjectId | 5a4bbf3713047d6d123061d0 | Sensitive |
List of events containing a task_id
:
- Task assigned
- Task completed
- Task moved to queue
- Task timed out
- Task expired in an agent's inbox
- Task priority update from a rule
- Task priority update (only one that doesn't have the
task_id
in it) - Task resumed by an agent
- Task manually assigned to an agent by a supervisor
- Task accepted
- Task transferred
Sources(Export::ContentSources
)
-
Export name: sources
-
Incremental availability: No
-
Time filtering: Creation time
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
created_at | Creation date | Datetime | 23/08/2013 12:15 | |
updated_at | Update Date | Datetime | 23/08/2013 12:15 | |
id | ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
active | Active | Boolean | ||
name | Name | String | Twitter Search Domain Test | |
status | Status | String | ok, error, … | |
community_type | Community Type | String | Dimelo Users | |
community | Community | String | Domain Test | |
content_archiving | Content Archiving | Boolean | ||
auto_detect_content_language | Auto Detect Content Language | Boolean | ||
default_content_language | Default Content Language | String | en | |
content_signature | Content Signature | String | ||
hidden_from_stats | Hidden From Stats | Boolean | ||
default_task_priority | Default task priority | Integer | 1 | |
channel_id | Channel ID | ObjectId | 55794bda416472d4e8060000 | |
channel_name | Channel Name | String | Chat | |
sla_expired_strategy | SLA Expired Strategy | String | Max | |
sla_response | SLA Response | Integer | 0 | |
intervention_messages_boost | Intervention Messages Boost | Integer | 9 | |
private_messages_supported | Private Messages Supported | Boolean | ||
fb_app_id | Facebook App ID | String | Extra (facebook) | |
fb_page_id | Facebook Page ID | String | Extra (facebook) | |
synchronize_messages | Synchronize Messages | Boolean | Extra (facebook) | |
synchronize_posts | Synchronize Posts | Boolean | Extra (facebook) | |
synchronize_dark_posts | Synchronize Dark Posts | Boolean | Extra (facebook) | |
page_id | Page ID | String | Extra (google plus) | |
domain_name | Domain Name | String | Extra (ideas, answers) | |
facebook_app_id | Facebook App ID | String | Extra (answers) | |
facebook_page_id | Facebook Page ID | String | Extra (answers) | |
String | Extra (email) | |||
from_email | From Email | String | Extra (email) | |
open_tracking_enabled | Open Tracking Enabled | Boolean | Extra (email) | |
instagram_business_account_id | Business Account ID (Instagram) | String | Extra (instagram) | |
abuse_only | Abuse Only | Boolean | Extra (lithium) | |
url | URL | String | Extra (lithium, rightnow, tapatalk) | |
application | Application | String | Extra (mobile messaging) | |
notification_generic_message | Notification Generic Message | String | Extra (mobile messaging) | |
disable_notification_body_display | Disable Notification Body Display | Boolean | Extra (mobile messaging) | |
from_name | Sender Alias | String | Extra (nexmo, chat, mobile messaging). Originally called inbound_number for Nexmo sources | |
phone_number | Sender Phone Number | String | Extra (RingCentral SMS OTT) | |
ott_type | OTT Type | String | Extra (nexmo OTT) | |
ott_account_id | OTT Account ID | String | Extra (nexmo OTT) | |
base_uri | Base URI | String | Extra (SDK) | |
readable_from_metas | Readable From Metas | Array | Extra (tapatalk) | |
readable_from_ids | Readable From IDs | Array | Extra (tapatalk) | |
twitter_id | Twitter ID | String | Extra (twitter) | |
twitter_uuid | Twitter UUID | String | Extra (twitter) | |
main_source_id | Main Source ID | ObjectId | Extra (twitter search) | |
searches | Searches | Array | Extra (twitter search) |
Identities(Export::Identities
)
-
Export name: identities
-
Incremental availability: Yes
-
Time filtering: Creation time, Update time
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
created_at | Creation date | Datetime | 23/08/2013 12:15 | |
updated_at | Last update date | Datetime | 23/08/2013 12:15 | |
community_type | Community type | String | Tapatalk | |
community | Community | String | Forum LesMobiles | |
puppet | Controlled | Boolean | true | |
id | ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
uuid | UUID | String | ‘1234’ | Often same value as foreign_id |
foreign_id | External ID | String | ‘1234’ | |
screenname | Screen name | String | Pierre Dupont | Sensitive |
firstname | Firstname | String | Pierre | Sensitive |
lastname | Lastname | String | Dupont | Sensitive |
String | pierredupont@gmail.com | Sensitive | ||
home_phone | Home phone | String | 0136656565 | Sensitive |
mobile_phone | Mobile phone | String | 0636656565 | Sensitive |
address | Address | String | 32 rue de Trévise | Sensitive |
city | City | String | Paris | Sensitive |
anonymized | Right to be forgotten used | Boolean | true | Sensitive |
tags | Tags | Array | VIP, Important | |
identity_group_id | ID | ObjectId | 571648194379720b53000048 | |
company | Company name | String | Apple | Sensitive From Identity Group |
emails | Emails | Array | [steve.jobs@apple.com, steve@me.com] | Sensitive From Identity Group |
home_phones | Home Phones | Array | [415-323-1232] | Sensitive From Identity Group |
mobile_phones | Mobile Phones | Array | [415-321-2321] | Sensitive From Identity Group |
tw_followers_count | People following the identity | Integer | 543 | Extra (twitter) updated only when there is a new tweet from the user |
tw_following_count | People the identity follows | Integer | 865 | Extra (twitter) updated only when there is a new tweet from the user |
tw_statuses_count | Number of tweets | Integer | 1023 | Extra (twitter) updated only when there is a new tweet from the user |
tw_location | User's location | String | Paris | Extra (twitter) updated only when there is a new tweet from the user |
ig_followers_count | People following the identity | Integer | 395 | Extra (Instagram) updated only when there is a new message from the user |
dimelo_type | DC Account type | String | Extra (DC) | |
dimelo_custom_field_1 (up to 10) | DC custom fields | String | 01 23 45 67 89 | Extra (DC) |
fb_bio | Facebook bio | String | Painter living in Paris | Extra (facebook) updated only when there is a new message from the user |
fb_category | Facebook category | String | Computers/Internet | Extra (facebook) updated only when there is a new message from the user |
fb_locale | Facebook locale | String | fr_FR | Extra (facebook) updated only when there is a new message from the user |
mobile_device_info | DM device info | String | motorola Nexus 6; 6.0 | Extra (DM) updated when the DM isinitialized by the host app |
mobile_authenticated | DM is the user authenticated? | Boolean | true | Extra (DM) updated when the DM is initialized by the host app |
ott_type | OTT provider | String | Extra (wechat, line...) |
IdentityGroup(Export:IdentityGroup
)
-
Export name: identity_groups
-
Incremental availability: Yes
-
Time filtering: Creation time, Update time
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
created_at | Creation date | Datetime | 23/08/2013 12:15 | |
updated_at | Last update date | Datetime | 23/08/2013 12:15 | |
id | ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
firstname | Firstname | String | Steve | Sensitive |
lastname | Lastname | String | Jobs | Sensitive |
company | Company name | Apple | Sensitive | |
gender | man | Sensitive Possible values:
|
||
emails | Emails | Array | [steve.jobs@apple.com, steve@me.com] | Sensitive |
home_phones | Home phones | Array | [415-323-1232] | Sensitive |
mobile_phones | Mobile phones | Array | [415-321-2321] | Sensitive |
notes | Notes | Text | Iphone 6 IMEI | Sensitive |
tag_ids | Tag Ids | Array | ["4ff17af67aa58d052300376d"] | Array of tag ids associated |
identity_ids | Identity ids | Array | ["4fc636d30f4ca1670400000c"] | Array of identity ids associated |
Interventions(Export::Interventions
)
-
Export name: interventions
-
Incremental availability: Yes
-
Time filtering: Creation time, Update time
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
created_at | Creation date | Datetime | 23/08/2013 12:15 | |
updated_at | Last update date | Datetime | 23/08/2013 12:15 | |
closed_at | Close Date | Datetime | 30/04/2016 15:10 | Date of last agent reply (=last_user_reply_at), and not when the intervention was closed by clicking the Solve button |
closed_automatically | Closed Automatically | String | chat_disconnected | |
source_id | Source ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
source_type | Source type | String | Tapatalk | |
source_name | Source name | String | Forum LesMobiles | |
content_thread_id | Thread id | ObjectId | 4f4f3a08a90ffb27ee000583 | |
id | ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
status | Status | String | Opened | Possible values :
|
deferred_at | Deferred Datetime | Datetime | 27/08/2013 08:32 | Date which intervention has been postponed to |
user_id | Agent ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
user_name | Agent name | String | Pierre Dupont | Firstname Lastname |
user_replies_count | Replies count | Integer | 3 | |
user_private_replies_count | Private replies count | Integer | 1 | |
user_public_replies_count | Public replies count | Integer | 2 | |
first_identity_content_id | First Identity Content ID | ObjectId | 2c1c3c08a90ffb27ee000113 | |
first_user_reply_id | First Agent Reply ID | ObjectId | cc223b08a90ffb27ee001252 | |
first_user_reply_at | First reply date | String | 24/08/2013 00:08 | |
last_user_reply_at | Last reply date | String | 27/08/2013 08:32 | |
last_user_reply_in | Intervention duration (minutes or seconds according to configuration) | Integer | 1400 | |
last_user_reply_in_bh | Intervention duration in business hours (minutes or seconds according to configuration) | Integer | 1400 | |
first_user_reply_in | First reply time (minutes or seconds according to configuration) | Integer | 4 | |
first_user_reply_in_bh | First reply time in business hours (minutes or seconds according to configuration) | Integer | 4 | |
handling_time | Total time spent in push on the task when active (seconds) | Integer | 87 | |
title | Message title | String | Where is my order ? | |
identity_id | Identity ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
identity_name | Identity name | String | pdupont | |
identity_contents_count | Identity messages count | Integer | 200 | |
identity_private_contents_count | Identity private messages count | Integer | 30 | |
identity_public_contents_count | Identity public messages count | Integer | 170 | |
categories | Categories | Array | simcard, mobile | |
comments_count | Comments count | Integer | 30 | |
user_reply_in_average | Average agent reply time (minutes or seconds according to configuration) | Integer | 3 | |
user_reply_in_average_bh | Average agent reply time in business hours (minutes or seconds according to configuration) | Integer | 2 | |
user_reply_in_average_count | Number of exchanges between Identity -> User (used to weight user_reply) | Integer | 3 |
TaskSelectionActivity(Export::TaskSelectionActivities
)
-
Export name: task_selection_activities
-
Incremental availability: Yes
-
Time filtering: Begin date, End date
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
id | TaskSelectionActivity ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
created_at | Creation date | Datetime | 23/08/2013 12:15 | |
start | Datetime | Datetime | 23/08/2013 12:15 | |
end | Datetime | Datetime | 23/08/2013 12:15 | |
duration | Duration | Integer | 12 | |
user_name | Agent name | String | Pierre Dupont | |
user_id | Agent ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
task_id | Task ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
category_ids | Category IDs | Array | 5240b1bca90ffbb6c7000006, 4340b1bca90debb6c7003333 | |
intervention_id | Intervention ID | ObjectId | 4340b1bca90debb6c7003333 | |
source_id | Source ID | ObjectId | 4340b1bca90debb6c7003333 |
Presence Time
-
Export name: presence_time
-
Incremental availability: Yes
-
Time filtering: Creation time
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
date | Date | Date | 27/08/2013 | |
user_id | Agent id | ObjectId | 4f4f3a08a90ffb27ee000583 | |
user_name | Agent | String | Pierre Dupont | |
activity | Activity time | Integer | Float | 6,67 | In seconds (Integer) or hours (Float) depending on the “Export in seconds” setting |
presence | Presence time | Integer | Float | 10,47 | In seconds (Integer) or hours (Float) depending on the “Export in seconds” setting |
{channel}_available | Time spent available | Integer | Float | 0 | In seconds (Integer) or hours (Float) depending on the “Export in seconds” setting |
{channel}_away | Time spent away | Integer | Float | 0,63 | In seconds (Integer) or hours (Float) depending on the “Export in seconds” setting |
{channel}_busy | Time spent busy | Integer | Float | 6,39 | In seconds (Integer) or hours (Float) depending on the “Export in seconds” setting |
{channel}_full | Time spent full | Integer | Float | 3,66 | In seconds (Integer) or hours (Float) depending on the “Export in seconds” setting |
{channel}_unoccupied | Time spent unoccupied | Integer | Float | 0,04 | In seconds (Integer) or hours (Float) depending on the “Export in seconds” setting |
{channel}_active_total | Time spent active (available + busy + full) | Integer | Float | 10,05 | In seconds (Integer) or hours (Float) depending on the “Export in seconds” setting |
{channel}_available_total | Time spent available (available + busy + full + unoccupied) | Integer | Float | 10,09 | In seconds (Integer) or hours (Float) depending on the “Export in seconds” setting |
{channel}_away_total | Time spent away (away + custom away statuses) | Integer | Float | 1,72 | In seconds (Integer) or hours (Float) depending on the “Export in seconds” setting |
away_{custom_status_id} | Time spent under a custom away status | Integer | Float | 1,10 | In seconds (Integer) or hours (Float) depending on the “Export in seconds” setting |
Roles(Export::Roles
)
-
Export name: roles
-
Incremental availability: No
-
Time filtering: No
Column Name | Description | Type | Example / Comment |
---|---|---|---|
id | ID | ObjectId | |
label | Label | String | Administrateur, CM, …. |
admin_stamp_answer | Admin or author stamp answer | Boolean | |
access_advanced_analytics | View advanced analytics | Boolean | |
assign_intervention | Assign intervention | Boolean | |
author_block_content | Block users | Boolean | |
create_community | Create a community | Boolean | |
create_content_source | Create a source | Boolean | |
create_user | Create an agent | Boolean | |
delay_export_content | Defer content publication | Boolean | |
delete_content_thread | Delete a thread | Boolean | |
impersonate_user | Impersonate agent | Boolean | |
invite_user | Invite an agent | Boolean | |
manage_advanced_analytics | Manage advanced analytics | Boolean | |
manage_categories | Manage categories | Boolean | |
manage_folders | Manage messages folders | Boolean | |
manage_identities | Manage identities | Boolean | |
manage_roles | Manage roles | Boolean | |
manage_tags | Manage identity tags | Boolean | |
manage_teams | Manage teams | Boolean | |
manage_users_of_my_teams | Manage users of my team only | Boolean | When false, the agent related permissions (create_user, impersonate_user, invite_user, read_user, update_user) are granted for all agents. When true, they’re granted only for agents belonging to at least one of the teams the agent is leading. |
publish_content | Publish contents | Boolean | |
read_community | View communities | Boolean | |
read_content_source | View sources | Boolean | |
read_event | View journal on interface | Boolean | |
read_export | Export data | Boolean | |
read_own_stats | View own stats | Boolean | |
read_stats | View all stats | Boolean | |
read_user | View agents | Boolean | |
search_event | View journal on admin | Boolean | |
update_community | Edit a community | Boolean | |
update_content_source | Edit a source | Boolean | |
update_intervention | Edit all interventions | Boolean | |
update_own_intervention | Edit own intervention | Boolean | |
update_settings | Configure application | Boolean | |
update_user | Edit an agent | Boolean |
Categories(Export::Categories
)
-
Export name: categories
-
Incremental availability: No
-
Time filtering: No
Export of all categories for a source or all sources
Column Name | Description | Type | Example / Comment |
---|---|---|---|
created_at | Creation Date | Datetime | 23/08/2013 12:15 |
updated_at | Update Date | Datetime | 23/08/2013 12:15 |
id | ID | ObjectId | 4f4f3a08a90ffb27ee000583 |
level | Level | Integer | 1 |
mandatory | Mandatory | Boolean | |
post_qualification | Post qualification | Boolean | |
multiple | Multiple | Boolean | |
name | Name | String | Commercial |
unselectable | Not selectable | Boolean | |
parent_id | Parent ID | ObjectId | 4ffe9e4e0f4ca1545c000004 |
parent_name | Parent Name | String | Categories |
sources | Sources | Array | My Facebook Page, My Twitter |
Agents(Export::Users
)
-
Export name: agents
-
Incremental availability: Yes
-
Time filtering: Creation time
Column Name | Description | Type | Example / Comment |
---|---|---|---|
created_at | Creation Date | Datetime | 23/08/2013 12:15 |
id | ID | ObjectId | 4f4f3a08a90ffb27ee000583 |
firstname | Firstname | String | Pierre |
lastname | Lastname | String | Dupont |
nickname | Nickname | String | pierrot |
gender | Gender | String | Man |
String | pierredupont@gmail.com | ||
identities | Identities | Array | pdupont, ... |
role | Role | String | Administrateur |
teams | Teams | Array | RC Paris, RC Toulouse |
categories | Categories | Array | |
signatures | Signatures | Array | |
foreign_id | External ID | String | 427210 |
foreign_jwt_id | Foreign JWT ID | String | |
foreign_saml_id | Foreign SAML ID | String | |
enabled | Enabled | Boolean | |
no_password | No password | Boolean |
Agents Notifications(Export::UsersNotifications
)
-
Export name: agents_notifications
-
Incremental availability: No
-
Time filtering: No
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
user_id | Agent ID | ObjectId | 4f4f3a08a90ffb27ee000583 | |
user_name | Agent Name | String | Pierre Dupont | |
content_imported_in_identity_tags | New message from a tagged author | Boolean | true | |
content_imported_in_my_interventions | New message in your interventions | Boolean | true | |
content_imported_in_my_sources | New message in your sources | Boolean | false | |
content_requiring_approval | Message requiring approval | Boolean | true | |
content_thread_categorized_in_my_categories | Thread categorized in your categories | Boolean | No | |
intervention_assigned | Intervention assigned | Boolean | true | |
intervention_reactivated | Intervention is out of defer | Boolean | true |
Agents Permissions(Export::UsersPermissions
)
-
Export name: agents_permissions
-
Incremental availability: No
-
Time filtering: No
This export displays user permissions by source.
Column Name | Description | Type | Example / Comment |
---|---|---|---|
user_id | ID | ObjectId | 4f4f3a08a90ffb27ee000583 |
user_name | Agent | String | Pierre Dupont |
source_id | Source ID | ObjectId | 4f4f3a08a123af2a2e000583 |
source_type | Source Type | String | |
source_name | Source Name | String | My Facebook Page |
read | User can read messages on source | Boolean | true |
reply | User can reply messages on source | Boolean | true |
reply_with_html | User can reply messages using html | Boolean | true |
initiate_discussion | User can Initiate discussion on source | Boolean | true |
approval_required | When user reply, his answers will need approval by supervisor | Boolean | true |
destroy | User can delete messages on source | Boolean | true |
Note
A user may appear multiple times, for example a user may have different permissions on 2 different sources :
user_id | user_name | source_id | source_type | source_name | read | reply | reply_with_html | initiate_discussion | approva_required | destroy |
---|---|---|---|---|---|---|---|---|---|---|
4f4f3a08a90ffb27ee000583 | Jack Dupont | 512631f8a90ffbd442000037 | My FB | true | false | false | false | false | false | |
4f4f3a08a90ffb27ee000583 | Jack Dupont | 57def21f8a90ffbd44266663f | Dimelo Answers | My Assistance | true | true | true | true | false | false |
Interventions Comments(Export::InterventionsComments
)
-
Export name: interventions_comments
-
Incremental availability: Yes
-
Time filtering: Creation time
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
created_at | Creation Date | Datetime | 23/08/2013 12:15 | |
body | Body | String | Jack, I reassigned to you as this is your domain | Sensitive |
created_from | Created From | String | interface | |
intervention_id | Intervention ID | ObjectId | 55cdaade77656222d500061d | |
id | Intervention Comment ID | ObjectId | 55dc83d677656254ca000a2e | |
identity_id | Identity ID | ObjectId | 55cda9e6776562a644000001 | |
identity_name | Identity Name | String | Pierre Dupont | Sensitive |
source_id | Source ID | ObjectId | 55cda687776562377900083d | |
source_name | Source Name | String | My Facebook Page | |
thread_id | Thread ID | ObjectId | 55cda7bd7765622b58000735 | |
user_id | Agent Id | ObjectId | 51f241de7aa58dd360006706 | |
user_name | Agent Name | String | Jean Dupuis |
Presence Statuses(Export::PresenceStatus
)
-
Export name: presence_status
-
Incremental availability: No
-
Time filtering: No
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
created_at | Creation Date | Datetime | 23/08/2013 12:15 | |
updated_at | Update Date | Datetime | 23/08/2013 12:15 | |
id | Presence status ID | ObjectId | 55dc83d677656254ca000a2e | |
name | Presence status Name | String | Meeting |
Attachments(Export::Attachments
)
You can download the attachments by using an API access token with the following URL: https://{your-domain}.digital.ringcentral.com/attachments/{attachment_id}?access_token={your_access_token}
-
Export name: attachments
-
Incremental availability: Yes
-
Time filtering: Begin date, End date
Column Name | Description | Type | Example | Comment |
---|---|---|---|---|
created_at | Creation Date | Datetime | 23/08/2013 12:15 | |
id | Attachment ID | ObjectId | 55dc83d677656254ca000a2e | |
url | Attachment Url | String | https://domain-test.digital.ringcentral.com/attachments/59a52f3aa5aacd03d93b3151 | |
content_id | Content ID | ObjectId | 55dc83d677656254ca000a2e | |
filename | File Name | String | DJwCOLlW4AINC5g.jpg | |
embed | Embed | Boolean | true | |
virus_signature | Virus Signature | String | this is a virus | |
size | Size | Integer | 126199 | |
type | Type | String | image | |
foreign_id | Foreign ID | ObjectId | 55dc83d677656254ca000a2e | |
public | Attachment public | Boolean | true | |
attachable_id | Id of attachment | ObjectId | 38dc82c677656254ca000a2e | |
attachable_type | type of attachment | string | reply_assistant | Can be 'unknown', 'reply_assistant', 'content' |