Connector API Endpoints

This page lists the API service endpoints used by Upland BA Insight Connectors.

Connector API Version Service Endpoints/API Permissions
Box  
  • https://api.box.com/2.0/events
  • https://api.box.com/2.0/users
  • https://api.box.com/2.0/users/<userid>
  • https://api.box.com/2.0/groups
  • https://api.box.com/2.0/groups/<groupid>/memberships
  • https://api.box.com/2.0/folders/<folderid>
  • https://api.box.com/2.0/folders/<folderid>/collaborations
  • https://api.box.com/2.0/folders/<folderid>/items
  • https://api.box.com/2.0/files/<fileid>
  • https://api.box.com/2.0/files/<fileid>/content
Documentum  

Repositories:

  • /repositories

  • /repositories/{repository}/types?items-per-page={Settings.Default.PagingSize}&inline=true

  • /repositories/{repository}/objects/{i_chronicle_id}/versions/current

  • /repositories/{repository}/objects/{i_chronicle_id}/versions/current?links=False

  • /repositories/{repository}/folders/{i_folder_id}

  • /repositories/{repository}/objects/{id}/permission-set

  • /repositories/{repository}/acls/{aclId}

  • /repositories/{repository}/objects/{r_chronicle_id}/contents/content/?media-url-policy=ALL

DQL

Copy 
SELECT group_name, group_display_name FROM dm_group
SELECT group_name, users_names FROM dm_group
SELECT user_name, user_ldap_dn, user_state,user_login_name FROM dm_user WHERE r_is_group = '0'
SELECT group_name, groups_names FROM dm_group
SELECT FOR READ i_chronicle_id, r_object_id, a_content_type, r_modify_date, r_object_type FROM dm_document WHERE (r_modify_date >= DATE('01/01/1990 00:00:00 utc','dd/mm/yyyy HH:mi:ss')) ORDER BY r_modify_date ASC ENABLE ( RETURN_TOP {PageSize})
SELECT FOR READ i_chronicle_id, r_object_id, a_content_type, r_modify_date, r_object_type FROM dm_document WHERE (r_modify_date >= DATE('01/01/1990 00:00:00 utc','dd/mm/yyyy HH:mi:ss') AND {customFilter}) ORDER BY r_modify_date ASC ENABLE ( RETURN_TOP {PageSize})
SELECT name, dos_extension FROM dm_format
SELECT r_object_id FROM dm_document WHERE (i_chronicle_id = '{i_chronicle_id}') AND ({customfilter})
SELECT r_object_id, chronicle_id as i_chronicle_id, audited_obj_id, object_type, time_stamp, event_name FROM dm_audittrail WHERE (event_name = '{deleteEvent}' OR event_name = '{pruneEvent}') AND time_stamp_utc > DATE('01/01/1990 00:00:00 utc','dd/mm/yyyy HH:mi:ss') AND object_type = 'rootObject'
SELECT r_object_id, chronicle_id as i_chronicle_id, audited_obj_id, object_type, time_stamp, event_name FROM dm_audittrail WHERE (event_name = '{deleteEvent}' OR event_name = '{pruneEvent}') AND time_stamp_utc > DATE('01/01/1990 00:00:00 utc','dd/mm/yyyy HH:mi:ss') AND object_type in ({type1},{type2},etc)
SELECT r_object_id, chronicle_id as i_chronicle_id, audited_obj_id, object_type, time_stamp, event_name FROM dm_audittrail WHERE event_name = {saveEvent} AND time_stamp_utc > DATE('01/01/1990 00:00:00 utc','dd/mm/yyyy HH:mi:ss') AND object_type = 'rootObject'
SELECT r_object_id, chronicle_id as i_chronicle_id, audited_obj_id, object_type, time_stamp, event_name FROM dm_audittrail WHERE event_name = {saveEvent} AND time_stamp_utc > DATE('01/01/1990 00:00:00 utc','dd/mm/yyyy HH:mi:ss') AND object_type in ({type1},{type2},etc)
SELECT r_object_id, chronicle_id as i_chronicle_id, audited_obj_id, object_type, time_stamp, event_name FROM dm_audittrail WHERE (event_name = {deleteEvent} OR event_name = {pruneEvent} OR event_name = {saveEvent}) AND time_stamp_utc > DATE('01/01/1990 00:00:00 utc','dd/mm/yyyy HH:mi:ss') AND object_type = 'rootObject'
SELECT r_object_id, chronicle_id as i_chronicle_id, audited_obj_id, object_type, time_stamp, event_name FROM dm_audittrail WHERE (event_name = {deleteEvent} OR event_name = {pruneEvent} OR event_name = {saveEvent}) AND time_stamp_utc > DATE('01/01/1990 00:00:00 utc','dd/mm/yyyy HH:mi:ss') AND object_type in ({type1},{type2},etc)
Egnyte  

