List Timesheets

readByQuery

<readByQuery>
    <object>TIMESHEET</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use TIMESHEET
fields Required string Comma separated list of fields on the object to list. Use * to return all fields.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Set a custom page size between 1 and 1000 items (Default: 100)

Get Timesheet

read

<read>
    <object>TIMESHEET</object>
    <keys>40</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use TIMESHEET
keys Required string The object RECORDNO to get
fields Required string Comma separated list of fields on the object to get. Use * to return all fields.

Create Timesheet

create

<create>
    <TIMESHEET>
        <EMPLOYEEID>E1234</EMPLOYEEID>
        <BEGINDATE>10/05/2014</BEGINDATE>
        <GLPOSTDATE></GLPOSTDATE>
        <DESCRIPTION>hello world</DESCRIPTION>
        <SUPDOCID></SUPDOCID>
        <STATE></STATE>
        <TIMESHEETENTRIES>
            <TIMESHEETENTRY>
                <ENTRYDATE>10/05/2014</ENTRYDATE>
                <QTY>1</QTY>
                <BILLABLE>false</BILLABLE>
                <DEPARTMENTID>100</DEPARTMENTID>
                <LOCATIONID>Corporate</LOCATIONID>
                <PROJECTID>P002-EPSON</PROJECTID>
                <TASKKEY>18</TASKKEY>
                <TIMETYPE></TIMETYPE>
                <CUSTOMERID></CUSTOMERID>
                <VENDORID></VENDORID>
                <EMPLOYEEID></EMPLOYEEID>
                <ITEMID></ITEMID>
                <CLASSID></CLASSID>
                <DESCRIPTION></DESCRIPTION>
                <NOTES>my entry</NOTES>
                <EXTBILLRATE></EXTBILLRATE>
                <EXTCOSTRATE></EXTCOSTRATE>
            </TIMESHEETENTRY>
        </TIMESHEETENTRIES>
    </TIMESHEET>
</create>

Parameters

Name Required Type Description
TIMESHEET Optional object The object to create

TIMESHEET

Name Required Type Description
EMPLOYEEID Required string Employee ID
BEGINDATE Required string Begin date in format mm/dd/yyyy
GLPOSTDATE Optional string GL posting date in format mm/dd/yyyy
DESCRIPTION Optional string Description
SUPDOCID Optional string Attachments ID
STATE Optional string Action. Use Draft or Submitted. (Default: Submitted)
TIMESHEETENTRIES Required TIMESHEETENTRY[] Timesheet entries, must have at least 1.

TIMESHEETENTRY

Name Required Type Description
LINENO Optional integer Line number to add entry to
CUSTOMERID Optional string Customer ID
ITEMID Optional string Item ID
PROJECTID Optional string Project ID
TASKKEY Optional integer Task record number
TIMETYPE Optional string Time type
BILLABLE Optional boolean Billable. Use false for No, true for Yes. Default depends on other selections
LOCATIONID Optional string Location ID
DEPARTMENTID Optional string Department ID
ENTRYDATE Required string Entry date in format mm/dd/yyyy
QTY Required number Hours/Quantity
DESCRIPTION Optional string Description
NOTES Optional string Notes
VENDORID Optional string Vendor ID
CLASSID Optional string Class ID
CONTRACTID Optional string Contract ID
WAREHOUSEID Optional string Warehouse ID
EXTBILLRATE Optional currency External bill rate
EXTCOSTRATE Optional currency External cost rate
Custom fields Optional varies This object supports custom fields.

Create Timesheet (Legacy)

create_timesheet

<create_timesheet>
    <employeeid>1001</employeeid>
    <begindate>
        <year>2012</year>
        <month>8</month>
        <day>16</day>
    </begindate>
    <timesheetdescription>Fred's Timesheet</timesheetdescription>
    <timesheetitems>
        <timesheetitem>
            <customerid>1001</customerid>
            <itemid>R0044</itemid>
            <locationid>ARL-VA-US</locationid>
            <departmentid>CS</departmentid>
            <entrydate>
                <year>2012</year>
                <month>8</month>
                <day>16</day>
            </entrydate>
            <qty>1.25</qty>
            <customfields>
                <customfield>
                    <customfieldname>MYFIELD</customfieldname>
                    <customfieldvalue>hello</customfieldvalue>
                </customfield>
            </customfields>
        </timesheetitem>
    </timesheetitems>
