{"id":141497,"date":"2026-09-20T22:52:35","date_gmt":"2026-09-20T22:52:35","guid":{"rendered":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/"},"modified":"2026-09-20T22:53:24","modified_gmt":"2026-09-20T22:53:24","slug":"data-builder-visual-reporting-rest-api-graphql-for-perfex-crm","status":"publish","type":"post","link":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/","title":{"rendered":"Data Builder \u2014 Visual Reporting, REST API &amp; GraphQL for Perfex CRM"},"content":{"rendered":"<a href=\"https:\/\/go.fiverr.com\/visit\/?bta=1052423&nci=17043\" Target=\"_Top\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" src=\"https:\/\/fiverr.ck-cdn.com\/tn\/serve\/?cid=40081059\" loading=\"lazy\"  width=\"601\" height=\"201\"><\/a>\n<\/p>\n<p><a class=\"wp_automatic_demo_btn\" target=\"_blank\" href=\"https:\/\/1.envato.market\/c\/2840012\/950273\/4415?u=https%3A%2F%2Fcodecanyon.net%2Fitem%2Fdata-builder-for-perfex-crm%2Ffull_screen_preview%2F62297963\">LIVE PREVIEW<\/a><a class=\"wp_automatic_buy_btn\" target=\"_blank\" href=\"https:\/\/1.envato.market\/c\/2840012\/950273\/4415?u=https%3A%2F%2Fcodecanyon.net%2Fitem%2Fdata-builder-for-perfex-crm%2F62297963\">BUY FOR $59<\/a><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/previews.customer.envatousercontent.com\/files\/812212073\/Data-Builder-for-PerfexCRM-590x300.png\" loading=\"lazy\"><\/p>\n<p><strong>Notice<\/strong>: This Add-on capabilities as a module for <a href=\"https:\/\/codecanyon.net\/item\/perfex-powerful-open-source-crm\/14013737\">Perfex CRM<\/a><br \/> <a href=\"https:\/\/codecanyon.net\/item\/data-builder-for-perfex-crm\/62297963#item-description__item-change-logs\">Click here to view the Changelog &#38; Tasks in Progress<\/a> <\/p>\n<blockquote><p>Create highly effective <strong>cross-module reviews in Perfex CRM \u2014 no SQL<\/strong>, only a <strong>visible builder<\/strong> for <strong>datasets<\/strong>, <strong>filters<\/strong>, and <strong>charts<\/strong>.<br \/>Rework Perfex CRM into an <strong>API-first platform with unified GraphQL and REST APIs<\/strong> for <strong>core Perfex CRM tables<\/strong>, <strong>customized datasets<\/strong>, <strong>reviews<\/strong>, and <strong>third-party module information<\/strong>.<br \/>\nSafe and scale your information workflows with granular permissions, tokenized entry management, and reusable API-driven information belongings.<\/p><\/blockquote>\n<p>  Explorer now  <\/p>\n<ul>\n<li>Dwell Demo:\u00a0 Web site :\u00a0<a href=\"https:\/\/headrandom.com\/admin9FD3VrKC\" rel=\"nofollow\">https:\/\/databuilder.polyxgo.com\/admin<\/a><\/li>\n<li>API Explorer &#38; Documentation:\u00a0<a href=\"https:\/\/headrandom.com\/iJWDGuey\" rel=\"nofollow\">https:\/\/databuilder.polyxgo.com\/api_docs<\/a><\/li>\n<li>GraphQL Documentation:\u00a0<a href=\"https:\/\/headrandom.com\/iJWDGuey#resource-graphql\" rel=\"nofollow\">https:\/\/databuilder.polyxgo.com\/api_docs#resource-graphql<\/a><\/li>\n<li>Public Chart Experiences Preview:\u00a0<a href=\"https:\/\/headrandom.com\/iJWDGuey#charts\" rel=\"nofollow\">https:\/\/databuilder.polyxgo.com\/api_docs#charts<\/a><\/li>\n<\/ul>\n<p><strong>Gallery powered by MTMedia<\/strong>: One-click <strong>automated screenshots<\/strong> for Envato authors managing <strong>a number of plugins and modules<\/strong>.<\/p>\n<table>\n<tr>\n<th>Standards<\/th>\n<th>Conventional \/ Widespread API<\/th>\n<th>Information Builder API<\/th>\n<\/tr>\n<tr>\n<td><strong>Scalability<\/strong><\/td>\n<td>\n      Sluggish. Including 1 DB desk requires creating a brand new Controller and configuring routes manually.\n    <\/td>\n<td>\n      Extraordinarily versatile. API endpoints are routinely uncovered as quickly because the DB schema adjustments.\n    <\/td>\n<\/tr>\n<tr>\n<td><strong>Safety &#38; Middleware<\/strong><\/td>\n<td>\n      Easy, requiring handbook coding for IP\/Token checks inside controllers.\n    <\/td>\n<td>\n      Superior. Includes a clean, decoupled Middleware ecosystem.\n    <\/td>\n<\/tr>\n<tr>\n<td><strong>API Output Requirements<\/strong><\/td>\n<td>Static RESTful solely.<\/td>\n<td>Multi-purpose: Dynamic RESTful &#38; Versatile GraphQL.<\/td>\n<\/tr>\n<tr>\n<td><strong>Developer Expertise (DevX)<\/strong><\/td>\n<td>\n      Good (requires handbook configuration of Swagger, Postman, Zapier).\n    <\/td>\n<td>\n      Superior (built-in API Explorer, Sandbox, routinely generates OpenAPI \/ Postman JSON at runtime).\n    <\/td>\n<\/tr>\n<tr>\n<td><strong>Information Transformation Layer<\/strong><\/td>\n<td>\n      Makes use of Transformer loops to standardize and shield the information contract. Consumes excessive CPU\/RAM.\n    <\/td>\n<td>\n      Fetches uncooked information (Uncooked Array) to optimize JSON output. Absolute efficiency by eliminating the Mapper.\n    <\/td>\n<\/tr>\n<\/table>\n<p><img decoding=\"async\" src=\"https:\/\/polyxgo.com\/wp-content\/uploads\/2026\/04\/Data-Builder-RESTful-API-Comparison.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 1\" \/><\/p>\n<p>Create cross-module reviews inside Perfex CRM with out writing SQL. Information Builder gives a visible editor for constructing customized datasets, reviews, report teams, filters, charts, and API-ready information views from a single interface. <\/p>\n<p>Information Builder is a visible question builder, reporting engine, and API layer designed for Perfex CRM. It permits directors and workers to mix information from a number of CRM modules, construct reusable datasets, arrange reviews into tabbed teams, and expose these datasets by RESTful API and GraphQL with out manually writing SQL queries.<\/p>\n<p>In lots of CRM environments, necessary information akin to purchasers, invoices, duties, initiatives, or customized module information resides throughout separate database tables. Information Builder addresses this limitation with a structured builder for becoming a member of tables, making use of limitless filter logic, producing report views, and publishing chart-ready outputs. Experiences and API entry are core options of the module, making it appropriate for each inside analytics and exterior system integrations.<\/p>\n<p>Past inside reporting, Information Builder additionally helps unified <strong>GraphQL for Perfex CRM<\/strong>, <strong>RESTful API for Perfex<\/strong>, and full <strong>API for Perfex<\/strong> workflows in a single module. You may handle token-based entry, management CRUD permissions throughout core Perfex CRM tables and third-party modules, question customized report datasets from exterior functions, or publish public chart reviews and embed them through iframe on web sites, blogs, or different platforms.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/api-explorer-overview-sandbox-docs.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 2\" \/><br \/>\n<br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/api-explorer-supports-sample-graphql-api-queries.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 3\" \/><\/p>\n<h3 id=\"item-description__quick-start\">Fast Begin<\/h3>\n<p>Observe these easy steps to construct a &#8220;Consumer Bill Report&#8221;:<\/p>\n<ul>\n<li>Go to Information Builder &gt; Builder from the aspect menu.<\/li>\n<li>Kind &#8220;View Identify&#8221; as Consumer Invoices and &#8220;Route&#8221; as client-invoices.<\/li>\n<li>Choose Information:\n<ol>\n<li>Search and add tblclients (Base Desk).<\/li>\n<li>Search and add tblinvoices. The system will auto-detect the be part of (tblclients.userid = tblinvoices.clientid).<\/li>\n<\/ol>\n<\/li>\n<li>Design View:\n<ol>\n<li>Drag firm discipline from tblclients to the canvas. Rename Alias to &#8220;Consumer Identify&#8221;.<\/li>\n<li>Drag whole and standing fields from tblinvoices.<\/li>\n<\/ol>\n<\/li>\n<li>Filter: Click on &#8220;Add Filter&#8221; -&gt; Choose tblinvoices.standing -&gt; Operator = -&gt; Worth 2 (Overdue).<\/li>\n<li>Preview: Click on the &#8220;Run Preview&#8221; button to see the information visually on display.<\/li>\n<li>Save: Click on &#8220;Save View&#8221;. Now you can entry this report at \/admin\/data_builder\/runtime\/view\/client-invoices.<\/li>\n<\/ul>\n<h2 id=\"item-description__core-features\">Core Options<\/h2>\n<h3 id=\"item-description__1-visual-builder-amp-dataset-editor\">1. Visible Builder &#38; Dataset Editor<\/h3>\n<p>The builder interface is the core of the module. It helps groups create reusable views and datasets for reviews, charts, exports, and API consumption from one place.<\/p>\n<ul>\n<li>Drag &#38; Drop Canvas: Intuitively organize your information columns.<\/li>\n<li>Concatenated Fields: Mix a number of database columns (e.g. First Identify + Final Identify) right into a single digital discipline with customized separators. Helps merging fields from completely different joined tables.<\/li>\n<li>Good Desk Search: Rapidly discover database tables by looking for their show title, inside system title (e.g., tblclients), or quick title. The module absolutely helps querying information from core Perfex tables in addition to any third-party module tables based mostly on the database schema.<\/li>\n<li>Discipline Administration: Rename columns with user-friendly Aliases. Toggle visibility to cover ID columns used just for becoming a member of\/filtering.<\/li>\n<li>Dwell Preview: See the outcomes of your question in real-time as you design.<\/li>\n<li>Customized Dataset Views: Construct report-ready datasets that may be reused throughout reviews, charts, public views, and API requests.<\/li>\n<li>SQL-Free Workflow: Create structured reporting views with out handbook question writing, serving to groups transfer sooner whereas holding logic maintainable.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/manage-unlimited-data-display-views.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 4\" \/><br \/>\n<br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/customize-set-filter-report-easily-in-each-independent-report.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 5\" \/><br \/>\n<br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/provide-ready-made-report-templates-for-common-data-groups.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 6\" \/><\/p>\n<h3 id=\"item-description__2-relationship-manager\">2. Relationship Supervisor<\/h3>\n<p>Information Builder means that you can be part of tables simply and construct broader reporting datasets throughout Perfex CRM and third-party modules.<\/p>\n<ul>\n<li>Auto-Detection: The engine scans database overseas keys and naming conventions (e.g. clientid -&gt; userid) to recommend good joins.<\/li>\n<li>Customized Relations: Directors can outline customized relationships within the Desk Relations menu for tables that don&#8217;t share customary naming conventions.<\/li>\n<li>Be a part of Sorts: Assist for INNER JOIN (solely matching information), LEFT JOIN (all from left desk), and RIGHT JOIN.<\/li>\n<li>Third-Occasion Module Compatibility: Question and join tables created by exterior Perfex CRM modules based mostly on obtainable database schema.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Table-Relations-auto-detect-for-PerfexCRM.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 7\" \/><\/p>\n<h3 id=\"item-description__3-advanced-query-logic-filters-amp-aggregation\">3. Superior Question Logic, Filters &#38; Aggregation<\/h3>\n<p>Create versatile reviews with detailed segmentation logic and abstract metrics.<\/p>\n<ul>\n<li>Filters: Visible UI for creating WHERE clauses. Supported operators embrace: Equals (=) \/ Not Equals (!=), Accommodates (LIKE), Higher Than (&gt;) \/ Much less Than (&lt;), Between, In Checklist (IN), and Is Null \/ Is Not Null. Simply mix a number of situations utilizing AND or OR logical operators.<\/li>\n<li>Customized Filter Presets: Save per-report filter presets for sooner switching between frequent report views and recurring evaluation situations.<\/li>\n<li>Limitless Filtering Logic: Apply as many customized situations as wanted for complicated report use instances throughout operational, monetary, or CRM exercise datasets.<\/li>\n<li>Aggregations &#38; Grouping: Summarize your information utilizing SUM, COUNT, AVG, MIN, or MAX capabilities. Mix this with &#8220;Group By&#8221; to create abstract reviews.<\/li>\n<li>Column Aggregation Row: Add sum, avg, or rely calculations on the report footer for fast evaluation inside report tables.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/visual-drag-and-drop-report-builder-without-requiring-sql-knowledge.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 8\" \/><\/p>\n<h3 id=\"item-description__4-reports-report-groups-amp-charts\">4. Experiences, Report Teams &#38; Charts<\/h3>\n<p>Information Builder turns saved views into organized reporting belongings for inside dashboards or public presentation.<\/p>\n<ul>\n<li>Report Views: Use customized datasets as report sources for operational monitoring, finance reporting, pipeline visibility, or customized enterprise evaluation.<\/li>\n<li>Report Teams: Arrange impartial reviews into tabbed navigation for cleaner analytics workflows and higher group usability.<\/li>\n<li>Date Comparability Charts: Evaluate day by day, weekly, month-to-month, quarterly, or yearly information developments immediately from saved datasets.<\/li>\n<li>Supported Chart Sorts: Bar, Line, Space, Doughnut, Radar, Bubble, Combo (Bar+Line), Pie, Scatter, Stepped Line, Level-styling, and Interpolation.<\/li>\n<li>Public Experiences &#38; Teams: Publish chosen reviews or grouped analytics for exterior viewing with out requiring API integration.<\/li>\n<li>Iframe Embedding: Embed public chart views into web sites, blogs, touchdown pages, portals, or different methods by iframe.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/group-unlimited-custom-reports-for-perfex-crm.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 9\" \/><br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/public-chart-reports-api-explorer-for-embed.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 10\" \/><br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/support-visual-public-report-sharing-for-sharing-and-embedding-via-iframe-on-other-web-apps.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 11\" \/><br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/support-visual-public-report-sharing-for-sharing-and-embedding-via-iframe-on-other-web-apps-2.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 12\" \/><br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Reports-chart-for-Perfex-CRM-with-filters.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 13\" \/><\/p>\n<h3 id=\"item-description__5-runtime-engine-amp-performance-layer\">5. Runtime Engine &#38; Efficiency Layer<\/h3>\n<p>The runtime engine executes saved views securely and optimizes question execution for reviews, exports, charts, and API responses.<\/p>\n<ul>\n<li>Safety: All queries are constructed utilizing CodeIgniter&#8217;s Question Builder with strict whitelist validation to completely forestall SQL injection.<\/li>\n<li>Server-side Pagination: Ensures quick web page load instances even when scanning hundreds of thousands of database information.<\/li>\n<li>Server-Facet Question Caching: Advantageous-grained file-based question caching with configurable Cache TTL from the Admin Builder UI to scale back database queries to nearly zero.<\/li>\n<li>Centralized Cache Supervisor: A devoted administration dashboard to bulk allow, disable, or clear cache throughout all reviews with customizable TTL settings.<\/li>\n<li>Admin Drive Refresh: A safe, real-time &#8220;Clear Cache&#8221; button on each the admin UI and public embeds to fetch stay information on demand.<\/li>\n<li>Index Advisor: Clever analyzer which inspects customized JOINs, WHERE filters, and GROUP BY fields to recommend optimum SQL indexes.<\/li>\n<li>Interactive Embed Generator: Visually configure and generate responsive iframe codes with Chart\/Desk toggles and Darkish Theme help.<\/li>\n<li>Export All CSV: Export the whole filtered outcome set immediately into CSV format, bypassing customary datatable pagination limits.<\/li>\n<li>Full Excel Export: Export full outcome units into professionally structured Excel (XLSX) spreadsheets.<\/li>\n<li>Public Clean Chart View: Devoted chart rendering view for light-weight public embedding situations.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/polyxgo.com\/wp-content\/uploads\/2026\/03\/View-Data-Preview-Data-Builder-for-PerfexCRM.png\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 14\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/polyxgo.com\/wp-content\/uploads\/2026\/03\/View-SQL-Query-Preview-Data-Builder-for-PerfexCRM.png\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 15\" \/><\/p>\n<h3 id=\"item-description__6-interactive-dashboards-amp-widgets\">6. Interactive Dashboards &#38; Widgets<\/h3>\n<p>Create interactive dashboards from built-in role-based presets or construct absolutely customized dashboards from scratch utilizing a drag-and-drop widget format.<\/p>\n<ul>\n<li>Dashboard Presets: 5 premium built-in templates \u2014 CEO Overview, Finance Abstract, Advertising, Venture Supervisor, and Assist Middle \u2014 prepared to make use of immediately.<\/li>\n<li>Customized Dashboard Creation: Construct your personal dashboards from scratch, choosing which widgets and information views to show.<\/li>\n<li>Dashboard Switcher: Swap between dashboards immediately through dropdown. The system routinely remembers every person&#8217;s last-used dashboard.<\/li>\n<li>Widget Library: 4 extremely customizable widget sorts \u2014 Chart, DataTable, KPI Card, and Textual content\/Notice.<\/li>\n<li>Chart Widget: Connect with any Information Builder view and show dynamic charts. Helps 7 chart sorts (Bar, Line, Space, Pie, Doughnut, Radar, Polar Space) switchable on-the-fly.<\/li>\n<li>Drag-and-Drop Structure: Rearrange widgets intuitively with configurable column widths for versatile grid layouts.<\/li>\n<li>Auto-Refresh: Mechanically refresh dashboard information at configurable intervals (1, 5, 10, or half-hour).<\/li>\n<li>Dashboard Sharing: Share dashboards with particular group members or roles utilizing granular permission controls.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Dashboard-CEO-Overview-report-for-PerfexCRM.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 16\" \/><br \/>\n<br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Dashboard-Finance-Summary-report-for-PerfexCRM.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 17\" \/><br \/>\n<br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Dashboard-Widgets-report-for-PerfexCRM.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 18\" \/><br \/>\n<br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Dashboard-Marketing-report-for-PerfexCRM.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 19\" \/><br \/>\n<br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Dashboard-Project-Manager-report-for-PerfexCRM.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 20\" \/><br \/>\n<br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Dashboard-Support-Center-report-for-PerfexCRM.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 21\" \/><br \/>\n<br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Dashboard-new-dashboard-report-for-PerfexCRM.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 22\" \/><br \/>\n<br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Dashboard-settings-report-for-PerfexCRM.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 23\" \/><\/p>\n<h2 id=\"item-description__graphql-amp-api-for-perfex-crm\">GraphQL &#38; API for Perfex CRM<\/h2>\n<p><strong>Uncover a completely customizable information reporting integration with limitless reporting capabilities and a complete API \u2014 all packed right into a single highly effective module for Perfex CRM.<\/strong><\/p>\n<p><strong>Discover now:<\/strong>\n<\/p>\n<ul>\n<li>API Explorer &#38; Documentation: <a href=\"https:\/\/databuilder.polyxgo.com\/api_docs\" rel=\"nofollow\">https:\/\/databuilder.polyxgo.com\/api_docs<\/a><\/li>\n<li>GraphQL Documentation: <a href=\"https:\/\/databuilder.polyxgo.com\/api_docs#graphql\" rel=\"nofollow\">https:\/\/databuilder.polyxgo.com\/api_docs#graphql<\/a><\/li>\n<li>Public Chart Experiences Preview: <a href=\"https:\/\/databuilder.polyxgo.com\/api_docs#charts\" rel=\"nofollow\">https:\/\/databuilder.polyxgo.com\/api_docs#charts<\/a><\/li>\n<\/ul>\n<p>=&gt; Begin constructing smarter reviews and integrations at present.<\/p>\n<p>Information Builder additionally works as a unified API platform for Perfex CRM. As an alternative of constructing separate connectors for information entry, reviews, and exterior integrations, you should utilize one module to handle structured REST and GraphQL entry throughout core Perfex CRM tables, Information Builder views, reviews, and third-party module tables.<\/p>\n<ul>\n<li><strong>RESTful API for Perfex<\/strong>: Versioned read-only endpoints underneath \/v1\/ for querying Perfex CRM tables and Information Builder views. Helps filtering, sorting, discipline choice, and cursor pagination with HATEOAS hyperlinks.<\/li>\n<li><strong>GraphQL for Perfex CRM<\/strong>: Single-endpoint querying with auto-generated schema per desk and examine, together with question depth and complexity controls for safer manufacturing utilization.<br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/easily-test-sample-queries-with-api-explorer-to-integrate-api-for-source-code-integration-development.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 24\" \/><\/li>\n<li><strong>GraphQL Mutations<\/strong>: Full CRUD help for create, replace, and delete operations with auto-generated InputObjectTypes, major key detection, write scope enforcement, and safety column exclusions.<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/graphql-for-perfex-graphql-endpoint-queries.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 25\" \/><\/li>\n<li><strong>API for Perfex Experiences<\/strong>: Question customized report datasets, grouped views, and analytics-ready information sources from exterior methods with out recreating report logic outdoors Perfex CRM.<\/li>\n<li><strong>Token Governance<\/strong>: Handle API tokens with scoped entry to tables, views, and GraphQL permissions, together with IP allowlist (CIDR), area allowlist, per-token fee limiting, optionally available HMAC request signing, and configurable expiry.<\/li>\n<li><strong>Admin Session Bypass<\/strong>: Enable authenticated Perfex admins to name the API from the identical website by the API Explorer sandbox with no Bearer token, based mostly on configurable settings and same-site request validation.<\/li>\n<li><strong>API Explorer<\/strong>: Browse endpoints, take a look at requests stay, generate cURL\/JS\/PHP\/Python code samples, and export Postman v2.1 or OpenAPI 3.0 definitions.<\/li>\n<li><strong>One Module, Full Protection<\/strong>: Use a single module to handle reporting datasets, inside analytics, public charts, exterior API entry, and managed CRUD workflows throughout core and third-party information buildings.<\/li>\n<\/ul>\n<p>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/manage-api-tokens-scopes-tables-views-and-graphql-permissions.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 26\" \/><br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Settings-API-Access-Rate-Limiting-for-PerfexCRM.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 27\" \/><br \/>\n<img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/API-Tokens-Usage-Stats-for-Perfex-CRM.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 28\" \/><\/p>\n<h2 id=\"item-description__security-amp-permissions\">Safety &#38; Permissions<\/h2>\n<p>Entry management is a prime precedence for information integrity throughout reviews, datasets, and APIs.<\/p>\n<ul>\n<li>Desk Whitelist: Directors should explicitly permit tables to be queried on the Module Settings web page earlier than they turn out to be obtainable. Delicate tables (like tblstaff_password, tbloptions, and many others.) ought to by no means be whitelisted.<\/li>\n<li>Position-Based mostly Entry: Use Perfex&#8217;s native Permission system to manage who can View, Handle, or Export information.<\/li>\n<li>View Scopes: Assist for a number of scopes:\n<ol>\n<li>Public: Seen to all workers members who&#8217;ve View Builder view permission.<\/li>\n<li>Non-public: Seen solely to the creator of the report.<\/li>\n<li>Shared &#38; Hybrid Logic: Entry could be granted to particular roles or particular person customers. Permissions are merged utilizing impartial OR logic: entry is granted if (Person is explicitly allowed) OR (Person&#8217;s Position is explicitly allowed).<\/li>\n<\/ol>\n<\/li>\n<li>API Token Scopes: Limit entry by tables, views, and GraphQL capabilities to make sure integrations solely attain accredited datasets.<\/li>\n<li>7-Stage Safety Middleware Pipeline: Contains DDoS protect, CORS, Admin Session Bypass, auth, fee limiter, scope verifier, and request logger.<\/li>\n<li>Standardized Error Responses: API errors return as RFC 9457 Drawback Particulars for extra constant integration dealing with.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/s3.envato.com\/files\/781842957\/Permissions-for-Data-Builder-View.jpg\" loading=\"lazy\" alt=\"Data Builder \u2014 Visual Reporting, REST API &#38; GraphQL for Perfex CRM - 29\" \/><br \/>\n<a href=\"https:\/\/preview.codecanyon.net\/item\/data-builder-for-perfex-crm\/full_screen_preview\/62297963\" rel=\"nofollow\"><img decoding=\"async\" src=\"https:\/\/erp.polyxgo.com\/banner\/data-builder-for-perfex-crm-databuilder-try-products-online-demo.png?h=eyJwIjoiZGF0YWJ1aWxkZXIiLCJmIjoiZGF0YS1idWlsZGVyLWZvci1wZXJmZXgtY3JtLWRhdGFidWlsZGVyLXRyeS1wcm9kdWN0cy1vbmxpbmUtZGVtbyJ9.1ec42c07\" loading=\"lazy\" alt=\"Try Products Online Demo\" \/><\/a><\/p>\n<h2 id=\"item-description__what-s-new\">What&#8217;s New<\/h2>\n<ul>\n<li><strong>Interactive Dashboards:<\/strong> Create dashboards from 5 built-in Presets (CEO Overview, Finance Abstract, Advertising, Venture Supervisor, Assist Middle) or construct Customized dashboards from scratch.<\/li>\n<li><strong>Dashboard Switcher:<\/strong> Swap between dashboards immediately through dropdown, last-used dashboard remembered per person.<\/li>\n<li><strong>Widget Library:<\/strong> 4 widget sorts \u2014 Chart, DataTable, KPI Card, Textual content\/Notice \u2014 with drag-and-drop format and configurable column widths.<\/li>\n<li><strong>Chart Widget:<\/strong> Helps 7 chart sorts (Bar, Line, Space, Pie, Doughnut, Radar, Polar Space) switchable on-the-fly.<\/li>\n<li><strong>Auto-Refresh:<\/strong> Configurable automated dashboard refresh intervals (1\/5\/10\/half-hour).<\/li>\n<li><strong>Dashboard Sharing:<\/strong> Share dashboards with particular group members securely.<\/li>\n<li><strong>Export All CSV:<\/strong> Export total filtered reviews as CSV, bypassing page-size limits.<\/li>\n<li><strong>Server-Facet Question Caching:<\/strong> Configurable Cache TTL from Admin Builder UI for fast report supply.<\/li>\n<li><strong>Centralized Cache Supervisor:<\/strong> Bulk allow, disable, and clear cache throughout all reviews.<\/li>\n<li><strong>Index Advisor:<\/strong> Analyze view configurations and recommend optimum SQL indexes.<\/li>\n<li><strong>Interactive Embed Generator:<\/strong> Configure and generate iframe codes with chart\/desk toggle and Darkish Theme.<\/li>\n<li>Report teams for organizing impartial reviews into tabbed navigation.<\/li>\n<li>Customized filter presets per report view for conditional information show.<\/li>\n<li>Column-level aggregation row for sum, avg, and rely at report desk footer.<\/li>\n<li>Visible charts with date comparability throughout day by day, weekly, month-to-month, quarterly, and yearly durations.<\/li>\n<li>REST API with versioned read-only endpoints for Perfex CRM tables and Information Builder views.<\/li>\n<li>GraphQL API with schema era per desk and examine.<\/li>\n<li>GraphQL mutations with full CRUD capabilities.<\/li>\n<li>Scoped API tokens with allowlists, fee limits, HMAC signing, and expiry controls.<\/li>\n<li>7-stage safety middleware pipeline and RFC 9457 Drawback Particulars responses.<\/li>\n<li>Admin Session Bypass for same-site API Explorer utilization by authenticated admins.<\/li>\n<li>API Explorer with stay sandbox, code generator, and export instruments.<\/li>\n<li>Public clean chart view for iframe embedding.<\/li>\n<li>Chart.js upgraded to 4.5.0 and regionally built-in.<\/li>\n<li>Information Builder settings moved to Perfex core (Setup -&gt; Settings -&gt; Information Builder).<\/li>\n<\/ul>\n<h2 id=\"item-description__documentation-amp-support\">Documentation &#38; Assist<\/h2>\n<p><a href=\"https:\/\/polyxgo.com\/en\/guide-to-install-an-use-data-builder-for-perfex-crm\/\" rel=\"nofollow\"><img decoding=\"async\" src=\"https:\/\/erp.polyxgo.com\/banner\/data-builder-for-perfex-crm-databuilder-browse-online-documentation.png?h=eyJwIjoiZGF0YWJ1aWxkZXIiLCJmIjoiZGF0YS1idWlsZGVyLWZvci1wZXJmZXgtY3JtLWRhdGFidWlsZGVyLWJyb3dzZS1vbmxpbmUtZG9jdW1lbnRhdGlvbiJ9.8cf0c280\" loading=\"lazy\" alt=\"Browse Online Documentation\" \/><\/a><\/p>\n<p>The downloaded package deal features a full set up information and have documentation so you&#8217;ll be able to configure Information Builder shortly. It covers report constructing, desk relationships, filter logic, chart configuration, token-secured API utilization, GraphQL queries and mutations, public report publishing, and iframe embedding workflows.<\/p>\n<p>For help, submit a help ticket by the Codecanyon remark part. Our group responds as quickly as doable with detailed steering.<\/p>\n<p><a href=\"https:\/\/codecanyon.net\/user\/polyxgo\/follow\"><img decoding=\"async\" src=\"https:\/\/erp.polyxgo.com\/banner\/data-builder-for-perfex-crm-databuilder-follow-us-for-updates.png?h=eyJwIjoiZGF0YWJ1aWxkZXIiLCJmIjoiZGF0YS1idWlsZGVyLWZvci1wZXJmZXgtY3JtLWRhdGFidWlsZGVyLWZvbGxvdy11cy1mb3ItdXBkYXRlcyJ9.a6858b59\" loading=\"lazy\" alt=\"Follow us for updates\" \/><\/a><\/p>\n<h3 id=\"item-description__frequently-asked-questions-faqs\">Ceaselessly Requested Questions (FAQs)<\/h3>\n<h4 id=\"item-description__q-do-saas-providers-need-to-purchase-multiple-licenses-for-each-customer-using\"><strong>Q:<\/strong> Do SaaS suppliers must buy a number of licenses for every buyer utilizing module?<\/h4>\n<p><strong>A:<\/strong>\u00a0Not essentially. In line with Envato&#8217;s licensing coverage, a single license is legitimate for one finish product. In case you are working a centralized SaaS system (a single codebase\/shared set up), you should utilize one license and supply the module as a characteristic to all of your tenants.<\/p>\n<p>Nevertheless:<\/p>\n<ul>\n<li>In case your SaaS is a paid service (customers are charged to entry it), an Prolonged License is required.<\/li>\n<li>If you happen to deploy separate cases for every buyer (multi-instance or white-label setups), every occasion is taken into account a separate finish product and requires its personal license.<\/li>\n<\/ul>\n<p>For extra particulars, please confer with Envato&#8217;s licensing phrases:\u00a0<a href=\"https:\/\/codecanyon.net\/licenses\/standard\">https:\/\/codecanyon.net\/licenses\/standard<\/a><\/p>\n<p>Assist and updates are offered based on Envato&#8217;s help coverage, so please guarantee your help package deal stays energetic if wanted.<\/p>\n<h4 id=\"item-description__q-is-white-label-usage-allowed-no-reference-to-original-author\"><strong>Q:<\/strong> Is white-label utilization allowed (no reference to authentic creator)?<\/h4>\n<p><strong>A:<\/strong> The module is deliberately designed with a impartial, non-personalized construction, so full white-labeling is mostly not vital. Nevertheless, in case you require customization for branding functions, you&#8217;re free to regulate it. Assist requests for such adjustments could be submitted and shall be thought-about inside the help scope.<\/p>\n<h4 id=\"item-description__q-do-i-need-sql-knowledge-to-build-reports\"><strong>Q:<\/strong> Do I would like SQL information to construct reviews?<\/h4>\n<p><strong>A:<\/strong> No. The module is designed to remove the necessity for SQL information by offering a visible builder interface. Moreover, report templates shall be repeatedly expanded over time. Throughout an energetic help interval, you might also request help for particular report necessities.<\/p>\n<h4 id=\"item-description__q-can-i-combine-data-from-multiple-modules-tables\"><strong>Q:<\/strong> Can I mix information from a number of modules\/tables?<\/h4>\n<p><strong>A:<\/strong> Sure. The module is constructed to permit combining information from a number of tables, so long as relationships between these tables exist.<\/p>\n<h4 id=\"item-description__q-does-it-support-third-party-module-tables\"><strong>Q:<\/strong> Does it help third-party module tables?<\/h4>\n<p><strong>A:<\/strong> Sure. The module helps querying and connecting tables from each core system and third-party modules, so long as they&#8217;re included within the allowed tables record. The identical flexibility applies to REST API and GraphQL, with no question limitations except explicitly restricted through token permissions.<\/p>\n<h3 id=\"item-description__item-change-logs\">Adjustments<\/h3>\n<pre>NOTE: Minimal PerfexCRM model required is 3.2.0\nP\/S: In case you encounter any conflicts throughout utilization, please go away suggestions or contact me at polyxgo@gmail.com. I'll help you immediately! Thanks.\n\n-------- Model 2.3.0 (Could 28, 2026) --------\nNEW\n- Dashboard View: Create dashboards from built-in Presets (CEO Overview, Finance Abstract, Advertising, Venture Supervisor, Assist Middle) or construct Customized dashboards from scratch\n- Dashboard Switcher: change between dashboards immediately through dropdown, last-used dashboard remembered per person\n- Widget Library: 4 widget sorts \u2014 Chart, DataTable, KPI Card, Textual content\/Notice\n- Chart Widget helps 7 chart sorts: Bar, Line, Space, Pie, Doughnut, Radar, Polar Space \u2014 switchable on-the-fly\n- Drag-and-drop widget format with configurable column widths\n- Auto-refresh with configurable interval (1\/5\/10\/half-hour)\n- Share dashboards with group members\n- Export All CSV: export the whole filtered report as CSV, bypassing page-size limits\n- Server-Facet Question Caching with configurable Cache TTL from Admin Builder UI\n- Admin Drive Refresh: \"Clear Cache\" button for real-time information on demand\n- Index Advisor: analyze view configurations and recommend optimum SQL indexes\n- Interactive Embed Report Generator with chart\/desk toggle and Darkish Theme\n- Centralized Cache Supervisor: bulk allow, disable, and clear cache throughout all reviews\n\nFIXED\n- Expression Be a part of Totals: fastened Complete row calculation in \"Month-to-month Expense vs Cost\" and \"Web Outcome by Month\" templates to accurately compute SUM(Cost) - SUM(Expense); adverse values now show correctly\n- Embed Report Styling: fastened Complete row darkish\/mild mode colours in public embed desk\n- Chart Zoom UX: cover zoom controls for chart sorts that don't help axis zooming (Pie, Doughnut, Radar, PolarArea)\n- Safari Date Parsing: resolved \"Invalid date\" error on Safari by passing strict customary format patterns to second() and falling again to server-formatted dates\n\nCHANGED\n- Affirmation Modals: modified native affirm dialogs in \"Report Teams\" and \"Webhooks\" to styled SweetAlert2 modals for consistency with \"Delete View\" \n- Webhooks Motion Buttons: styled actions contained in the webhooks administration view with clear, trendy flat icons to match the \/admin\/data_builder view type\n\n-------- 2.2.3 (Could 05, 2026) --------\nCHANGED\n- Time Length Formatter: Launched a brand new \"Time Length (HH:MM)\" formatter to the Builder interface, permitting decimal hours to be correctly displayed as `HH:MM` whereas sustaining backend aggregation integrity.\n- 1000's Separator in Time Codecs: Enhanced the time period formatting logic to incorporate 1000's separators for excessive hour counts (e.g., `57,614:01`).\n- Time Breakdown Logic: Added dynamic \"sub-hours\" rendering (Days, Weeks, Months, Years) into the brand new `time_duration` formatter for durations exceeding 24 hours.\n- Preset Updates: Up to date the \"Timesheet Abstract by Venture &#38; Workers\" template preset to characteristic side-by-side time columns: \"Time (h)\" using the brand new `time_duration` formatter and \"Time (decimal)\" retaining the usual `quantity` formatter for higher reporting flexibility.\n\n-------- Model 2.2.2 (Could 02, 2026) --------\nNEW\n- Date Macros: Formally applied {{CURRENT_WEEK_START}} and {{CURRENT_MONTH_START}} dynamic date macros into the SQL parser (Runtime_model) and added quick-access UI buttons to the Builder interface. Improved CURDATE date era to make sure actual bounds matching utilizing DATE_FORMAT formatting. (Could 1, 2026)\n\nCHANGED\n- Frontend Consistency: Prolonged the time-breakdown formatter logic throughout all Information Builder datatables, together with runtime view, the Information Preview modal within the builder interface, and the general public embedded report viewer. (Could 1, 2026)\n- Good Time Breakdown: Applied dynamic \"sub-hours\" rendering (Days, Weeks, Months, Years) with thousand separators for long-duration process hour columns exceeding 24 hours. (Could 1, 2026)\n- Template Preset Modal: Unified standing badge and button sizing with constant hole spacing. Shortened \"Already in Views\/Experiences\" label to \"Saved View\" for cleaner format. (Could 1, 2026)\n- Builder Ideas &#38; Information: Added a contextual assist modal (?) to the View Builder toolbar describing Templates, Save as Template, JSON Import\/Export, Preview Information, and Preview SQL options. (Could 1, 2026)\n\nFIXED\n- Timesheet Calculation: Standardized hour calculations throughout all Information Builder templates (e.g., timesheet-by-project-staff, billable-hours) utilizing sturdy SQL Unix timestamp arithmetic ((COALESCE(end_time, UNIX_TIMESTAMP()) - start_time) \/ 3600) as a substitute of the unreliable TIMESTAMPDIFF, making certain correct decimals for each energetic and accomplished timers. (Could 1, 2026)\n- Timestamp Filtering Bug: Mounted a important difficulty the place filtering by date on UNIX timestamp columns (like tbltaskstimers.start_time) failed attributable to MySQL string vs integer comparability. The question builder now routinely wraps recognized UNIX fields in FROM_UNIXTIME(). (Could 1, 2026)\n- Dynamic Filter Duplication: Resolved a logical flaw in Runtime_model the place dynamic UI filters had been redundantly appended with out FROM_UNIXTIME formatting through legacy apply_filters strategies, stopping macros like {{CURDATE}} from precisely returning information. (Could 1, 2026)\n- UI Inconsistency: Eliminated customized bootstrap-select checkbox styling in runtime.css that was overriding and conflicting with customary Perfex CRM core UI parts. (Could 1, 2026)\n- Footer Totals Ignoring Filters: Mounted a bug the place the footer Complete row in report views at all times confirmed aggregated values from the total dataset as a substitute of recalculating based mostly on the person's energetic dynamic filters. The totals rebuild question now passes dynamic_filters to build_query. (Could 1, 2026)\n- JSON Import Hardening: Added file dimension restrict (2 MB), model compatibility examine (2.x), strict Array.isArray validation for tables\/fields, and XSS-safe HTML escaping for user-controlled title\/description earlier than rendering within the affirmation dialog. (Could 1, 2026)\n\n-------- Model 2.2.0 (April 27, 2026) --------\nNEW\n- Added free companion module \"API Information Builder Pattern\" to assist builders shortly reference and combine REST API &#38; GraphQL with Information Builder. Supply: https:\/\/github.com\/PolyXGO\/api_data_builder_sample (April 26, 2026)\n- OWASP Safety Headers: All API responses now embrace X-Content material-Kind-Choices (nosniff), X-Body-Choices (DENY), Referrer-Coverage, and X-XSS-Safety (0) headers. (April 26, 2026)\n- HTTP Cache Management: All API responses embrace Cache-Management: no-store and Pragma: no-cache to forestall proxy\/browser caching of dynamic CRM information. (April 26, 2026)\n- Auth Take a look at Endpoint: GET \/api\/v1\/auth\/take a look at \u2014 Validates API token and returns connection metadata (token title, scopes, tables rely, server time) with out exposing CRM information. Designed for Zapier, Make.com, and n8n connection setup. (April 26, 2026)\n- Polling Assist (?since=): All record endpoints (GET \/api\/v1\/{useful resource}) now settle for a ?since=ISO8601 parameter to filter information by creation\/modification timestamp. Auto-detects Perfex CRM timestamp columns (dateadded, datecreated, and many others.) and returns outcomes sorted newest-first. Permits polling triggers for automation platforms. (April 26, 2026)\n- Endpoint Registry: Auth Take a look at and ?since= parameter now seem in API Explorer sidebar and Public API Docs. (April 26, 2026)\n- Template Catalog \u2014 Consumer Experiences: New class with 5 ready-to-use report templates designed for automated weekly\/month-to-month shopper reporting through API or PDF export. Contains Weekly Venture Upkeep Abstract, Tickets This Week by Consumer, Timesheet Abstract by Venture &#38; Workers, Month-to-month Duties Accomplished by Venture, and Ticket Decision Abstract by Consumer. (April 27, 2026)\n- Formatter \u2014 Activity Precedence: New task_priority formatter converts numeric precedence values (1&#8211;4) to human-readable labels (Low, Medium, Excessive, Pressing) utilizing Perfex's native task_priority() helper. Obtainable in Builder dropdown for any precedence discipline on process tables. (April 27, 2026)\n- Formatter \u2014 Cost Mode: New payment_mode formatter resolves fee mode IDs to their show names through static-cached DB lookup (single question per request). Auto-detected for paymentmode fields. Utilized to Day by day Gross sales by Merchandise template. (April 27, 2026)\n\nCHANGED\n- Db_api_response: Added _set_standard_headers() technique referred to as from success(), error(), and from_context() \u2014 single level of management for all response headers. (April 26, 2026)\n- QueryBuilderTrait: Added _apply_since_filter() technique for shared polling timestamp logic throughout Db_resources and Db_tables controllers. (April 26, 2026)\n- Db_api_base: _parse_query_params() now contains 'since' parameter within the returned array. (April 26, 2026)\n- EndpointRegistryBuilder: GET record endpoints now doc 'since' as an obtainable question parameter. (April 26, 2026)\n- my_routes.php: Added api\/v1\/auth\/take a look at route earlier than wildcard patterns. (April 26, 2026)\n- EndpointRegistryBuilder: GET record endpoints now doc 'since' as an obtainable question parameter. (April 27, 2026)\n- Template_catalog_model: sync_catalog_templates() now updates present system templates (tables_required, config_json, description) as a substitute of skipping them, making certain preset file adjustments propagate to the database on subsequent web page load. (April 27, 2026)\n\nFIXED\n- API Token Type: Mounted JavaScript SyntaxError (\"Sudden finish of enter\") on \/admin\/data_builder\/api_tokens\/kind attributable to lacking IIFE closure `})();`. Cascaded failures: toggleAllPerms undefined (Test All checkboxes), #tablePermFilter unresponsive, HMAC toggle non-functional. (April 26, 2026)\n- ResourceNameResolver: Mounted funds useful resource mapping from non-existent 'tblpaymentsrecords' to the precise 'tblinvoicepaymentrecords', which precipitated 403\/404 on GET \/api\/v1\/funds. (April 26, 2026)\n- AuthGateMiddleware: Moved raw_body caching (php:\/\/enter) earlier than AdminSessionBypass early-return. GraphQL endpoint obtained null raw_body underneath session bypass, inflicting \"Empty Physique\" (400) on POST \/api\/v1\/graphql. (April 26, 2026)\n- Template Catalog: Mounted non-existent desk reference tblstaff_tasks \u2192 tbltask_assigned in Month-to-month Duties Accomplished by Venture template. Mounted JOIN order (tbltask_assigned earlier than tblstaff) to forestall \"Unknown column\" SQL error. (April 27, 2026)\n\n-------- Model 2.1.0 (April 26, 2026) --------\nNEW\n- Outbound Webhook Dispatcher with Pluggable Channel Structure. (April 4, 2026)\n- WebhookEventBus: fires occasions on REST and GraphQL Create\/Replace\/Delete operations. (April 4, 2026)\n- ChannelRegistry: extensible adapter registry (built-in: HTTP\/cURL with HMAC-SHA256). (April 4, 2026)\n- FieldMapper: per-subscription discipline embrace\/exclude\/rename transformations. (April 4, 2026)\n- Admin UI for managing webhook subscriptions, testing, and viewing supply logs. (April 4, 2026)\n- Webhook supply audit log with response codes and timing. (April 4, 2026)\n- Computerized delicate column redaction on outbound payloads. (April 4, 2026)\n- Hook `data_builder_register_webhook_channels` for third-party channel registration. (April 4, 2026)\n- Assist dynamic relative date macros in WHERE situations: {{CURDATE}}, {{CURDATE-7}}, {{CURDATE-30}}, or customized {{CURDATE-n}}, {{CURMONTH-n}}, {{CURYEAR-n}}. (April 20, 2026)\n- Add \"Save as New\" filter button in Runtime Information View for simpler filter duplication. (April 20, 2026)\n- Customizable Header\/Footer branding (\"Powered by...\") on Public Chart pages through Settings. Defaults to Firm Identify and Most important Area. (April 20, 2026)\n- Add \"Set as Default Filter\" checkbox when saving filters. The chosen filter shall be routinely utilized when loading the report in each Admin and Public views. (April 20, 2026)\n- Add Toggle Chart visibility button to each Admin and Public views for higher focus when viewing giant information tables. (April 20, 2026)\n- Add \"Set as Default Filter\" checkbox when saving filters. The chosen filter shall be routinely utilized when loading the report in each Admin and Public views. (April 21, 2026)\n- Add Toggle Chart visibility button to each Admin and Public views for higher focus when viewing giant information tables. (April 21, 2026)\n- New report template: \"Day by day Gross sales by Bill Merchandise\" \u2014 one-click report setup to trace day by day gross sales breakdown by merchandise description, with shopper title, gross sales agent, fee mode, and line-item quantities. (April 21, 2026)\n- New report template: \"Day by day Bill Cost Information\" \u2014 one-click report setup to view at present's fee collections with shopper title, bill quantity, gross sales agent, fee mode, and quantity. Auto-filtered by present date with grand whole. (April 21, 2026)\n- Add \"Minute\" and \"Hourly\" choices to the Chart Interval selector, permitting detailed intraday information visualization for reviews like Bill Cost Information. (April 21, 2026)\n- Add new seasonal report templates for complete gross sales breakdown: \"Month Gross sales by Bill Merchandise\", \"Q1\/Q2\/Q3\/This fall Gross sales by Bill Merchandise\", and \"H1\/H2 Gross sales by Bill Merchandise\". (April 21, 2026)\n- Extends dynamic date macros to help strict vary matches for: {{CURYEAR_Q1}} by {{CURYEAR_Q4}}, {{CURYEAR_H1}}, and {{CURYEAR_H2}}. For different timeframes, customized WHERE situations can be utilized to filter desired durations. (April 21, 2026)\n\nCHANGED\n- Enhance Template Teams format to intuitively show templates in a nested format. (April 20, 2026)\n- Assist deleting customized templates. (April 20, 2026)\n- Assist drag-to-zoom and drag-to-pan interactions for charts. (April 20, 2026)\n- Optimize Public Chart web page format for higher chart visibility. (April 20, 2026)\n- Take away hardcoded ORDER BY \/ Sorting constraints when creating reviews, permitting dynamic datatable sorting. (April 20, 2026)\n- Secured embedded public filters by limiting frontend payloads to pre-saved Server-side Filter IDs, stopping arbitrary question modifications. (April 20, 2026)\n- Secured embedded public filters by limiting frontend payloads to pre-saved Server-side Filter IDs, stopping arbitrary question modifications. (April 21, 2026)\n- Whitelist error dialogs (Preview Information \/ Preview SQL) now render translated instruction textual content as clickable HTML with direct hyperlink to Settings web page, as a substitute of stripping HTML and displaying plain textual content. (April 21, 2026)\n- Enhanced be part of engine to help Bill Objects and Expense-linked Invoices for versatile customized report constructing through the Visible Builder. (April 21, 2026)\n- Template whitelist validation: when loading a preset template, the builder now checks if all required tables can be found. If any are lacking, a warning dialog lists them with a direct hyperlink to Settings. (April 21, 2026)\n\nFIXED\n- Repair information desk synchronization points between Admin reviews and Public Charts (e.g. lacking column totals). (April 20, 2026)\n- Repair lacking forex symbols within the Public Chart information desk. (April 20, 2026)\n- Repair whitelist instruction not displaying correctly in error dialogs when utilizing non-whitelisted tables. (April 21, 2026)\n\n-------- Model 2.0.1 (April 01, 2026) --------\nNEW\n- Complete \"Testing with Postman\" information within the Public API Docs. (April 1, 2026)\n- Clever pattern information formatting for Postman Assortment exports, routinely recognizing column sorts for practical Request Our bodies. (April 1, 2026)\n- Dynamic GraphQL Template generator constructed into the API Explorer and Public Docs, supporting automated question and mutation creation to simplify integration growth. (April 1, 2026)\n- \"Testing with OpenAPI\" documentation part with obtain hyperlink, Swagger UI \/ Insomnia import guides, and step-by-step ChatGPT Customized GPT Actions integration. (April 1, 2026)\n- Actual-world use case gallery for AI-powered CRM evaluation (information evaluation, undertaking standing, shopper insights, unpaid invoices, income reviews, AI reviews). (April 1, 2026)\n- Multi-language HMAC code samples (PHP, Node.js, Python, cURL) with copy-to-clipboard within the Authentication part. (April 1, 2026)\n- Automated HMAC pre-request script embedded in each Postman Assortment exports (Public Docs + API Explorer) with `hmac_secret` assortment variable. (April 1, 2026)\n- Built-in \"Toggle All\" performance for managing Allowed Tables. (April 1, 2026)\n- Applied per-token HMAC signature toggles for granular safety management. (April 1, 2026)\n\nFIXED\n- Resolved clean URL points in Postman Assortment v2.1 export by structuring URLs with `{{baseUrl}}` integration. (April 1, 2026)\n- Question parameters (web page, per_page, kind, fields, filter) now accurately show within the Postman Params tab as optionally available inputs. (April 1, 2026)\n- Mounted OpenAPI YAML export producing invalid `responses` format (sequences as a substitute of status-code mappings) attributable to PHP `array_merge()` re-indexing numeric-string keys; changed with `+` operator. (April 1, 2026)\n\n-------- Model 2.0.0 (March 30, 2026) --------\nNEW\n- Public clean chart view for embedding through iframe. (March 20, 2026)\n- Report Export \/ Import JSON: transportable report definition workflow for backup, sharing, and migration between environments. (March 27, 2026)\n- Report Templates for no-SQL customers: pre-built templates plus \"Save as Template\" to hurry up report creation with out SQL. (March 27, 2026)\n- Template Group administration: arrange templates by enterprise domains; helpful when methods embrace additional tables from third-party modules. (March 27, 2026)\n- Public clean chart view for embedding through iframe. (March 20, 2026)\n- Report teams: arrange impartial reviews into tabbed navigation. (March 20, 2026)\n- Customized filter presets per report view for conditional information show. (March 20, 2026)\n- Column-level aggregation row (sum, avg, rely) at report desk footer. (March 20, 2026)\n- Visible charts with date comparability (day by day\/weekly\/month-to-month\/quarterly\/yearly). Supported sorts: Bar, Line, Space, Doughnut, Radar, Bubble, Combo (Bar+Line), Pie, Scatter, Stepped Line, Level-styling, Interpolation. (March 20, 2026)\n- REST API: versioned read-only endpoints (\/v1\/) for querying Perfex CRM tables and Information Builder views; helps filtering, sorting, discipline choice, and cursor pagination with HATEOAS hyperlinks. (March 20, 2026)\n- GraphQL API: single-endpoint querying with question depth and complexity controls; auto-generated schema per desk and examine; introspection restricted to admin explorer context. (March 22, 2026)\n- GraphQL Mutations: full CRUD through GraphQL (create, replace, delete) with auto-generated InputObjectTypes, major key detection, write scope enforcement, and safety column exclusions. Compliant with GraphQL Spec \u00a76.3.1. (March 22, 2026)\n- API Tokens: scoped entry keys (tables\/views\/GraphQL); IP allowlist (CIDR), area allowlist, per-token fee limiting, optionally available HMAC request signing, and configurable expiry. (March 20, 2026)\n- 7-stage safety middleware pipeline (DDoS protect, CORS, Admin Session Bypass, auth, fee limiter, scope verifier, request logger); all errors returned as RFC 9457 Drawback Particulars. (March 20, 2026)\n- Admin Session Bypass (middleware): permits authenticated Perfex admins to name the API from inside the identical website (API Explorer sandbox) with no Bearer token. Ruled by a configurable setting (data_builder_api_admin_session_bypass); verifies admin session + same-site Origin\/Referer\/XHR dynamically through base_url() \u2014 no hardcoded values. (March 22, 2026)\n- API Explorer: endpoint browser, stay sandbox, code generator (cURL\/JS\/PHP\/Python), Postman v2.1 and OpenAPI 3.0 export. (March 20, 2026)\n- Public clean chart view for embedding through iframe. (March 14, 2026)\n\nUPDATED\n- Chart.js upgraded to 4.5.0, regionally built-in. (March 15, 2026)\n- Information Builder settings moved to Perfex core (Setup -&gt; Settings -&gt; Information Builder). (March 18, 2026)\n\n-------- Model 1.0.0 (March 10, 2026) --------\nNEW\n- Launch model\n<\/pre>\n<p>\n<iframe data-lazy=\"true\" data-src=\"https:\/\/www.fiverr.com\/gig_widgets?id=U2FsdGVkX18x7XQvttUTrv1oEqmGNGTgvvCUiUoJ\/AP4z\/UyMz8lXGOLpu15jIMxBbTR0gmD5uBoFvhC4KWeALQRp3h\/X\/AwcVD0K8Wj9H\/ZzYKzcCNHosB9oS4SCJJFWiN85P9ICAc4OgCoE\/wHKIY7CDkf2\/DQ1vqGvk4smVe5cRDEmrLPCWi4FC8p40VUhSmWQ5udCm0zoJtorgWv3vbDQw0kKYkwn39ozAnQXDe+YvWMxkLFWA+O3TFwkJvdkIK+\/AUSnRssPKt5WHY0FhNOxnSPcLslEL4G4\/RfP95ve99U+kRnDy3X+KtzdQLY+u935ghON\/o3UE4IMv9oN6JX9RnxzL\/LRcOgnHigxStSGPKsZYtnz8RWNVT\/rOLAibqiWJadC5MYHRbekF3eg6FOGrQGkXYbsn0+a5aovnlLCbLwIqY9fcS17UX8J235iQ6cdmHNbrPeS84CMm34RA==&affiliate_id=1052423&strip_google_tagmanager=true\" loading=\"lazy\" data-with-title=\"true\" class=\"fiverr_nga_frame\" frameborder=\"0\" height=\"350\" width=\"100%\" referrerpolicy=\"no-referrer-when-downgrade\" data-mode=\"random_gigs\" onload=\" var frame = this; var script = document.createElement('script'); script.addEventListener('load', function() { window.FW_SDK.register(frame); }); script.setAttribute('src', 'https:\/\/www.fiverr.com\/gig_widgets\/sdk'); document.body.appendChild(script); \" ><\/iframe>\n<br \/>\n<a href=\"https:\/\/1.envato.market\/c\/2840012\/950273\/4415?u=https%3A%2F%2Fcodecanyon.net%2Fitem%2Fdata-builder-for-perfex-crm%2F62297963\">Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>LIVE PREVIEWBUY FOR $59 Notice: This Add-on capabilities as a module for Perfex CRM Click here to view the Changelog &#38; Tasks in Progress Create&#8230;<\/p>\n","protected":false},"author":1,"featured_media":141498,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[47694,47695,47696,19926,47697,28956,47698,3199,29802,323,25389,12013,47699,43014,47700],"class_list":["post-141497","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-codes","tag-api-explorer","tag-api-tokens","tag-chart-report","tag-crm-integration","tag-custom-reports","tag-data-export","tag-embed-charts","tag-graphql","tag-perfex-crm-addon","tag-perfex-crm-module","tag-query-builder","tag-report-builder","tag-report-groups","tag-restful-api","tag-visual-reports"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Builder \u2014 Visual Reporting, REST API &amp; GraphQL for Perfex CRM - mailinvest.blog<\/title>\n<meta name=\"description\" content=\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Builder \u2014 Visual Reporting, REST API &amp; GraphQL for Perfex CRM - mailinvest.blog\" \/>\n<meta property=\"og:description\" content=\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"mailinvest.blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/freelanceracademic\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-20T22:52:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-20T22:53:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mailinvest.blog\/wp-content\/uploads\/2026\/09\/Data-Builder-for-PerfexCRM-590x300.png\" \/>\n\t<meta property=\"og:image:width\" content=\"590\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin@mailinvest.blog\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin@mailinvest.blog\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"28 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/\"},\"author\":{\"name\":\"admin@mailinvest.blog\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/person\\\/012701c4c204d4e4ebd34f926cfd31a4\"},\"headline\":\"Data Builder \u2014 Visual Reporting, REST API &amp; GraphQL for Perfex CRM\",\"datePublished\":\"2026-09-20T22:52:35+00:00\",\"dateModified\":\"2026-09-20T22:53:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/\"},\"wordCount\":2805,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Data-Builder-for-PerfexCRM-590x300.png\",\"keywords\":[\"api explorer\",\"api tokens\",\"chart report\",\"crm integration\",\"custom reports\",\"data export\",\"embed charts\",\"graphql\",\"perfex crm addon\",\"perfex crm module\",\"query builder\",\"report builder\",\"report groups\",\"RestFul API\",\"visual reports\"],\"articleSection\":[\"Code's\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/\",\"name\":\"Data Builder \u2014 Visual Reporting, REST API &amp; GraphQL for Perfex CRM - mailinvest.blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Data-Builder-for-PerfexCRM-590x300.png\",\"datePublished\":\"2026-09-20T22:52:35+00:00\",\"dateModified\":\"2026-09-20T22:53:24+00:00\",\"description\":\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/#primaryimage\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Data-Builder-for-PerfexCRM-590x300.png\",\"contentUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/Data-Builder-for-PerfexCRM-590x300.png\",\"width\":590,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/2026\\\/09\\\/20\\\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/mailinvest.blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Builder \u2014 Visual Reporting, REST API &amp; GraphQL for Perfex CRM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#website\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/\",\"name\":\"mailinvest.blog\",\"description\":\"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis. mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.\",\"publisher\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mailinvest.blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#organization\",\"name\":\"mailinvest\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/default.png\",\"contentUrl\":\"https:\\\/\\\/mailinvest.blog\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/default.png\",\"width\":1000,\"height\":1000,\"caption\":\"mailinvest\"},\"image\":{\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/freelanceracademic\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mailinvest.blog\\\/#\\\/schema\\\/person\\\/012701c4c204d4e4ebd34f926cfd31a4\",\"name\":\"admin@mailinvest.blog\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g\",\"caption\":\"admin@mailinvest.blog\"},\"sameAs\":[\"https:\\\/\\\/mailinvest.blog\",\"admin@mailinvest.blog\"],\"url\":\"https:\\\/\\\/mailinvest.blog\\\/index.php\\\/author\\\/adminmailinvest-blog\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Builder \u2014 Visual Reporting, REST API &amp; GraphQL for Perfex CRM - mailinvest.blog","description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/","og_locale":"en_US","og_type":"article","og_title":"Data Builder \u2014 Visual Reporting, REST API &amp; GraphQL for Perfex CRM - mailinvest.blog","og_description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","og_url":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/","og_site_name":"mailinvest.blog","article_publisher":"https:\/\/www.facebook.com\/freelanceracademic\/","article_published_time":"2026-09-20T22:52:35+00:00","article_modified_time":"2026-09-20T22:53:24+00:00","og_image":[{"width":590,"height":300,"url":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2026\/09\/Data-Builder-for-PerfexCRM-590x300.png","type":"image\/png"}],"author":"admin@mailinvest.blog","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin@mailinvest.blog","Est. reading time":"28 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/#article","isPartOf":{"@id":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/"},"author":{"name":"admin@mailinvest.blog","@id":"https:\/\/mailinvest.blog\/#\/schema\/person\/012701c4c204d4e4ebd34f926cfd31a4"},"headline":"Data Builder \u2014 Visual Reporting, REST API &amp; GraphQL for Perfex CRM","datePublished":"2026-09-20T22:52:35+00:00","dateModified":"2026-09-20T22:53:24+00:00","mainEntityOfPage":{"@id":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/"},"wordCount":2805,"commentCount":0,"publisher":{"@id":"https:\/\/mailinvest.blog\/#organization"},"image":{"@id":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/#primaryimage"},"thumbnailUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2026\/09\/Data-Builder-for-PerfexCRM-590x300.png","keywords":["api explorer","api tokens","chart report","crm integration","custom reports","data export","embed charts","graphql","perfex crm addon","perfex crm module","query builder","report builder","report groups","RestFul API","visual reports"],"articleSection":["Code's"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/","url":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/","name":"Data Builder \u2014 Visual Reporting, REST API &amp; GraphQL for Perfex CRM - mailinvest.blog","isPartOf":{"@id":"https:\/\/mailinvest.blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/#primaryimage"},"image":{"@id":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/#primaryimage"},"thumbnailUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2026\/09\/Data-Builder-for-PerfexCRM-590x300.png","datePublished":"2026-09-20T22:52:35+00:00","dateModified":"2026-09-20T22:53:24+00:00","description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis.mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what's new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","breadcrumb":{"@id":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/#primaryimage","url":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2026\/09\/Data-Builder-for-PerfexCRM-590x300.png","contentUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2026\/09\/Data-Builder-for-PerfexCRM-590x300.png","width":590,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/mailinvest.blog\/index.php\/2026\/09\/20\/data-builder-visual-reporting-rest-api-graphql-for-perfex-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mailinvest.blog\/"},{"@type":"ListItem","position":2,"name":"Data Builder \u2014 Visual Reporting, REST API &amp; GraphQL for Perfex CRM"}]},{"@type":"WebSite","@id":"https:\/\/mailinvest.blog\/#website","url":"https:\/\/mailinvest.blog\/","name":"mailinvest.blog","description":"Technology is forever changing, and there are always new pieces of technology to replace obsolete ones. Tons of people enjoy reading tech blogs on a daily basis. mailinvest.blog tracks all the latest consumer technology breakthroughs and shows you what&#039;s new, what matters and how technology can enrich your life. mailinvest.blog also provides the information, tools, and advice that helps when deciding what to buy.","publisher":{"@id":"https:\/\/mailinvest.blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mailinvest.blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/mailinvest.blog\/#organization","name":"mailinvest","url":"https:\/\/mailinvest.blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mailinvest.blog\/#\/schema\/logo\/image\/","url":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/01\/default.png","contentUrl":"https:\/\/mailinvest.blog\/wp-content\/uploads\/2022\/01\/default.png","width":1000,"height":1000,"caption":"mailinvest"},"image":{"@id":"https:\/\/mailinvest.blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/freelanceracademic\/"]},{"@type":"Person","@id":"https:\/\/mailinvest.blog\/#\/schema\/person\/012701c4c204d4e4ebd34f926cfd31a4","name":"admin@mailinvest.blog","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/98ed217bd0f3d6a6dcae2d9b0c76e305b049a07275e315e1407e19ec8b08e139?s=96&d=mm&r=g","caption":"admin@mailinvest.blog"},"sameAs":["https:\/\/mailinvest.blog","admin@mailinvest.blog"],"url":"https:\/\/mailinvest.blog\/index.php\/author\/adminmailinvest-blog\/"}]}},"_links":{"self":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/posts\/141497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/comments?post=141497"}],"version-history":[{"count":1,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/posts\/141497\/revisions"}],"predecessor-version":[{"id":141499,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/posts\/141497\/revisions\/141499"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/media\/141498"}],"wp:attachment":[{"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/media?parent=141497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/categories?post=141497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mailinvest.blog\/index.php\/wp-json\/wp\/v2\/tags?post=141497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}