Summary:
A query on RepliConnect API which will provide the name of the user's whose timesheets are overdue.

Resolution:
To resolve the issue, please follow the steps given below :

  • Log in to Web TimeSheet with Administrator privileges.
  • Click on Integration.
  • On the left side of the screen, under RepliConnect API click Test Interface.
  • This would launch the API Request screen.

Type the following query:

[
{
"Action": "Query",
"QueryType": "TimesheetByDateRange",
"DomainType": "Replicon.TimeSheet.Domain.Timesheet",
"Args": [
{
"__type": "Date",
"Year": 2012,
"Month": 1,
"Day": 1
},
{
"__type": "Date",
"Year": 2012,
"Month": 1,
"Day": 10
}
] }
]

Before executing the query, please edit the date range, which would be edited in the part of the query given below :
"__type": "Date",
"Year": 2012,
"Month": 1,
"Day": 1
},
{
"__type": "Date",
"Year": 2012,
"Month": 1,
"Day": 10

After the date range is entered and execute the query and look for the responses given below:
},
"DueDate": {
"Type": "Date",
"Year": 2012,
"Month": 1,
"Day": 14

This would give the Due date for the timesheet. Timesheet's whose due dates are over 2-3 days as defined by the system would be the overdue timesheet's.
Also, check for this response which would give the show the Status of Approval and the output would be as follows:
},
"Relationships": {
"ApprovalStatus": {
"Type": "Replicon.Domain.Approvals.ApprovalStatus",
"Identity": "Open",
"Properties": {
"Name": "Open"
}

Note:
The Approval status which is Open and has crossed the due date would be the timesheet's which are overdue.
However, this query would list all the user's whose timesheets are Approved, Waiting for Approval, Rejected, as well as Open.
The user will be required to look through the timesheets and get the timesheets which are overdue.

Note:
While running the query in case if the user encounters a system.net exception error, please refer to K
b article -1000806

Related Items:

System.net exception error while executing API Query