Help & Support
Follow

Advanced Reporting API: Historical User Assignments

GET /io/reporting/export/userassignments/history

Returns all the cards the authorized user has access to, with history of user assignments.

Resource URL

GET https://{accountname}.leankit.com/io/reporting/export/userassignments/history?token=xyzyz

Resource Information

Requires auth token? Yes
Response formats CSV, TAB, or JSON

Parameters

Name Required Description
token Yes A valid token obtained from the POST /io/reporting/auth API end point.
format No Values: csv, tab, json
Default: csv
header No Values: true, false, 1, 0
When header=true the first row returned is the list of field names. Only applies when format is csv or tab.
Default: true
quotedString No Values: true, false, 1, 0
When quotedString=true all strings are surrounded by quotes. Only applies when format is csv or tab.
Note: if quotedString=false and a value contains the delimiter (comma), quotes will be added around the field value.
Default: true
quoted No Values: true, false, 1, 0
When quoted=true all values are surrounded by quotes, except for empty/missing values. Only applies when format is csv or tab.
Default: false
quotedEmpty No Values: true, false, 1, 0
When quotedEmpty=true all empty/missing values are represented as empty quotes ("").
Default: false
limit No Value: any postive number
Default: 1000000 when format is csv or tab, 100 when format is json
offset No Value: any postive number
Default: 0

Example Request

GET https://myaccount.leankit.com/io/reporting/export/userassignments/history?token=xyxyz

Response

Column Description
Card ID  
Assigned User ID  
Assigned User Full Name  
Assigned User Email Address  
Assigned By User ID  
Unassigned By User ID  
Assigned To Date  
Assigned From Date  
Card Title  
Card Size  
Priority  
Card Type ID  
Card Type Title  
Current Board ID  
Current Board Title  
Assigned By User Email Address  
Assigned By User Full Name  
Unassigned By User Email Address  
Unassigned By User Full Name  
Total Duration (Days)  
Total Duration (Hours)  
Total Duration Minus Weekends (Days)  

Example Response

"Card ID","Assigned User ID","Assigned User Full Name","Assigned User Email Address","Assigned By User ID","Unassigned By User ID","Assigned To Date","Assigned From Date","Card Title","Card Size","Priority","Card Type ID","Card Type Title","Current Board ID","Current Board Title","Assigned By User Email Address","Assigned By User Full Name","Unassigned By User Email Address","Unassigned By User Full Name","Total Duration (Days)","Total Duration (Hours)","Total Duration Minus Weekends (Days)"
"10112914590","25008","Smith, John","john.smith@test.com","25013",,2016-08-10 07:18:54 PM,,"Christine needs virus removal",0,"Critical","10112915283","Risk / Issue","10112914972","IT Board","tom.jones@test.com","Jones, Tom",,,126,3023,90
"10112914592","25075","Williams, Harold","harold.williams@test.com","25082",,2016-06-28 02:22:31 PM,,"B",3,"High","10112915289","Other Work","10112914973","Software Team Board","sarah.johnson@test.com","Johnson, Sarah",,,169,4060,121
Have more questions? Submit a request