Excel Add-In for Salesforce

Build 26.0.9770

LoginIp

Stores IP address details associated with user logins, helping track security and access patterns.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the login IP record.

UsersId String True

User.Id

ID of the user associated with the login IP.

SourceIp String True

IP address from which the login attempt was made.

IsAuthenticated Bool True

Indicates whether the login attempt from this IP was successfully authenticated.

ChallengeSentDate Datetime True

Date and time when a challenge was sent to verify the login attempt.

ChallengeMethod String True

Method used to challenge the login attempt, such as email or SMS.

CreatedDate Datetime True

Date and time when the login IP record was created.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
SOQL String

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

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

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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770