</create_timesheet>

Parameters

Name Required Type Description
employeeid Required string Employee ID
begindate Required object Begin date
glpostdate Optional object GL posting date
timesheetdescription Optional string Description
state Optional string Action. Use Draft or Submitted. (Default: Submitted)
timesheetitems Required timesheetitem[] Timesheet entries, must have at least 1.

begindate

Name Required Type Description
year Required string Year yyyy
month Required string Month mm
day Required string Day dd

glpostdate

Name Required Type Description
year Required string Year yyyy
month Required string Month mm
day Required string Day dd

timesheetitem

Name Required Type Description
lineno Optional integer Line number to add entry to
customerid Optional string Customer ID
itemid Optional string Item ID
projectid Optional string Project ID
taskname Optional string Task name
timetype Optional string Time type
billable Optional boolean Billable. Use false for No, true for Yes. Default depends on other selections
locationid Optional string Location ID
departmentid Optional string Department ID
entrydate Required object Entry date
qty Required number Hours/Quantity
timesheetentrydescription Optional string Description
notes Optional string Notes
vendorid Optional string Vendor ID
classid Optional string Class ID
contractid Optional string Contract ID
warehouseid Optional string Warehouse ID
extbillrate Optional currency External bill rate
extcostrate Optional currency External cost rate
customfields Optional customfield[] Custom fields

entrydate

Name Required Type Description
year Required string Year yyyy
month Required string Month mm
day Required string Day dd

Update Timesheet

Updating a timesheet is effectively a complete replace of the existing timesheet and all of its entries. Be careful with this!

update

<update>
    <TIMESHEET>
        <RECORDNO>1</RECORDNO>
        <EMPLOYEEID>E1234</EMPLOYEEID>
        <BEGINDATE>10/05/2014</BEGINDATE>
        <GLPOSTDATE></GLPOSTDATE>
        <DESCRIPTION>hello world</DESCRIPTION>
        <SUPDOCID></SUPDOCID>
        <STATE></STATE>
        <TIMESHEETENTRIES>
            <TIMESHEETENTRY>
                <ENTRYDATE>10/05/2014</ENTRYDATE>
                <QTY>1</QTY>
                <BILLABLE>false</BILLABLE>
                <DEPARTMENTID>100</DEPARTMENTID>
                <LOCATIONID>Corporate</LOCATIONID>
                <PROJECTID>P002-EPSON</PROJECTID>
                <TASKKEY>18</TASKKEY>
                <TIMETYPE></TIMETYPE>
                <CUSTOMERID></CUSTOMERID>
                <VENDORID></VENDORID>
                <EMPLOYEEID></EMPLOYEEID>
                <ITEMID></ITEMID>
                <CLASSID></CLASSID>
                <DESCRIPTION></DESCRIPTION>
                <NOTES>my entry</NOTES>
                <EXTBILLRATE></EXTBILLRATE>
                <EXTCOSTRATE></EXTCOSTRATE>
            </TIMESHEETENTRY>
        </TIMESHEETENTRIES>
    </TIMESHEET>
</update>

Parameters

Name Required Type Description
TIMESHEET Optional object The object to update

TIMESHEET

Name Required Type Description
RECORDNO Required integer Record number of object
EMPLOYEEID Required string Employee ID
BEGINDATE Required string Begin date in format mm/dd/yyyy
GLPOSTDATE Optional string GL posting date in format mm/dd/yyyy
DESCRIPTION Optional string Description
SUPDOCID Optional string Attachments ID
STATE Optional string Action. Use Draft or Submitted. (Default: Submitted)
TIMESHEETENTRIES Required TIMESHEETENTRY[] Timesheet entries, must have at least 1.

TIMESHEETENTRY

