+ Start a Discussion
Bhushan burujwaleBhushan burujwale 

SOAP api to get isfrozen

We have a Salesforce Client that fetches user and other attributes from Slaesforce server, along with this we also want to fetch  "IsFrozen" attribute.
The IsFrozen attribute is present in UserLogin and can be fetched using below query "SELECT UserId, IsFrozen FROM UserLogin". 
But we already make a lot of calls to the Salesforce server where we get the API exceeding exception.
Hence is it possible to fetch IsFrozen attribute using below query.

Select Id  , Alias , City , CommunityNickname , CompanyName , CallCenterId , Country , Department , Email , Division , EmployeeNumber , Extension , Street , Fax , IsActive , Username , FirstName , LastName , EmailEncodingKey , Name , UserPermissionsMarketingUser , UserPermissionsMobileUser , UserPermissionsOfflineUser , UserPermissionsSFContentUser , Phone , ProfileId , Profile.Name , ReceivesAdminInfoEmails , UserRoleId , UserRole.Name , UserType , State , Title , ReceivesInfoEmails , Profile.UserLicense.Name , LanguageLocaleKey , LocaleSidKey , TimeZoneSidKey , FederationIdentifier , TESTKEY__c , Manager.Name , Profile.Id , UserRole.Id from user WHERE user.IsActive = true


 
JLA.ovhJLA.ovh
There is no relationship name available between User and UserLogin object. You cannot retrieve field values from both objects in 1 query
Bhushan burujwaleBhushan burujwale
is there anyway we can fetch isFrozen attribute for all the users in single query ?
your help is really appriciable.