{"id":618,"date":"2020-02-18T12:15:53","date_gmt":"2020-02-18T12:15:53","guid":{"rendered":"https:\/\/i-spark.nl\/uncategorized\/how-to-simplicate-data-ontsluiten-naar-klipfolio\/"},"modified":"2025-11-12T14:41:52","modified_gmt":"2025-11-12T14:41:52","slug":"how-to-extracting-simplicate-data-to-klipfolio","status":"publish","type":"post","link":"https:\/\/i-spark.nl\/en\/blog\/how-to-extracting-simplicate-data-to-klipfolio\/","title":{"rendered":"How to: Extracting Simplicate data to Klipfolio"},"content":{"rendered":"

A number of our customers, including ourselves, use Simplicate. Simplicate is a practical tool for CRM, hour administration, and facturation. In short, great for operational activities. Within the tool, there are efficient reporting possibilities, as well as the possibility to export your data to Excel. With this, you can get your answers to a lot of questions.\u00a0<\/span><\/p>\n

Reports from Simplicate<\/b><\/h3>\n

But sometimes you want to quickly look into specific data in Simplicate without having to click multiple times, download a report, or make a pivot table in Excel. Or, you want to examine your Simplicate data in the context of other data. In this case, Klipfolio<\/a> offers a potential solution, right? Klipfolio is a useful tool for dashboarding, and Simplicate has an API. That sounds easy enough.<\/span><\/p>\n

Simplicate\u2019s API<\/b><\/p>\n

It is indeed true that Simplicate has an API, even one with a lot of documentation. We can definitely extract this data and combine it with other data in Klipfolio. <\/span>
\n<\/span>However, sometimes you need vast amounts of data. By this, we mean truly <\/span>vast amounts<\/span><\/i> of data. Notably, the \u2018hours\u2019 can rack up in huge numbers. Especially when there are many employees and you want to report over longer periods of time. In such a case, the record limit of 100 in an API call can form a significant challenge. The little tricks that we can pull in Klipfolio, with loops and dynamic data sources, can on occasion not be enough.\u00a0<\/span><\/p>\n

But what if we have a lot of data?<\/b><\/h3>\n

For these situations, we have come up with an alternative solution. This solution makes use of the tool Dataddo. In Dataddo, you can create a <\/span>connection <\/span>to Simplicate, making Dataddo retrieve the data. In turn, this data in Dataddo can be accessed in Klipfolio by creating API endpoints in Dataddo. We can also take this one step further by making Dataddo save the data in, for example, Google BigQuery. This way we construct a database with history, and this data is, on its own terms, accessible in Klipfolio through SQL.<\/span><\/p>\n

Thus, it isn\u2019t necessary to deploy development power for this technological link. We simply use pre-existing tooling.\u00a0<\/span><\/p>\n

What can you do with this?<\/b><\/h3>\n

Meanwhile, we have rolled out this solution to a satisfied set of clients. From now on, they can easily report based on hours and revenue, based on a set of filters which they decide upon themselves. Examples of this are employee, project, or date. The solution, in combination with Google BigQuery, generates the capability to look at past values. In this way, you can, for example, compare two references and report on the differences. This is not a possibility for the dashboards within Simplicate. This input is perhaps good discussion material for the evaluation of projects.\u00a0<\/span><\/p>\n

If you have questions about retrieving data from Simplicate to Klipfolio, or if you are interested in a Klipfolio dashboard in which (among other things) Simplicate data is represented? Please feel free to contact us<\/strong><\/a>! We are glad to help you.\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

A number of our customers, including ourselves, use Simplicate. Simplicate is a practical tool for CRM, hour administration, and facturation. In short, great for operational activities. Within the tool, there are efficient reporting possibilities, as well as the possibility to export your data to Excel. With this, you can get your answers to a lot […]<\/p>\n","protected":false},"author":4,"featured_media":8494,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[8],"tags":[184],"class_list":["post-618","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-klipfolio-2"],"acf":[],"_links":{"self":[{"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/posts\/618","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/comments?post=618"}],"version-history":[{"count":9,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/posts\/618\/revisions"}],"predecessor-version":[{"id":9529,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/posts\/618\/revisions\/9529"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/media\/8494"}],"wp:attachment":[{"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/media?parent=618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/categories?post=618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i-spark.nl\/en\/wp-json\/wp\/v2\/tags?post=618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}