Worked on the adobe/spacecat-api-service repository to enhance the V2 Prompts API by introducing UUID primary keys to prompts, topics, and categories, enabling direct integration with brand_presence_executions and reducing the need for downstream database lookups. Updated the OpenAPI Specification and maintained backward compatibility by preserving existing TEXT business keys. Coordinated deployment with downstream dependencies to ensure data integrity and a smooth rollout. Utilized JavaScript and YAML for API development and specification updates, with a strong emphasis on testing and validation. All changes were thoroughly tested, resulting in improved data retrieval efficiency and a more robust data model for analytics.