Develop Backend API for Contacts Page

[mahid797]

Develop a backend API to support the Contacts Page functionality by retrieving visitor details. This includes visitor activity, document access logs, and sorting options.

Tasks

• Rename the LinkRecipients table to LinkVisitors.
• Implement an API endpoint to fetch contact details:
  • Retrieve visitor data (first_name, last_name, email) from the LinkVisitors table.
  • Include:
    • Last Viewed Link: Fetch friendlyName from the Link table. Fallback to LinkID if unavailable.
    • Last Activity: Use the updatedAt field from LinkVisitors.
    • Total Visits: Calculate the total number of accesses by each visitor.
  • Group data by email to avoid duplicates.
• Validate backend logic:
  • Ensure the API correctly associates Last Viewed Link with the most recent link accessed.
• Handle edge cases:
  • Return N/A for missing Name or Email.
  • Provide error responses for failed queries.

---

Notes

• Visitor details saved in the LinkVisitors table are handled via File Access Page (Implement Backend API for File Access #138).