Generate API from Insight and Generate API using CoPilot from Business Schema

[MoatazBellah]

Currently, Incorta allows users to generate the underlying SQL query for a given insight. This enhancement proposes a new, complementary feature: the ability to generate an API script directly from an insight.

This feature would add a new option, "Generate API," alongside the existing "Generate SQL" option. When a user selects this, Incorta would automatically create and expose a pre-configured API. This API would be designed to return the data from the insight in a standard format (e.g., JSON or CSV), making it readily accessible for integration with other applications, services, and platforms.

This feature would provide significant value to Incorta customers and their development teams by:

Accelerating Integration and Development:
Developers often need to access data from Incorta insights to power external dashboards, custom applications, or business processes. The "Generate API" feature would eliminate the manual effort, providing an instant, ready-to-use script. This will drastically reduce development time and accelerate time-to-market for new data-driven initiatives.

Democratizing Data Access:

This feature makes data more accessible to a wider audience, including non-technical users who may not be proficient in API development. An Incorta user, such as a business analyst, could create an insightful visualization and then, with a single click, provide a clean, documented API to a developer without needing to be an expert in data modeling or API design.

Enhancing Governance and Security:

By generating APIs directly from a governed Incorta environment, organizations can ensure that data access is secure and controlled. The generated API would inherit the security policies and access rights of the original insight. This centralized and automated approach reduces the risk of developers creating ad-hoc, insecure, or redundant data access points.

Reducing Maintenance Overhead:

When an insight is modified (e.g., a new column is added, or a filter is changed), the "Generate API" feature could be updated to reflect these changes. This would prevent the "API drift" that occurs when manually created APIs become out of sync with their underlying data sources, thus reducing maintenance overhead for development and IT teams.

Improving Productivity for All Stakeholders:

• For Product Managers/Analysts: It allows them to quickly provide data to developers, empowering them to build applications based on business needs.

• For Developers: It provides a pre-built, secure, and documented data source, freeing them from the need to write complex data retrieval logic.

• For IT/Admins: It simplifies governance and security by providing a standardized, controlled way to expose data.

In addition to the above, The API script can be generated using CoPilot from Business Schema