Ponto Mais is a time and attendance and working hours management platform. With it, you can monitor clock-ins and clock-outs, work schedules, time banks and other essential aspects of your employees’ routine.
With the BIMachine + Ponto Mais integrator, you can analyze attendance indicators, absenteeism, overtime, among others, in an intuitive, visual way and integrated with your company’s other management analyses.
Obtaining an access key
To use this API, you first need to obtain the token for your database. To do this, follow these steps:
- Go to: https://app.pontomais.com.br/#/acessar;
- Log in using your company administrator credentials;
- In the left-hand menu, click on Marketplace;
- In the “Pontomais API” area, click on Learn more;
- Contract the API (if you haven’t already done so);
- After contracting, the “Public token” field will be displayed, which contains the API access token.
🔗 Learn more about this process in the official Ponto Mais documentation.
After that, create a connection in BIMachine with this token to use later when creating the structure.
Creating integration in BIMachine
With the Ponto Mais connection ready, all you have to do is create the data structure within BIMachine. Go to “Data and Integrations” in the “Manage environment” icon. To do this, access the structure creation menu and look for the new data source option.
When you access the Data and Integrations environment, click on the “+” icon, then Data Source.
A pop-up will open, look for the Ponto Mais integration.
You will be redirected to the screen for creating a new data structure. You must enter the name and description of the new structure. Once you have filled in the name and description, click next.
Next, select the connection and choose which integration you would like to make with Ponto Mais data.
Additional Filters (Row Filters)
Some Ponto Mais integration endpoints require mandatory filters called row_filters to be filled in. These filters are used to search for only the data needed, avoiding information overload and improving query performance.
In BIMachine, you will find an input field to fill in the filter parameters. They must be entered separately with commas, as shown in the example below
Example of use (for the Jornada endpoint):
with_inactives,has_time_cards
Check the filters available for each endpoint in the official Ponto Mais documentation.
Note: Not all API endpoints require mandatory filters. When this happens, you can leave the field empty and the query will be carried out normally.
Conclusion
Once you have configured the integration and adjusted the data according to your needs, you can start analyzing your team’s information directly in the BIMachine environment.
If you have any questions about structuring or standardizing the data, see our article on classifying structures or contact our technical support.