Insights API
Access your Simplicate data through a PostgreSQL-compatible SQL interface, designed for seamless integration with BI tools like Power BI and Tableau.
By Prosper and 1 other2 authors24 articles
Data Model
Containing all documentation on the tables and fields that make up the Insights API data model.
- Insights 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.