In the OutSystems Emails API, the actual status of an email (e.g., Sent, Error, or Pending) is represented by the Name attribute in the Email_Status entity. This attribute stores a human-readable string that indicates the status of the email.

To determine the status of an email, you need to join the Sent_Email entity with the Email_Status entity using the Email_Status_Id foreign key in Sent_Email. After establishing this relationship, you can fetch the value of the Name attribute in Email_Status for each email Emails API.

This approach allows you to display statuses such as "Sent", "Error", or "Pending" on your web application. If you're looking for the date and time an email was sent, you can use the Sent attribute from the Sent_Email entity How to find when the last email was sent.

If the Email_Status entity does not provide the expected attributes (Name or Label) for the email status in your query or join with Sent_Email, ensure that your use of the Email_Status entity follows its correct implementation according to the OutSystems Emails API. The actual status values (e.g., Sent, Error, or Pending) are stored in this entity, where each status corresponds to an ID (Id).

Here’s how you can find and confirm the status of an email:

1. Verify Email Status Using Email_Status Entity

• The Id column in Email_Status corresponds to a predefined set of email statuses in the OutSystems platform. These statuses are system-defined. In a standard setup, they typically map to:

  • 0 → Pending
  • 1 → Sent
  • 2 → Error

  You must map these IDs to their respective statuses manually in your application logic if the Email_Status entity does not have a descriptive attribute (e.g., Name or Label) available Emails API.

2. Cross-Check Status Using Sent_Email Entity

• The Email_Status_Id attribute in the Sent_Email entity serves as a foreign key that links to the Id column in Email_Status.
• If you're retrieving email records from the Sent_Email entity, ensure you incorporate this join:

  Sent_Email.Email_Status_Id = Email_Status.Id
  

• The Email_Status_Id value in Sent_Email determines the associated email status.

3. Manually Map Status IDs

• If Email_Status does not expose a user-friendly label/description for the status, you can define a local mapping (e.g., in an action or an enumeration) like this:

  StatusMapping:
    0 → Pending
    1 → Sent
    2 → Error
  

Use this mapping in your logic to interpret the Email_Status_Id value retrieved from Sent_Email.

4. Fallback: Monitor Email Logs in Service Center

• If the above steps do not work or you need more granular details, verify the email flow through Service Center:
  • Navigate to Monitoring → Emails to see the email logs, which include the status of each email. This can help you debug if the status mapping seems incorrect How to find when the last email was sent.

5. Check Module Dependency

• Ensure you’ve added the Email_Status entity correctly as a dependency in your module. If not referenced properly, it might appear incomplete, causing missing fields.

Summary

The email status (Sent, Error, or Pending) is fundamentally stored in the Email_Status_Id attribute of the Sent_Email entity. This links to the Email_Status entity, where you can cross-reference its predefined Id values. When descriptive labels (Name or Label) are unavailable in Email_Status, you must use manual mappings for the status values Emails API.