Insights API
Access your Simplicate data through a PostgreSQL-compatible SQL interface, designed for seamless integration with BI tools like Power BI and Tableau.
Get startedThe Simplicate Insights API provides SQL-based, Postgres-compatible access to structured Simplicate data for dashboards, KPIs, and analytics.
Using Custom Fields in the Insights API
Data Model
Containing all documentation on the tables and fields that make up the Insights API data model.
Inisghts API DatamodelThis documentation covers all tables available through the Simplicate SQL API, which is accessible via a PostgreSQL protocol compatible interface.
Custom Fields TablesThese tables show Simplicate custom field values per entity type. They share the same structure but link to different parent entities and store organization-specific information.
Table api_administrationsCompany entities/business units
Table api_employeesThe _api_employees table exposes employee information including names, types, and status.
Table api_teamsThe _api_teams table exposes team entities configured in Simplicate.
Table api_teams_to_employees_bridgeThe api_teams_to_employees_bridge table is a bridge table that links employees to their teams. An employee can belong to multiple teams, and a team can have multiple employees.
Table api_relations
Table api_projectsThe _api_projects table exposes project entities from Simplicate
Table api_project_servicesThe api_project_services table exposes project service entities, which represent the individual services configured within a project.
Table api_project_assignmentsThe _api_project_assignments table exposes project assignment entities, which represent the assignment of employees to specific project services and item types.
Table api_invoicelinesThe api_invoicelines table exposes individual invoice line items, including pricing and links to projects, services, and revenue groups.
Table api_invoicesThe api_invoices table exposes invoice header information from Simplicate's invoicing module.
Table api_salesThe _api_sales table exposes sales/opportunity entities from Simplicate
Table api_workflowsThe api_workflows table exposes workflow entities, which represent tasks and their progress through defined workflow steps.
Table api_item_typesThe api_item_types table exposes item type entities, which represent different types of hours or costs that can be registered in Simplicate.
Table api_time_registrationsThe api_time_registrations table exposes individual time registration entries, including hours, values, and related metadata.
Table api_revenuegroupsThe api_revenuegroups table exposes revenue group entities, which are used to categorize revenue for reporting purposes.
Table api_employee_timesheetThe api_employee_timesheet table exposes aggregated timesheet data per employee per day, including productivity metrics, hours breakdown, and targets.
Table api_project_assignments_factsThe api_project_assignments_facts table exposes time-series data about project assignments, including assigned and registered hours and values per date/month.
Table api_project_service_costsThe api_project_service_costs table exposes cost registrations on project services, including purchase and selling values.
Table api_project_service_date_factsThe api_project_service_date_facts table exposes time-series financial data for project services, including registered values, invoice values, and costs per date.
Table api_project_service_cost_budgetsThe api_project_service_cost_budgets table exposes cost budget information configured for project services, broken down by item type.
Table api_project_service_hour_budgetsThe api_project_service_hour_budgets table exposes hour budget information configured for project services, broken down by item type.