A list of third-party account links is generated when users of an organization authenticate using an external authentication provider. Use this object to list and revoke a given user's social sign-on connections (such as Facebook©).
Supported Calls
describeSObjects(), query()
Special Access Rules
If you try to use Apex DML operations and then query this object in the same call, you get an UncommittedWork error with this description.
A callout was unsuccessful because of pending uncommitted work related to a process, flow, or Apex operation. Commit or roll back the work, and then try again.
To avoid this error, execute DML operations and queries in separate, asynchronous calls.
Fields
| Field Name | Details |
|---|---|
| Handle |
|
| IsNotSsoUsable |
|
| Provider |
|
| RemoteIdentifier |
|
| SsoProvider |
|
| SsoProviderId |
|
| SsoProviderName |
|
| ThirdPartyAccountLinkKey |
|
| UserId |
|
Usage
Admins (with the Manage Users permission) querying this object can see all the links for all users in the organization. Without the Manage Users permission, users can only retrieve their own links. Users sometimes don't have access to the SsoProvider value (the foreign key). In this case, use the SsoProviderName to render the name of the provider for the associated link.
Use the Apex method Auth.AuthToken.revokeAccess() to revoke a link. To use this method, the IsNotSsoUsable field must be false.
To make the ThirdPartyAccountLink standard object writable for Salesforce admins, contact Salesforce Customer Support. With this feature, you can easily add or delete third-party account links using the API, but you can’t update existing account links.
In API version 34.0 and later, this object was enhanced to help manage high instance counts. A query() call returns up to 500 rows. A queryMore() call returns 500 more, up to 2,500 total. No more records are returned after 2,500. To make sure that you don’t miss any records, issue a COUNT() query in a SELECT clause for ThirdPartyAccountLink. This query gives you the total number of records. If there are more than 2,500 records, use these options to manage your results.
- Divide queries by filtering on fields like UserId to return subsets of less than 2,500 records.
- Use OFFSET to get batches of 2,000 records. Start with an
OFFSET of 0 and then increment by
2,000. If you use this option, we recommend that you also use LIMIT to limit each query to 2,000.
Note
The OFFSET clause is limited to 2,000 rows. Requesting an offset greater than 2,000 results in a NUMBER_OUTSIDE_VALID_RANGE error.
For example, use an initial query with this structure.
SELECT <desired fields> FROM ThirdPartyAccountLink LIMIT 2000 OFFSET 0
Then, run another query with an offset of 2,000.
Continue to increase the offset by 2,000 until you have results for all records.SELECT <desired fields> FROM ThirdPartyAccountLink LIMIT 2000 OFFSET 2000