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