Excel Add-In for Salesforce

Build 25.0.9434

AuthSession

Tracks login sessions and authentication details for Salesforce users.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the authentication session.

UsersId String True

User.Id

ID of the user associated with the session.

NumSecondsValid Int True

Duration in seconds for which the session is valid.

UserType String True

Type of user associated with the session, such as standard, guest, or system.

SourceIp String True

IP address from which the session originated.

LoginType String True

Method used to authenticate the session, such as UI login, OAuth, or API.

SessionType String True

Category of the session, such as UI, API, or Remote Access.

SessionSecurityLevel String True

Security level assigned to the session, which determines access and authentication requirements.

LogoutUrl String True

Field containing LogoutUrl information.

ParentId String True

AuthSession.Id

ID of the parent object in the hierarchy.

LoginHistoryId String True

LoginHistory.Id

ID of the related login history record.

LoginGeoId String True

LoginGeo.Id

ID of the LoginGeo associated with this record.

IsCurrent Bool True

Indicates whether the record has the Current characteristic.

IsAssociatedWithJwtAccessToken Bool True

Indicates whether the record has the AssociatedWithJwtAccessToken characteristic.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

LastModifiedDate Datetime True

Timestamp when the session was last modified or refreshed.

CreatedDate Datetime True

Timestamp when the session was created.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434