12. Time Sheet

Interface

It allows you:

• to get the Time Sheet list to use with API Methods.

• to create. If you want to update the time sheet you will must to create a new record with minus sign for qty spent. 

Columns that can be used as filters:

• Organization

• Project

• ProjectPhase

• ProjectSubPhase

• Employee

• Department

• Activity

• DateTrx

• IsApproved

Actions can be done:

• list

• create

API Methods:

List:

URL: https://api.socratecloud.com/webapi/rest/time_sheet/list/{version}?startRow={0}&endRow={100}&accessToken={access_token}

Method: GET

Return: JSON object with next format:

{

    "data": [

        {

            "Organization": "Demo SRL",

            "Created": "2014-03-13 16:16:17+0200",

            "CreatedBy": "Demo",

            "Updated": "2014-03-13 16:16:17+0200",

            "UpdatedBy": "Demo",

            "Project": "Servicii",

            "ProjectPhase": null,

            "ProjectSubphase": null,

            "Activity": null,

            "Department": "Demo Trx SRL",

            "ResourceType": null,

            "Resource": null,

            "Product": null,

            "ProductName": null,

            "Team": null,

            "Employee": "Demo",

            "DateTrx": "2014-03-10 00:00:00+0200",

            "QtyEntered": 0,

            "QtySpent": 15,

            "QtyApproved": 0,

            "TimeType": "PL",

            "Description": "Time Sheet"

              "Request_ID": null,

             "RequestNo": null,

             "RequestType": null,

             "RequestCategory": null,

             "RequestProductFamily": null,

            "IsApproved": true,

  "BPartner_ID": 1022314,

     "BPartner": "Test SA",

            "BPartnerName": "Test SA",

            "BillBPartner_ID": 1022616,

            "BillBPartner": "Angajat_3_decont",

            "BillBPartnerName": "Angajat_3_decont"

        }

    ],

    "totalRows": 1

}

Create:

URL: https://api.socratecloud.com/webapi/rest/time_sheet/create/{version}?startRow={0}&endRow={100}&accessToken={access_token}

Method: POST

Return: project value for success or error message (start with "ERROR: ")

Data format:

{

            "Organization": "Demo SRL",

            "Project": "Servicii",

            "ProjectPhase": null,

            "ProjectSubphase": null,

            "Activity": "Activitate",

            "Department": "Test A SRL",

            "ResourceType": null,

            "Resource": null,

            "Product": null,

            "ProductName": null,

            "Team": null,

            "Employee": "Demo SRL",

            "DateTrx": "2015-10-28",

            "QtyEntered": 8,

            "TimeType": "PL",

            "QtyApproved": 480,

            "Description": "Time Sheet",

            "BillBPartner_ID": 1022616,

            "BillBPartner": "Angajat_3_decont",

            "BillBPartnerName": "Angajat_3_decont"

}