Info

Created 22-01-2021 by Lavinia Gheghea

Revision



Description

The API allows you to get job ledger entry

Endpoints


GET:  /getjobledgerentry


Parameters
Headers and Query
 Name
 Description
 Type
 API-key - required
 Authorization Token
 String(64)
 UID - required
 UID -how can be obtained
 String
 DEVICEID - required
 DEVICEID
 String
 offset
 starting record
 Integer
 limit
 how many records displayed on a page
 Integer
 OrderFieldName
 field name to order the recordset
 String
 OrderDirection
 ASC or DESC
 String
 Filter
 filter the recordset
 String
Curl example

curl -X GET "https://smartapi.smarttid.dk/getjoblegderentry" -H "accept: */*" -H "UID: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx" -H "DEVICEID:demo@smarttid.dk" -H "API-Key: "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"

Response

200 (OK) :  array of jobledger entry

Response body
[  
{
    "ID": 1,
    "EmployeeCode": "0019",
    "Date": "2018-04-03T00:00:00",
    "Name": "Per Hansen",
    "JobCode": "1562",
    "OperationCode": null,
    "JobOperationLineNumber": 10,
    "OperationDescription": null,
    "ActivityCode": null,
    "ActivityDescription": null,
    "Completed": false,
    "WorkTypeCode": "NORMAL",
    "StartTime": "2018-04-03T06:00:00",
    "EndTime": "2018-04-03T08:07:00",
    "TotalTime": 2.1166666666666667,
    "ERPReference": null,
    "TaskID": null,
    "WorkFunctionCode": null,
    "DistrictCode": null,
    "DepartmentCode": "",
    "EmployeeGroupCode": null,
    "Setup": false,
    "JournalCode": "TIME",
    "DimensionCode1": null,
    "DimensionCode2": null,
    "DimensionCode3": null,
    "DimensionCode4": null,
    "DimensionCode5": null,
    "DimensionCode6": null,
    "DimensionCode7": null,
    "DimensionCode8": null,
    "DimensionCode9": null,
    "DimensionCode10": null,
    "PayrollTypeCode": null,
    "OverTimeCode": null,
    "Remarks": null,
    "JournalLineID": 1390,
    "JournalLineEntryID": 1391,
    "JobJournalID": 3459,
    "PayrollReference": "0001, 0012",
    "Quantity": 0
  },
  {
    "ID": 6,
    "EmployeeCode": "0019",
    "Date": "2018-04-04T00:00:00",
    "Name": "Per Hansen",
    "JobCode": "1562",
    "OperationCode": null,
    "JobOperationLineNumber": 10,
    "OperationDescription": null,
    "ActivityCode": null,
    "ActivityDescription": null,
    "Completed": false,
    "WorkTypeCode": "NORMAL",
    "StartTime": "2018-04-04T07:00:00",
    "EndTime": "2018-04-04T08:52:00",
    "TotalTime": 1.8666666666666667,
    "ERPReference": null,
    "TaskID": null,
    "WorkFunctionCode": null,
    "DistrictCode": null,
    "DepartmentCode": "",
    "EmployeeGroupCode": null,
    "Setup": false,
    "JournalCode": "TIME",
    "DimensionCode1": null,
    "DimensionCode2": null,
    "DimensionCode3": null,
    "DimensionCode4": null,
    "DimensionCode5": null,
    "DimensionCode6": null,
    "DimensionCode7": null,
    "DimensionCode8": null,
    "DimensionCode9": null,
    "DimensionCode10": null,
    "PayrollTypeCode": null,
    "OverTimeCode": null,
    "Remarks": null,
    "JournalLineID": 1391,
    "JournalLineEntryID": 1392,
    "JobJournalID": 3463,
    "PayrollReference": "0001, 0012",
    "Quantity": 0
  },
  {
    "ID": 16,
    "EmployeeCode": "0027",
    "Date": "2018-04-03T00:00:00",
    "Name": "Ulla Thomsen",
    "JobCode": "1562",
    "OperationCode": null,
    "JobOperationLineNumber": 10,
    "OperationDescription": null,
    "ActivityCode": null,
    "ActivityDescription": null,
    "Completed": false,
    "WorkTypeCode": "NORMAL",
    "StartTime": "2018-04-03T06:00:00",
    "EndTime": "2018-04-03T08:07:00",
    "TotalTime": 2.1166666666666667,
    "ERPReference": null,
    "TaskID": null,
    "WorkFunctionCode": null,
    "DistrictCode": null,
    "DepartmentCode": "",
    "EmployeeGroupCode": null,
    "Setup": false,
    "JournalCode": "TIME",
    "DimensionCode1": null,
    "DimensionCode2": null,
    "DimensionCode3": null,
    "DimensionCode4": null,
    "DimensionCode5": null,
    "DimensionCode6": null,
    "DimensionCode7": null,
    "DimensionCode8": null,
    "DimensionCode9": null,
    "DimensionCode10": null,
    "PayrollTypeCode": null,
    "OverTimeCode": null,
    "Remarks": null,
    "JournalLineID": 1394,
    "JournalLineEntryID": 1395,
    "JobJournalID": 3471,
    "PayrollReference": "0001, 0012",
    "Quantity": 0
  },
  {
    "ID": 21,
    "EmployeeCode": "0027",
    "Date": "2018-04-04T00:00:00",
    "Name": "Ulla Thomsen",
    "JobCode": "1562",
    "OperationCode": null,
    "JobOperationLineNumber": 10,
    "OperationDescription": null,
    "ActivityCode": null,
    "ActivityDescription": null,
    "Completed": false,
    "WorkTypeCode": "NORMAL",
    "StartTime": "2018-04-04T07:00:00",
    "EndTime": "2018-04-04T08:52:00",
    "TotalTime": 1.8666666666666667,
    "ERPReference": null,
    "TaskID": null,
    "WorkFunctionCode": null,
    "DistrictCode": null,
    "DepartmentCode": "",
    "EmployeeGroupCode": null,
    "Setup": false,
    "JournalCode": "TIME",
    "DimensionCode1": null,
    "DimensionCode2": null,
    "DimensionCode3": null,
    "DimensionCode4": null,
    "DimensionCode5": null,
    "DimensionCode6": null,
    "DimensionCode7": null,
    "DimensionCode8": null,
    "DimensionCode9": null,
    "DimensionCode10": null,
    "PayrollTypeCode": null,
    "OverTimeCode": null,
    "Remarks": null,
    "JournalLineID": 1395,
    "JournalLineEntryID": 1396,
    "JobJournalID": 3475,
    "PayrollReference": "0001, 0012",
    "Quantity": 0
  },
]
Response headers:
content-encoding: gzip 
 content-length: 238 
 content-type: application/json; charset=utf-8 
 date: Mon, 24 Aug 2020 08:01:23 GMT 
 server: Microsoft-IIS/10.0 
 vary: Accept-Encoding 
 x-pagination: {"totalCount":4,"totalFiltered":4,"Offset":0,"Limit":4,"Returned":4} 
 x-powered-by: ASP.NET

400 (ERROR) : Error message

Response Body
Error message

SQL Procedure 

sp_IntegrationGetJobLedgerEntry