API Specific Permissions:

  • /puboauth/token

  • /pubapi/v2/users

  • /pubapi/v2/groups

  • /pubapi/v1/fs for enumeration

  • /pubapi/v1/fs/ids/file" for item

  • /pubapi/v1/fs-content for item blob

  • More info
Google Drive Connector  

  • GET_USERS_URL https://www.googleapis.com/admin/directory/v1/users

  • GET_GROUPS_URL https://www.googleapis.com/admin/directory/v1/groups

  • GET_GROUP_MEMBERS_URL https://www.googleapis.com/admin/directory/v1/groups/{0}/members

  • GET_DRIVES_URL https://www.googleapis.com/drive/v3/drives

  • GET_FILES_URL https://www.googleapis.com/drive/v3/files

  • GET_STARTPAGE_URL https://www.googleapis.com/drive/v3/changes/startPageToken

  • GET_CHANGES_URL https://www.googleapis.com/drive/v3/changes

  • GET_PERMISSIONS_URL https://www.googleapis.com/drive/v3/files/{0}/permissions
iManage  

  • {iManageServerURL}/auth/oauth2/authorize

  • {iManageServerURL}/auth/oauth2/token

  • {iManageServerURL}/api

  • {iManageServerURL}/api/v2/customers/{CustomerId}/documents/search

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/documents

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/{type}/{documentId}

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/change-events

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/documents/{documentId}/download/{Guid}

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/email/{emailId}/attachments/{attachmentId}/download

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/users

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/folders

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/groups

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/groups/{groupId}/members

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/{type}/{documentId}/security

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/documents/{documentId}/path

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/change-events/queues

  • {iManageServerURL}/api/v2/customers/{CustomerId}/libraries/{libraryName}/change-events/queues/{queueId}
Microsoft Teams  

  • https://graph.microsoft.com/v1.0/teams

  • https://graph.microsoft.com/v1.0/groups

  • https://graph.microsoft.com/v1.0/users

  • https://graph.microsoft.com/v1.0/teams/{teamid}/channels/{channelid}

  • https://graph.microsoft.com/v1.0/teams/{teamid}/channels/{channelid}/messages

  • https://graph.microsoft.com/v1.0/teams/{teamid}/channels/{channelid}/messages/{messageid}

  • https://graph.microsoft.com/v1.0/users/{userid}/photo
Oracle Web Center Content (Stellent)  

This connector uses a mix of SQL queries and API calls:

  • http://<server>/idc/login/j_security_check
  • http://<server>/idc/idcplg?Auth=Intranet
  • http://<server>/idc/idcplg?IdcService=LOGIN
  • http://<server>/idc/idcplg?IdcService=DOC_INFO&dID=<id>
  • http://<server>/idc/idcplg?IdcService=DOC_INFO_BY_NAME&dDocName={id}&IsJava=1
  • http://<server>/idc/idcplg?IdcService=GET_FILE&RevisionSelectionMethod=LatestReleased&dDocName=<id>&allowInterrupt=0
Salesforce  

  • /services/data/vXX.X/sobjects/

  • /services/data/vXX.X/sobjects/sObject/describe/

  • api/security/GetUsers

  • api/security/GetGroups

  • api/security/GetGroupMembership/{GroupId}

  • /services/data/vXX.X/queryAll?q=query

  • /services/data/vXX.X/query?q=query
ServiceNow  

Connector account must have access to:

  • announcement
  • cmn_cost_center
  • cmn_department
  • cmn_location
  • core_company
  • incident
  • kb_knowledge
  • kb_knowledge_base
  • kb_uc_can_contribute_mtom
  • kb_uc_can_read_mtom
  • b_uc_cannot_contribute_mtom
  • kb_uc_cannot_read_mtom
  • sc_cat_item
  • sc_cat_item_user_criteria_mtom
  • sc_cat_item_user_criteria_no_mtom
  • sc_catalog sc_category
  • sc_req_item
  • sc_request
  • sn_hr_core_m2m_condition_criteria
  • sys_attachment
  • sys_attachment_doc
  • sys_audit_delete
  • sys_dictionary
  • sys_group_has_role
  • sys_user
  • sys_user_grmember
  • sys_user_group
  • sys_user_has_role
  • sys_user_role
  • sys_user_role_contains
  • user_criteria
Veeva Vault