Please enable JavaScript.
Coggle requires JavaScript to display documents.
Map Paycor Time CSV to 7pace, Get List of Work Logs for Whole System,…
Map Paycor Time CSV to 7pace
Populated Paycor CSV Headings
A.) Client #
121965
B.) Payroll
Next Level 62 PR
C.) Paygroup
payroll
D.) Employee Last Name
E.) Employee First Name
F.) Employee Number
G.) Badge Number
H.) Base/Home Department
I.) Base/HomeDept Number
J.) Worked Department
K.) Worked Dept Number
L.) Date
O.) Labor Code 1
P.) Labor Code Number 1
AA.) Earning Code
AB.) Hours Amount
Non-Populated Paycor CSV Headings
M.) Punch In
N.) Punch Out
Q.) Labor Code 2
R.) Labor Code Number 2
S.) Labor Code 3
T.) Labor Code Number 3
U.) Labor Code 4
V.) Labor Code Number 4
W.) Labor Code 5
X.) Labor Code Number 5
Y.) Labor Code 6
Z.) Labor Code Number 6
AC.) Note
Which of these are needed, if any?
7pace Mapping
Hard Coded
Dynamic Data
Requires Text Processing
Requires Manual Mapping
Same Values?
Requires Manual Mapping
Tied to specific User?
Multiple work logs with same Id and Different Dates
Need to ask about this but think will Require Manual Mapping
Get List of Work Logs for Whole System
Request Parameters
Optional
$skip: Number of items to skip
$expand: The expand parameters for model attributes. Possible options are {user.displayName}
$fromTimestamp: Return worklogs with timestamp greater than value
$toTimestamp: Return worklogs with timestamp less than value
$fromCreatedTimestamp: Return worklogs with created timestamp less than value
$workItemIds: Filter worklogs by Work Item Ids. Comma separated array, no more than 100 at once
$count: Number of items to take. Max: 500
Required
api-version: (Required) Timetracker API version
3.2
for this document
Response Body
data: array of objects
required
timestamp: <string> "YYYY-MM-DDTHH:MM:SS"
length: <integer>
billableLength: <integer>
workItemId: <integer>: 7pace time is tracked
comment: <string>
required JSON objects
activityType: <JSON>
color: <string> "000000"
name: <string>
id: <string> "UUID?"
flags: <JSON>
isTracked: <boolean>
isManuallyEntered: <boolean>
isChanged: <boolean>
isTrackedExtended: <boolean>
isImported: <boolean>
isFromApi: <boolean>
isBillable: <boolean>
user
displayName
vstsId
vstsCollectionId
email
name
id
uniqueName
addedByUser
uniqueName
displayName
vstsId
vstsCollectionId
email
name
id
editedByUser
uniqueName
displayName
vstsId
vstsCollectionId
email
name
id
createdTimestamp: <string>
editedTimestamp: <string> "YYYY-MM-DDTHH:MM:SS"
id: <string>
Dictionary of email and employee layers