Hi,
I used Times Explorer Report -> TimeFlow Report to Export data in Excel by selecting all the columns available for the report manually after every two weeks. After Exporting, the data was then imported into a database table with have same columns as exported in Excel.
Now I am trying to Import all the data using 7pace API to my application database. I figured about half of the columns from WorkLogWorkItems endpoint and WorkItem endpoint with Expand Parent Item. Following is the list of Columns that I am not able to find, can you please help me with how I can find all those columns. My most urgent need is to find the Approval Fields. Thank you.
| 1 | Approval Status - Urgently Required |
| 2 | Approved By - Urgently Required |
| 3 | Approved - Urgently Required |
| 4 | Track Status |
| 5 | Analysis |
| 6 | Area Level 1 |
| 7 | Area Level 2 |
| 8 | Area Level 3 |
| 9 | Area Level 4 |
| 10 | Area Level 5 |
| 11 | Area Level 6 |
| 12 | Area Level 7 |
| 13 | Iteration Level 1 |
| 14 | Iteration Level 2 |
| 15 | Iteration Level 3 |
| 16 | Iteration Level 4 |
| 17 | Iteration Level 5 |
| 18 | Iteration Level 6 |
| 19 | Iteration Level 7 |
| 20 | Closed Status |
| 21 | Closed Status Code |
| 22 | Closing Comment |
| 23 | Comments |
| 24 | Description |
| 25 | Is Deleted |
| 26 | PersonID |
| 27 | ProjectID |
| 28 | Work Item Form |
| 29 | Work Item FormID |
-
Hello Waqas,
As I replied to you on ticket #30532, the endpoint /api/rest/timeApproval/all is intended to return only the approval information and among others, it returns the fields that you are listing you require: approvalState, approvedByManager and approvalTimestamp.
As for the rest of the fields, please check our API reference in regards to the each individual endpoint you are using to see which fields can be pulled from which endpoint: 7pace Timetracker API Reference. The DevOps fields will have Microsoft_VSTS in front of them, such as Microsoft_VSTS_Common_ClosedDate.
Best regards,
Vanja
Please sign in to leave a comment.
Comments
1 comment