Add in endpoints to pull CER Factor data

Feature Request: Add API endpoints to manage CER Factor data

Summary:
Introduce API endpoints in Connect for Web to create, read, update, and delete CER (Cost Estimating Relationship) Factor data in PROPRICER CE. This will allow external applications to programmatically manage CER Factor tables and keep them synchronized with CE.

Problem Statement:
Connect for Web currently lacks any capability to CRUD CER Factor data from PROPRICER CE. As a result, any CER Factor table entries must be managed manually within CE or via other non-API mechanisms. This limitation prevents external systems from integrating tightly with CE for CER Factor management, leading to duplicated effort, data inconsistencies, and reduced automation potential.

Proposed Solution:
Expose a set of authenticated REST API endpoints that allow external applications to:

• GET CER Factor records (with filtering support by proposal, CER, date, etc.).

• POST new CER Factor records into CE.
  -/PATCH existing CER Factor records to update values and attributes.

• DELETE CER Factor records when they are no longer needed.

The endpoints should:

• Validate input to ensure consistency with CE’s CER schema and business rules.

• Return clear error messages and HTTP status codes for invalid requests.

• Support pagination and query parameters for efficient retrieval of large CER Factor datasets.

• Log operations for auditability of changes performed via the API.

Benefits:

• Enables external applications to programmatically create and maintain CER Factor data in PROPRICER CE.

• Reduces manual data entry and the risk of human error when managing CER Factors.

• Improves data consistency between CE and integrated systems by supporting automated synchronization.

• Expands the usefulness of Connect for Web as a comprehensive integration surface for cost estimating workflows.

Custoemr Description:
Connect 4 Web lacks any ability to CRUD Cost Estimate Relationship factors from PROPRICER CE.
Use Case/Example: We would like to be able to one day utilize GET, POST, PUT and DELETE methods of CER Factor data back into CE from external applications that create CER Factor table data.