E2Excel

Hello Susmitha M, Thank you for the detailed explanation. Based on the information you shared, the issue is most likely related to the authentication approach used for the Per User Named Credential. With the “Per User” authentication model, each user is expected to authenticate using their own Salesforce credentials. Authenticating multiple users using a single System Admin credential can lead to inconsistent authentication mappings and may cause errors such as: 1. “Invalid conversion from runtime type List to Map<String,ANY>” 2. “Id value … is not valid for the ExternalDataUserAuth standard controller.” At present, there is no specific limitation in E2Excel regarding the number of authenticated users under a Per User Named Credential. However, Salesforce expects authentication to be maintained individually for each user. To resolve this issue, we recommend the following steps: 1. Delete the existing Authentication Settings for External Systems entries for the affected users 2. Re-authenticate each user individually using their own Salesforce credentials 3. Avoid using a single admin credential for multiple users under the Per User authentication model After completing the re-authentication process, please test the export functionality again. If the issue persists, please let us know, and we will be happy to assist you further. For any queries related to this app or any other issues, please feel free to reach out to us at support@astreait.com.

Thank you for reporting the issue and for sharing the details. We understand that the issue is occurring specifically for list views with the sharing setting set to “Only I can see this list view.” We request you to please ask the affected users to follow these steps: 1. Go to Profile Icon → Settings → Authentication Settings for External Systems 2. Delete any existing E2Excel authentication entry (if present) 3. Click New / Authenticate and complete the authentication using their own Salesforce credentials Also, please ensure that the Named Credential is properly assigned to their profile or permission set. After completing these steps, please try exporting again. If the issue still persists after performing these steps, please let us know at support@astreait.com , we will be happy to assist further.

Thank you for your question. As a general guideline, when using around 10 columns, the List View button can reliably export thousands of records in a single run. The exact number may vary depending on data size and Salesforce platform constraints such as response size and processing time when generating large Excel files in one request. For larger volumes, exporting in smaller batches or using the E2Excel component option provides more stable and consistent results. If you have any further questions, please feel free to let us know. If you face any issues while exporting or encounter any errors during usage, please reach out to us at support@astreait.com , and we will be happy to look into it.

Hi Rahul Tomar, Thank you for your quick response. Could you please confirm the approximate record limit when using 10 columns? For our project, the business team needs to understand the expected record count.

Thank you for your feedback. Exporting very large list views is subject to Salesforce platform limits. While smaller and medium-sized exports work smoothly from the List View button, very large exports (such as 10,000+ records) may not complete reliably in a single run. For large datasets, we recommend using the E2Excel component or tab option, or splitting the data into smaller batches using filters. This approach provides more stable results. Thank you for your understanding. Please feel free to contact us at support@astreait.com if you need any assistance.