I am trying to create a script that gets the body of archived emails that are visible to all users under a company in so, but I realised that the db table email_item is protected. Is there any way for me to gain access to the email bodies?
All Replies (1)
The email_item table is used by the internal inbox functionality, it contains the emails that are directly taken from a specific users inbox, not only the one's an user archived in SuperOffice. Because of that, this table is indeed protected from searching (and propably because it can be a very large table).
SuperOffice does not store the content of archived emails/documents in the database, but in the external document archive, which in Online can be either Azure blob storage or Microsoft 365 sharepoint. It isn't possible to query this storage directly to get the email body's.