Added MyOpenCRE page with functionality and also made ui changes in chatbot
Here is the changes -
- Developed a Secure Python/Flask REST API: Architected and built one new endpoints and use another prebuilt endpoint to handle the complete data workflow:
-
A GET endpoint (/rest/v1/cre_csv) that dynamically generates and serves a pre-formatted, up-to-date CSV mapping template from the live database.
-
A POST endpoint (/rest/v1/cre_csv/suggest) that accepts CSV file uploads, processes the data, and returns an enriched file.
2- Engineered the Core AI Logic: Implemented the AI pipeline that uses a Large Language Model (LLM) via the OpenAI API to generate text embeddings from security control descriptions, enabling high-speed semantic similarity searches. 3- Created an Intelligent Suggestion & Reporting System: The backend intelligently suggests high-confidence CRE mappings by comparing embeddings. It also fulfills a key stretch goal by adding a "Status" column to the output, explicitly flagging entries that require human review due to low confidence or missing data.
Here is the screenshots of frontend -