TimesheetTimeRow Examples

Query Timesheet Time Rows

Query for timesheet rows.

[
  {
    "Action": "Query",
    "QueryType": "TimesheetTimeRowAll",
    "DomainType": "Replicon.TimeSheet.Domain.TimesheetTimeRow",
    "Args": []
  }
]

Query Timesheet Time Rows by Id

Query for timesheet rows by Id.

[
  {
    "Action": "Query",
    "QueryType": "TimesheetTimeRowById",
    "DomainType": "Replicon.TimeSheet.Domain.TimesheetTimeRow",
    "Args": [
      [
        224
      ]
    ]
  }
]

Query Timesheet Rows by UDF Value

Query for timesheet rows by a user defined field value.

[
  {
    "Action": "Query",
    "QueryType": "TimesheetRowsEqualToUDFValue",
    "DomainType": "Replicon.TimeSheet.Domain.TimesheetTimeRow",
    "Args": [
      "Region",
      2
    ]
  }
]

Query Timesheet Rows by Null UDF Value

Query for timesheet rows by an empty user defined field value.

[
  {
    "Action": "Query",
    "QueryType": "TimesheetRowsNullUDFValue",
    "DomainType": "Replicon.TimeSheet.Domain.TimesheetTimeRow",
    "Args": [
      "Exported"
    ]
  }
]

Add Timesheet Row with Billing by Project Rate

Add a timesheet row to an existing timesheet for a project/task billed at a project rate.

[
  {
    "Action": "Edit",
    "Type": "Replicon.TimeSheet.Domain.Timesheet",
    "Identity": "46",
    "Operations": [
      {
        "__operation": "CollectionAdd",
        "Collection": "TimeRows",
        "Operations": [
          {
            "__operation": "SetProperties",
            "Task": {
              "__type": "Replicon.Project.Domain.Task",
              "Identity": "8"
            },
            "Client": {
              "__type": "Replicon.Project.Domain.Client",
              "Identity": "2"
            }
          },
          {
            "__operation": "SetTaskRowBilling",
            "BillingType": {
              "__type": "Replicon.Project.Domain.Timesheets.TimesheetBillingType",
              "Identity": "ProjectRate"
            },
            "Project": {
              "__type": "Replicon.Project.Domain.Project",
              "Identity": "1"
            }
          }
        ]
      }
    ]
  }
]

Add Timesheet Row with Billing by User Rate

Add a timesheet row to an existing timesheet for a project/task billed at a user rate.

[
  {
    "Action": "Edit",
    "Type": "Replicon.TimeSheet.Domain.Timesheet",
    "Identity": "46",
    "Operations": [
      {
        "__operation": "CollectionAdd",
        "Collection": "TimeRows",
        "Operations": [
          {
            "__operation": "SetProperties",
            "Task": {
              "__type": "Replicon.Project.Domain.Task",
              "Identity": "8"
            },
            "Client": {
              "__type": "Replicon.Project.Domain.Client",
              "Identity": "2"
            }
          },
          {
            "__operation": "SetTaskRowBilling",
            "BillingType": {
              "__type": "Replicon.Project.Domain.Timesheets.TimesheetBillingType",
              "Identity": "UserOverrideRate"
            },
            "User": {
              "__type": "Replicon.Domain.User",
              "Identity": "2"
            },
            "Project": {
              "__type": "Replicon.Project.Domain.Project",
              "Identity": "1"
            }
          }
        ]
      }
    ]
  }
]

Add Timesheet Row with Billing by Project Role

Add a timesheet row to an existing timesheet for a project/task billed at a project role rate.

[
  {
    "Action": "Edit",
    "Type": "Replicon.TimeSheet.Domain.Timesheet",
    "Identity": "46",
    "Operations": [
      {
        "__operation": "CollectionAdd",
        "Collection": "TimeRows",
        "Operations": [
          {
            "__operation": "SetProperties",
            "Task": {
              "__type": "Replicon.Project.Domain.Task",
              "Identity": "8"
            },
            "Client": {
              "__type": "Replicon.Project.Domain.Client",
              "Identity": "2"
            }
          },
          {
            "__operation": "SetTaskRowBilling",
            "BillingType": {
              "__type": "Replicon.Project.Domain.Timesheets.TimesheetBillingType",
              "Identity": "RoleRate"
            },
            "ProjectRole": {
              "__type": "Replicon.Project.Domain.ProjectRole",
              "Identity": "2"
            },
            "Project": {
              "__type": "Replicon.Project.Domain.Project",
              "Identity": "1"
            }
          }
        ]
      }
    ]
  }
]

Add Timesheet Row with Billing by Department

Add a timesheet row to an existing timesheet for a project/task billed at a department rate.

[
  {
    "Action": "Edit",
    "Type": "Replicon.TimeSheet.Domain.Timesheet",
    "Identity": "46",
    "Operations": [
      {
        "__operation": "CollectionAdd",
        "Collection": "TimeRows",
        "Operations": [
          {
            "__operation": "SetProperties",
            "Task": {
              "__type": "Replicon.Project.Domain.Task",
              "Identity": "8"
            },
            "Client": {
              "__type": "Replicon.Project.Domain.Client",
              "Identity": "2"
            }
          },
          {
            "__operation": "SetTaskRowBilling",
            "BillingType": {
              "__type": "Replicon.Project.Domain.Timesheets.TimesheetBillingType",
              "Identity": "DepartmentOverrideRate"
            },
            "BillingDepartment": {
              "__type": "Replicon.Domain.Department",
              "Identity": "2"
            },
            "Project": {
              "__type": "Replicon.Project.Domain.Project",
              "Identity": "1"
            }
          }
        ]
      }
    ]
  }
]