Jibble
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.
Establishing Connection
Getting Credentials
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.
Creating Connection
To create a Jible connection enter your Client Id and Client Secret in the corresponding fields and click Create Connection.
Connector Specifics
Object Peculiarities
Timesheets
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.
Stored Procedures
ClockIn
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)
Example:
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)
ClockOut
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'
Example:
`call ClockOut(‘a2786385-b7a2-4e28-a725-cba33f79229e’, ‘Out’, ‘Web’, ‘web 3.0’, ‘Windows 10’, ‘MacbookPro’, ‘TestLaptop’)
You can use a call to the stored procedure, for example as a text of the command in the ExecuteCommand action in a Target component of a Data Flow or in Query.
Incremental Replication and Synchronization
Incremenal Replication is supported for the following objects:
- Activities
- Clients
- Groups
- LatestTimeEntries
- Locations
- Organizations
- People
- Projects
Synchronization is supported for the following objects:
- Locations
- People
DML Operations
Skyvia supports the following DML operations for Jibble objects:
Operations | Objects |
---|---|
INSERT, UPDATE, DELETE | Locations, People |
UPDATE | LatestTimeEntries, Organizations |
INSERT | Clients, Groups, Projects |
Supported Actions
Skyvia supports all the common actions available for most of the connectors for Jibble.