We can fetch the Submission Date of a timesheet by using the Relationship named FilteredHistory which gives the Approval History detail data. On the filtered relationship the administrator need's to search for the Approval Status Name Submit and the corresponding Effective Date will give the Submission Date. In case if there are more than one submission date for a timesheet, then there would be multiple Submit status and based on the date we will be able to identify the latest one.

Resolution:
Follow the steps give below to enable full data access to the user running the query:

  • Login to Web TimeSheet with Administrative privileges.
  • Click on Administration in the top menu.
  • In the side menu, click Permissions, under Users/Departments.
  • Click the edit icon beside Administrator permission.
  • Expand Integration and make sure that Can view ALL system data is checked.
  • If it is not enabled, enable the option and click the Save button at the bottom.
  • When done, click on Integration in the top menu.
  • In the left menu click on Test Interface under RepliConnect API.
  • Execute the following query:

Note:
Can view All system data needs to be checked so that the administrator gets full access to Repliconnect API.

              [

  {

    "Action": "Query",

    "QueryType": "TimesheetByUserDate",

    "DomainType": "Replicon.TimeSheet.Domain.Timesheet",

    "Args": [

      {

        "__type": "Replicon.Domain.User",

        "Identity": "3284"

      },

      {

        "__type": "Date",

        "Year": 2012,

        "Month": 2,

        "Day": 5

      }

    ],

    "Load": [

      {

        "Relationship": "FilteredHistory"

      }

    ]

  }

]

The above query would fetch the User’s timesheet date : Feb 5, 2012 with relationship FilteredHistory.