api_query
$select=fullname,telephone1,contactid,egrant_variation,egrant_usertcacceptance,egrant_userrole,telephone3,_egrant_suburbcitymailing_value,_egrant_suburbcity_value,_egrant_statemailing_value,_egrant_state_value,egrant_source_egrantid,egrant_signoffrightstextformatted,egrant_signoffrightstext,egrant_scheduleagreement,egrant_resetpassword,egrant_claim,egrant_progressreport,egrant_portalfirsttimeloginpassed,_egrant_portalcreatedby_value,_parentcustomerid_value,jobtitle,egrant_officertype,lastname,egrant_isphysicalandmailingaddresssame,telephone2,firstname,egrant_eoi,emailaddress3,emailaddress2,emailaddress1,egrant_delegate,egrant_defaultvendoraddress,_egrant_countrymailing_value,_egrant_country_value,egrant_completionreport,egrant_application,egrant_adminrole,egrant_accessrights,egrant_salutation,adx_identity_logonenabled,mobilephone,address2_line3,address2_line2,address2_line1,address1_line3,address1_line2,address1_line1,modifiedon,_modifiedby_value,createdon,_createdby_value,statuscode,statecode&$orderby=fullname%20asc&$filter=(statecode%20eq%200%20and%20Microsoft.Dynamics.CRM.In(PropertyName='egrant_officertype',PropertyValues=['486410009','486410000','486410005','486410002']))%20and%20(parentcustomerid_account/egrant_glvendortype%20eq%20486410000)Last updated: 19 Oct 2026