invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

SearchCql: Atlassian Confluence User by Account ID

read only REST

  • Catálogo: JIRA
  • Esquema: Confluence
  • Llaves Primarias: id
  • Label: User by Account ID

Solo puede recuperar datos.

Fuente de la API

  • Punto final: /search?expand=personalSpace

Parámetros

Name Tipo de Datos Required Default Documentation
cql varchar2 The CQL query to be used for the search.
cqlcontext varchar2 The space, content, and content status to execute the search against. spaceKey: Key of the space to search against.Optional. contentId: ID of the content to search against.Optional.Must be in the space specified by spaceKey. contentStatuses: Content statuses to search against.Optional.
includeArchivedSpaces char Include content from archived spaces in the results.Default: false.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla SearchCql. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
content_body_anonymous_export_view_representation varchar2
content_body_anonymous_export_view_value varchar2
content_body_atlas_doc_format_representation varchar2
content_body_atlas_doc_format_value varchar2
content_body_editor_representation varchar2
content_body_editor_value varchar2
content_body_editor2_representation varchar2
content_body_editor2_value varchar2
content_body_export_view_representation varchar2
content_body_export_view_value varchar2
content_body_storage_representation varchar2
content_body_storage_value varchar2
content_body_styled_view_representation varchar2
content_body_styled_view_value varchar2
content_body_view_representation varchar2
content_body_view_value varchar2
content_history_contributors varchar2
content_history_createdBy_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
content_history_createdBy_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
content_history_createdBy_active char Indicates whether the user is active.
content_history_createdBy_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
content_history_createdBy_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
content_history_createdBy_key varchar2 This property is no longer available and will be removed from the documentation soon
content_history_createdBy_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
content_history_createdBy_name varchar2 This property is no longer available and will be removed from the documentation soon.
content_history_createdBy_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
content_history_createdDate datetime
content_history_lastUpdated_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
content_history_lastUpdated_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
content_history_lastUpdated_by_active char Indicates whether the user is active.
content_history_lastUpdated_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
content_history_lastUpdated_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
content_history_lastUpdated_by_key varchar2 This property is no longer available and will be removed from the documentation soon
content_history_lastUpdated_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
content_history_lastUpdated_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
content_history_lastUpdated_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
content_history_lastUpdated_collaborators varchar2
content_history_lastUpdated_friendlyWhen varchar2
content_history_lastUpdated_links varchar2
content_history_lastUpdated_message varchar2
content_history_lastUpdated_minorEdit char
content_history_lastUpdated_number int32
content_history_lastUpdated_when varchar2
content_history_latest char
content_history_nextVersion_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
content_history_nextVersion_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
content_history_nextVersion_by_active char Indicates whether the user is active.
content_history_nextVersion_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
content_history_nextVersion_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
content_history_nextVersion_by_key varchar2 This property is no longer available and will be removed from the documentation soon
content_history_nextVersion_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
content_history_nextVersion_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
content_history_nextVersion_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
content_history_nextVersion_collaborators varchar2
content_history_nextVersion_friendlyWhen varchar2
content_history_nextVersion_links varchar2
content_history_nextVersion_message varchar2
content_history_nextVersion_minorEdit char
content_history_nextVersion_number int32
content_history_nextVersion_when varchar2
content_history_previousVersion_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
content_history_previousVersion_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
content_history_previousVersion_by_active char Indicates whether the user is active.
content_history_previousVersion_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
content_history_previousVersion_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
content_history_previousVersion_by_key varchar2 This property is no longer available and will be removed from the documentation soon
content_history_previousVersion_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
content_history_previousVersion_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
content_history_previousVersion_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
content_history_previousVersion_collaborators varchar2
content_history_previousVersion_friendlyWhen varchar2
content_history_previousVersion_links varchar2
content_history_previousVersion_message varchar2
content_history_previousVersion_minorEdit char
content_history_previousVersion_number int32
content_history_previousVersion_when varchar2
content_id int64
content_key varchar2
content_status varchar2
content_title varchar2
content_type varchar2
content_version_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
content_version_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
content_version_by_active char Indicates whether the user is active.
content_version_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
content_version_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
content_version_by_key varchar2 This property is no longer available and will be removed from the documentation soon
content_version_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
content_version_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
content_version_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
content_version_collaborators varchar2
content_version_friendlyWhen varchar2
content_version_links varchar2
content_version_message varchar2
content_version_minorEdit char
content_version_number int32
content_version_when varchar2
entityType varchar2
excerpt varchar2
friendlyLastModified varchar2
iconCssClass varchar2
lastModified varchar2
resultGlobalContainer_displayUrl varchar2
resultGlobalContainer_title varchar2
resultParentContainer_displayUrl varchar2
resultParentContainer_title varchar2
title varchar2
url varchar2