Jibble is a time tracking and attendance app that helps companies stay on top of their teams’ activities.
Data integration: Skyvia supports importing data to and from Jibble, exporting Jibble data to CSV files, replicating Jibble data to relational databases, and synchronizing Jibble data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support Jibble backup.
Query: Skyvia Query supports Jibble.
To connect to Jibble, you need to fill out Client Id and Client Secret. To get them, do the following:
- Login to your Jibble account.
Go to Settings -> Organization -> Create New Secret
Create a name for your API Key and click Save.
A pop-up window will appear. Use Copy buttons next to API Key ID and API Key Secret to copy their values.
To create a Jible connection enter your Client Id and Client Secret in the corresponding fields and click Create Connection.
You must set a filter by the Date field to get the records from the Timesheets table. Additionally, you can set a filter by the Period field that accepts the following values: Day, Month, Week.
To run ClockIn (start the timer), run the following procedure and set :type to ‘In’:
call ClockIn(:personId, :type, :activityId, :projectId, :clientType, :platform_clientVersion, :platform_os, :platform_deviceModel, :platform_deviceName, :coordinates_latitude, :coordinates_longitude)
call ClockIn('a2786385-b7a2-4e28-a725-cba33f79229e', 'In', '0eef5b96-dca7-46ae-88a8-a889d5e1973f', 'd15607ac-d2cc-4e14-acbe-3681d069de75', 'web 'Web'.0 ', 'Windows 10', 'MacbookPro', 'TestLaptop', 42, -13.5)
To run ClockOut (stop the timer) run the following procedure and set :type to ‘out’:
call ClockOut(:personId, :type, :clientType, :platform_clientVersion, :platform_os, :platform_deviceModel, :platform_deviceName)
где type = 'Out'
`call ClockOut(‘a2786385-b7a2-4e28-a725-cba33f79229e’, ‘Out’, ‘Web’, ‘web 3.0’, ‘Windows 10’, ‘MacbookPro’, ‘TestLaptop’)
Incremental Replication and Synchronization
Incremenal Replication is supported for the following objects:
Synchronization is supported for the following objects:
Skyvia supports the following DML operations for Jibble objects:
|INSERT, UPDATE, DELETE||Locations, People|
|INSERT||Clients, Groups, Projects|
Skyvia supports all the common actions available for most of the connectors for Jibble.