Create, update, delete, and query from Mailboxes table
Table Specific Information
Note: Only users with admin privileges can access the following Table.
Following is an example to select all entries from Mailboxes table:
SELECT * FROM Mailboxes
The API allows only a subset of columns to be used as filter criteria in the WHERE clause. The filters listed can also be combined using AND OR. The following columns can be used:
SupportEmail and MailboxType are mandatory to Insert into Mailboxes table. For instance:
INSERT INTO Mailboxes (SupportEmail, Name, MailboxType) Values ('firstname.lastname@example.org', 'Test', 'freshdesk_mailbox')
UpdateFollowing is an example of how to update Mailboxes table:
UPDATE Mailboxes SET Name = 'Test mailbox' WHERE Id = 786
Following is an example of how to delete from the Mailboxes table:
DELETE FROM Mailboxes WHERE Id = 786
Unique ID of the email mailbox.
Denotes if the mailbox is to be used for incoming, outgoing or both.Takes the values
True if the mailbox is verified and activated.
Denotes the type of authentication that should be used authenticate the mailbox. It can be plain/login/CRAM-MD5.
Mandatory if the mailbox is of the type custom mailbox. This field contains the incoming and/or outgoing configurations of the mailbox based on what access type is set.
True if the email associated to a product, is the primary email.
If set to true, Freshdesk is given the permission to delete the email from the mailbox after the ticket is created.
Denotes the failure message if any in the custom incoming mailbox.
Denotes the email address to which your support emails gets forwarded.
If the mailbox is of the type Freshdesk mailbox this field contains the forward email to which your support emails gets forwarded.
Denotes the group ID to which the email is associated.
Contains the incoming configuration of the custom mailbox.
Denotes the server used by incoming and/or outgoing configurations of the mailbox.
Denotes if the mailbox uses a Freshdesk mailbox or a custom mailbox setup by the customer. It takes the values
Name of the email mailbox.
Contains the outgoing configuration of the custom mailbox.
Denotes the password that will be used to authenticate the custom mailbox.
Denotes the port used by incoming and/or outgoing configurations of the mailbox.
Denotes the product ID to which the email is associated.
Denotes your support email address.
Denotes if the incoming and/or outgoing configuration should use ssl while authenticating the mailbox.
Mailbox creation timestamp.
Mailbox updated timestamp.