Name Required Type Description
LINENO Optional integer Line number to add entry to
CUSTOMERID Optional string Customer ID
ITEMID Optional string Item ID
PROJECTID Optional string Project ID
TASKKEY Optional integer Task record number
TIMETYPE Optional string Time type
BILLABLE Optional boolean Billable. Use false for No, true for Yes. Default depends on other selections
LOCATIONID Optional string Location ID
DEPARTMENTID Optional string Department ID
ENTRYDATE Required string Entry date in format mm/dd/yyyy
QTY Required number Hours/Quantity
DESCRIPTION Optional string Description
NOTES Optional string Notes
VENDORID Optional string Vendor ID
CLASSID Optional string Class ID
CONTRACTID Optional string Contract ID
WAREHOUSEID Optional string Warehouse ID
EXTBILLRATE Optional currency External bill rate
EXTCOSTRATE Optional currency External cost rate
Custom fields Optional varies This object supports custom fields.

Update Timesheet (Legacy)

Updating a timesheet is effectively a complete replace of the existing timesheet and all of its entries. Be careful with this!

update_timesheet

<update_timesheet key="1234">
    <employeeid>E0003</employeeid>
    <begindate>
        <year>2015</year>
        <month>11</month>
        <day>15</day>
    </begindate>
    <timesheetdescription>Hello world</timesheetdescription>
    <timesheetitems>
        <timesheetitem>
            <lineno>2</lineno>
            <customerid>C0002</customerid>
            <projectid>P0005</projectid>
            <taskname>Phone Support</taskname>
            <locationid>ARL-VA-US</locationid>
            <departmentid>CS</departmentid>
            <entrydate>
                <year>2015</year>
                <month>11</month>
                <day>18</day>
            </entrydate>
            <qty>9</qty>
            <timesheetentrydescription>Supporting Bill on phone</timesheetentrydescription>
        </timesheetitem>
    </timesheetitems>
</update_timesheet>

Parameters

Name Required Type Description
key Required integer Record number of timesheet to update
employeeid Required string Employee ID
begindate Required object Begin date
glpostdate Optional object GL posting date
timesheetdescription Optional string Description
state Optional string Action. Use Draft or Submitted. (Default: Submitted)
timesheetitems Required timesheetitem[] Timesheet entries, must have at least 1.

begindate

Name Required Type Description
year Required string Year yyyy
month Required string Month mm
day Required string Day dd

glpostdate

Name Required Type Description
year Required string Year yyyy
month Required string Month mm
day Required string Day dd

timesheetitem

Name Required Type Description
lineno Optional integer Line number to add entry to
customerid Optional string Customer ID
itemid Optional string Item ID
projectid Optional string Project ID
taskname Optional string Task name
timetype Optional string Time type
billable Optional boolean Billable. Use false for No, true for Yes. Default depends on other selections
locationid Optional string Location ID
departmentid Optional string Department ID
entrydate Required object Entry date
qty Required number Hours/Quantity
timesheetentrydescription Optional string Description
notes Optional string Notes
vendorid Optional string Vendor ID
classid Optional string Class ID
contractid Optional string Contract ID
warehouseid Optional string Warehouse ID
extbillrate Optional currency External bill rate
extcostrate Optional currency External cost rate
customfields Optional customfield[] Custom fields

entrydate

Name Required Type Description
year Required string Year yyyy
month Required string Month mm
day Required string Day dd

Delete Timesheet

delete

<delete>
    <object>TIMESHEET</object>
    <keys>112</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use CUSTOMER
keys Required string The timesheet RECORDNO to delete

List Timesheet Entries

readByQuery

<readByQuery>
    <object>TIMESHEETENTRY</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use TIMESHEETENTRY
fields Required string Comma separated list of fields on the object to list. Use * to return all fields.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Set a custom page size between 1 and 1000 items (Default: 100)

Get Timesheet Entry

read

<read>
    <object>TIMESHEETENTRY</object>
    <keys>40</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use TIMESHEETENTRY
keys Required string The object RECORDNO to get
fields Required string Comma separated list of fields on the object to get. Use * to return all fields.

Provide feedback