Robaws connector · Construction software & ERP
Robaws Power BI connector
Use DigiData as your Robaws Power BI connector and load more than 30 entities without custom API scripts. Sync projects, quotes, items, supplier prices, invoices, payments, planning, and personnel through OData or CSV.
Here you will find the supported data, operation and availability of the connection. Follow the practical guide Robaws Power BI setup guide for the steps in Power BI.
Last reviewed:
The reason
Why connect Robaws to DigiData?
The Robaws connector synchronizes more than 30 supported entities, including projects, quotes, items, supplier prices, invoices, payments, planning and personnel data. OData and CSV make these source records available for reporting. Accounting data from another system is not included and must be added through a separate connector before combining sources in Power BI.
Connecting Robaws to Power BI in short
The Robaws connector is available and synchronizes supported tables such as Projects and Quotations, Articles and Article Groups, Suppliers and Supplier Prices and Invoices and Credit Notes. DigiData offers these source records via OData for Power BI and Excel and via CSV for separate exports. The connector only supplies the entities listed on this page; source permissions, the source API, and your sync schedule determine which records and updates are available. You set up relationships, calculations and dashboards in the reporting tool.
Robaws data model for construction and project management
The Robaws connector synchronizes the listed project, quote, item, invoice, payment and personnel entities. DigiData supplies the source data; you build the reporting model in Power BI.
Robaws API without customization
DigiData maintains the synchronization so that Power BI makers do not have to build against the Robaws API themselves.
Quotes, projects and invoices
Combine commercial pipeline, project planning and financial status in a Power BI model.
Construction reports
Analyze items, payments, planning and project returns with repeatable tables.
Conditions
Availability, setup and conditions
- Availability
- Status: Available. The connector provides the entities listed on this page under "Available data".
- Setup
- Add Robaws in the DigiData dashboard and configure access to the source. DigiData confirms during setup which accounts and entities are available.
- Refresh
- Automatic synchronization based on the integration schedule. New source data will not appear until the source sync and then the Power BI refresh are complete.
- Security
- API keys and tokens for linked applications are stored encrypted.
- Limitations
- Only the listed entities are supported. Availability and timeliness depend in part on the source API and your rights in Robaws. DigiData supplies the source data to DigiData dashboards and the AI agent, and through OData and CSV to your own reporting tool. In Power BI or Excel you set up relationships and measures yourself.
- Price and trial period
- €95 per month for the Robaws connector, plus a €95 monthly DigiData platform fee, without start-up costs. You can test DigiData 14 days for free. View current prices.
What you get
What do you get with the Robaws link?
An overview of what DigiData does with your Robaws data:
Which data
Available Robaws data in DigiData
The following entities are automatically synchronized and available via OData or CSV export:
Robaws data model: tables and relationships
Every OData table starts with Robaws_. A record's key is robawsId; references to other records sit in columns ending in Id, such as projectId. The deletedAt and archivedAt columns come from Robaws: filter on them if you only want active records.
| Table | Contents | Key |
|---|---|---|
| Robaws_Projects | Projects with client (clientId), status, date and site address. | robawsId |
| Robaws_WorkOrders | Work orders with project, client, date, status and whether the work is time and material (timeAndMaterial). | robawsId |
| Robaws_WorkOrderTimeEntries | Hours per work order: employee, hours, billableHours, costPrice and salePrice. | workOrderId → WorkOrders |
| Robaws_Offers | Quotes with client, project and totalExclVat. | robawsId |
| Robaws_SalesInvoices | Sales invoices with date, due date, totalExclVat, openTotal and paidTotal. | robawsId |
| Robaws_SalesInvoiceLineItems | Invoice lines with invoice, project, quantity, price and GL account. | salesInvoiceId → SalesInvoices |
| Robaws_PurchaseInvoices | Purchase invoices with supplier and totals. | robawsId |
| Robaws_Employees | Employees with name and type. | robawsId |
Relationships in your model
- Robaws_WorkOrders.projectId = Robaws_Projects.robawsId
- Robaws_WorkOrderTimeEntries.workOrderId = Robaws_WorkOrders.robawsId
- Robaws_WorkOrderTimeEntries.employeeId = Robaws_Employees.robawsId
- Robaws_SalesInvoiceLineItems.salesInvoiceId = Robaws_SalesInvoices.robawsId
- Robaws_SalesInvoiceLineItems.projectId = Robaws_Projects.robawsId
Check the numbers
For a project, add up the hours through the work orders and the revenue through the invoice lines. Compare the invoiced amount per project with the project overview in Robaws before you calculate margins.
Use cases
What can you do with Robaws data?
Analyze project profitability in Power BI
Monitor item consumption and purchase prices
Invoice status and open item overviews
Capacity planning based on daily planning
How it works
How does the Robaws link work?
Connect Robaws
Link your Robaws account via the DigiData dashboard. Safe and fast.
Select your dates
Check which accounts, environments, and entities are available for this resource. The options differ per connector.
Analyze in Power BI
Use the OData feed in Power BI, Excel or download CSV exports.
Build a Robaws dashboard with AI
Describe which overview of your Robaws data you want to see and the DigiData AI agent builds the dashboard, with filters, drilldowns and a presentation mode for TV screens or meetings. You do not need a Power BI model and you do not pay per viewer.
Often used in: Solution for Construction & Field Service
Robaws in Power BI
Load Robaws tables into Power BI through the DigiData OData feed. Connect quotes, projects, invoices, payments, and planning in one data model for project margin, outstanding invoices, and staffing analysis.
Frequently asked questions
Questions about the Robaws integration
How do I connect Robaws to Power BI?
With DigiData you automatically synchronize Robaws data to an OData feed. In Power BI Desktop, choose 'Get Data', select OData feed and paste the DigiData URL. You can then load, combine and refresh the tables without building a Robaws API connection yourself.
How often is Robaws data refreshed?
DigiData synchronizes Robaws according to your integration schedule. The exact frequency and availability of new records depend on your settings and the source API.
What does the Robaws connection cost?
DigiData charges platform costs plus an amount per active integration. There are no start-up costs and you can test for 14 days for free. View the current price on the prices page.
How do I build a Robaws project report?
Start with projects, time registrations, purchase invoices and sales invoices. Check available project references before joining tables. Fictional example: €100,000 project revenue less €25,000 materials, €27,000 labor and €18,000 subcontracting gives €30,000 profit, or 30%. Define cost rates and allocation in your report model, avoiding double counting materials and purchase invoices.
Which Robaws data is synchronized?
DigiData synchronizes more than 30 entities from Robaws, including projects, articles, invoices, employees, leave and financial data.
Is Robaws suitable for large volumes of data?
Yes, DigiData uses pagination and incremental sync to efficiently process large Robaws environments.
Do I need the Robaws API to get Robaws into Power BI?
You do not need to program against the Robaws API yourself. Create an API key in Robaws and enter the access key and secret in DigiData once. DigiData retrieves the data through the Robaws API, handles pagination and incremental synchronization and provides the result as an OData feed and CSV for Power BI and Excel.
Where can I find the Robaws API documentation?
Robaws publishes the API reference at app.robaws.com/public/api-docs/robaws and explains its use in the 'Robaws API' help article. Custom integrations sign in with the access key and secret of a separate API user. With DigiData you do not call that API yourself: you enter the key once and DigiData handles pagination, limits and the synchronization of more than 30 entities.
How do I create an API key in Robaws?
Create a new user in Robaws and give it a role with access to the modules you want to report on. Tick 'API-only', switch on API access and click 'New access key'. Copy the access key and the secret straight away, because Robaws shows the secret only once. Enter both in DigiData; the role of the API user determines which data DigiData can read.
Combine
Other integrations that may interest you
Most companies do not run on one package. Place Robaws next to your other sources, so that you have one report.
14 days free · no start-up costs
Ready to connect Robaws to DigiData?
Use the trial period to validate the available tables, synchronization and your reporting model with your own data.
