update Daily Time Hours Import

post

https://api.data-basics.net/apihub/apis/dailyImportUpdate

Provides the ability to update an existing 'New' loadStatus record in the Tm Daily Import Schema. IMPORTANT: Time import module requires the API Site user must have proxy access to the import record's owner. In this case you will need to first create an employee in DATABASICS Admin module with and equal ID to match the API Site user, then give that user proxy access to the user(s) which will be imported via the API call. To successfully give proxy access the following setups must be preformed in order or the proxy access will fail. 1. Setup Employee in DATABASICS Admin 'APIUSER' 2. Give 'APIUSER" Proxy access to user(s) timesheet 3. Create API-Site user 'APIUSER' and be sure to set the API-Site user Id == DATABASICS employee created in step 1 5. Now you can use this API user to make calls and import them via the API

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Query Params

payCode

string

required

Pay Code - Max size 20 Characters

dbHdrStatus

string

required

Status to place timesheet once imported. H = Draft, R = Release, P = Open by the Processor, X = Open by Proxy, O = Open by Owner

totalHours

number

required

Total Hours

emplyId

string

required

Employee ID

entryFormat

string

required

Entry Format. H = hours entry type, T = Time In/Out entry Type

isImport

string

required

Controls action after save. N = Save as New without import after update, Y = Automatically import after update

rowId

string

required

Current records Row Id

dbTmExist

string

required

Specifies how to import the entry into the timesheet. N = New Line, R = Replace, A = Append

note

string

level1Code

string

WBS Level1 Code - Max size 20 Characters

optCode

string

Operation Unit Code - Max size is 20 Characters

batchId

string

Batch parameter gives the ability to import all new entries which have the same batchIds on a single import call. When running the timeImportAll API with a parameter 'B' the API will import all new transactions with a matching batchId.

functcode

string

Function Code

level4Code

string

WBS Level4 Code - Max size 20 Characters

level2Code

string

WBS Level2 Code - Max size 20 Characters

level3Code

string

WBS Level3 Code - Max size 20 Characters

strTimeIn

string

String value for start time if user has Time In Out entry. Format HH:MM. Please note this parameter is required if the user has Time In Out entry.

strTimeOut

string

String value for end time if user has Time In Out entry. Format HH:MM. Please note this parameter is required if the user has Time In Out entry.

eventDateH

string

Event date of which the hours are to be entered if the end user has a timesheet entry type of 'Hours'. Please note the parameter is required if the entry type is hours entry.

locationCode

string

Location Code - Max size 20 Characters

deptCode

string

Department Code

eventDateT

string

Event date of which the hours are to be entered if the end user has a timesheet entry type of 'Time In Out'. Please note the parameter is required if the entry type is Time In Out entry.

Response

200successful operation