TimeTrackingQuery
The time-tracking transactions that are returned in this query include time tracking information that was entered into QuickBooks manually or gathered using the QuickBooks “Timer” or “Stopwatch.” Note that the QuickBooks Timer application can run on its own without QuickBooks, but the QuickBooks SDK cannot access the Timer data directly. The Timer data must be imported into QuickBooks before it is accessible via the SDK.)
Request
Response
XMLOps
VB.NET
C#
| Tag | Type | Max length | Implementation | Required |
|---|---|---|---|---|
ITimeTrackingQuery
The time-tracking transactions that are returned in this query include time tracking information that was entered into QuickBooks manually or gathered using the QuickBooks “Timer” or “Stopwatch.” Note that the QuickBooks Timer application can run on its own without QuickBooks, but the QuickBooks SDK cannot access the Timer data directly. The Timer data must be imported into QuickBooks before it is accessible via the SDK.)
|
||||
metaData
This is used in a query to cause a count of query objects to be returned. You can specify that the count of query objects is to be returned with the returned objects, or you can specify that only a count and no data is returned. (The default is that no count is returned.) A common use of this feature is to specify a count with no data in order to determine how many objects to expect from the actual query. If you don’t want a query to return a count, either don’t use this feature, or specify the value NoMetaData. If you want only a count, specify the value MetaDataOnly. If you want data and a count, specify MetaDataAndResponseData. You should be aware that the count returned via this setting is not guaranteed to be exact: it could be off slightly due to new object creation or deletions.
|
IQBENmetaDataType | 4.0  |
||
iterator
The iterator attribute provided with most query types also allows you to break down query results in smaller and more manageable chunks of data. An iterator results in responses that contain only the specified number of objects. Iterators are only valid for the application that starts them, and they are only valid for the current QuickBooks session.
|
IQBENiteratorType | 5.0 |
||
iteratorID
Returned in the response in the first iteration and supplied in subsequent iterations, this identifies which iteration is to be used in the query continuing the iteration. Required because many different iterations may be currently in use.
|
IQBUUIDType | 5.0 |
||
ORTimeTrackingTxnQuery |
IORTimeTrackingTxnQuery | |||
TxnIDList
One or more TxnID values. QuickBooks generates a unique TxnID for each transaction that is added to QuickBooks. Notice that you cannot supply the TxnID of a TimeTracking transaction to TransactionQuery requests. If you do, you get an error stating that no such record could be found, even though the transaction is in QuickBooks. This behavior reflects the behavior in the QuicKBooks UI in the Find window.
|
IBSTRList | |||
TimeTrackingTxnFilter
The ITimeTrackingTxnFilter group object allows you to search for time-tracking transactions based on which names they refer to and when they were created or last modified.
|
ITimeTrackingTxnFilter | |||
MaxReturned
Limits the number of objects that a query returns. (To get a count of how many objects could possibly be returned, use the metaData query attribute.) If you include a MaxReturned value, it must be at least 1.
|
IQBIntType | |||
ORDateRangeFilter |
IORDateRangeFilter | |||
ModifiedDateRangeFilter
Filters according to the dates when transactions were last modified. The ModifiedDateRangeFilter aggregate is not required to contain any elements, but if it is empty, we recommend that you leave it out altogether. Note that the time portion of the FromModifiedDate and ToModifiedDate fields was not supported in qbXML version 1.0 or 1.1. (To filter according to the dates when transactions were deleted, use a TxnDeletedQuery message.)
|
IModifiedDateRangeFilter | |||
FromModifiedDate
Selects objects modified on or after this date. See the note below regarding QBFC usage.For desktop versions of QuickBooks, the FromModifiedDate and ToModifiedDate must be between 1970-01-01 and 2038-01-19T03:14:07 (2038-01-18T19:14:07-08:00 PST). (The time portion of the field was not supported in qbXML version 1.0 or 1.1.) Also, for desktop versions of QuickBooks, if FromModifiedDate includes a date but not a time (for example, if you set FromModifiedDate to 2003-02-14), the time is assumed to be zero (2003-02-14T00:00:00). If you omit FromModifiedDate, it will be set to 1970-01-01T00:00:00 (1969-12-31T16:00:00-08:00 PST).For QBOE, the FromModifiedDate and ToModifiedDate must be between 1900-01-01T00:00:00 and 9999-12-31T00:00:00. If FromModifiedDate includes a date but not a time (for example, if you set FromModifiedDate to 2003-02-14), the time is assumed to be zero (2003-02-14T00:00:00). If you omit FromModifiedDate, it will be set to 1900-01-01T00:00:00.Note: When specifying this in QBFC, you need to supply the parameter asDateOnly, which is a Boolean. If asDateOnly is true, the date value will be represented as a date only (without a time). If asDateOnly is false, the date value will be represented as date and time, padded with zeros if necessary, and set to the beginning of the day if no time is provided. The asDateOnly parameter is especially useful in the ToModifiedDate field of a query: If asDateOnly is set to true in the ToModifiedDate field of a query, then the query includes elements modified up to the end of the day. If asDateOnly is false, the query includes elements modified up to the specified time (or up to the beginning of the day if no time is included).
|
IQBDateTimeType | |||
ToModifiedDate
Selects objects modified on or before this date. See the note below on QBFC usage.For desktop versions of QuickBooks, the ToModifiedDate and FromModifiedDate must be between 01/01/1970 and 2038-01-19T03:14:07 (2038-01-18T19:14:07-08:00 PST). (Note that the time portion of the field was not supported in qbXML version 1.0 or 1.1.) If ToModifiedDate includes a date but not a time (for example, if you set ToModifiedDate to 2003-02-14), the time is assumed to be the end of the day (2003-02-14T23:59:59). If you omit ToModifiedDate altogether, it will be set to 2038-01-19T03:14:07 (2038-01-18T19:14:07-08:00 PST).For QBOE, the ToModifiedDate and FromModifiedDate must be between 01/01/1900 and 9999-12-31T00:00:00. If ToModifiedDate includes a date but not a time (for example, if you set ToModifiedDate to 2003-02-14), the time is assumed to be the end of the day (2003-02-14T23:59:59). If you omit ToModifiedDate altogether, it will be set to 9999-12-31T00:00:00.Note: When specifying this in QBFC, you need to supply the parameter asDateOnly, which is a Boolean. If asDateOnly is true, the date value will be represented as a date only (without a time). If asDateOnly is false, the date value will be represented as date and time, padded with zeros if necessary, and set to the beginning of the day if no time is provided. The asDateOnly parameter is especially useful in the ToModifiedDate field of a query: If asDateOnly is set to true in the ToModifiedDate field of a query, then the query includes elements modified up to the end of the day. If asDateOnly is false, the query includes elements modified up to the specified time (or up to the beginning of the day if no time is included).
|
IQBDateTimeType | |||
TxnDateRangeFilter
Filters according to the original transaction dates.
|
ITxnDateRangeFilter | |||
ORTxnDateRangeFilter |
IORTxnDateRangeFilter | Y | ||
TxnDateFilter
The ITxnDateFilter group object allows you to filter by transaction creation date.
|
ITxnDateFilter | |||
FromTxnDate
Selects transactions created on or after this date. Both FromTxnDate and ToTxnDate must be between 01/01/1901 and 12/31/9999.If you omit FromTxnDate, it will be set to 1970-01-01 (1969-12-31 PST).
|
IQBDateType | |||
ToTxnDate
Selects transactions created on or before this date. Both ToTxnDate and FromTxnDate must be between 01/01/1901 and 12/31/9999. If you omit ToTxnDate, it will be set to 2038-01-19 (2038-01-18 PST).
|
IQBDateType | |||
DateMacro
Refers to the transaction date, not the last modification date. Do not include DateMacro if either FromModifedDate or ToModifiedDate are specified. If a query does not specify DateMacro, FromModifedDate, or ToModifiedDate, it includes all dates. DateMacro values, in alphabetical order, that are new with QBFC3: dmAll, dmdmLastCalendarQuarter, dmdmLastCalendarQuarterToDate, dmdmLastCalendarYear, dmdmLastCalendarYearToDate, dmLastFiscalQuarterToDate, dmLastFiscalYearToDate, dmLastMonthToDate, dmLastWeekToDate, dmNextCalendarQuarter, dmNextCalendarYear, dmNextFiscalQuarter, dmNextFiscalYear, dmNextFourWeeks, dmNextMonth, dmNextWeek, dmThisCalendarQuarter, dmThisCalendarQuarterToDate, dmThisCalendarYear, dm ThisCalendarYearToDate, dmThisFiscalQuarter, dmThisFiscalYear, dmThisMonth, dmThisWeek, dmThisWeekToDate, dmToday, dmYesterday The list given when you click IQBENDateMacroType shows the complete list of valid version 3.0 values.
|
IQBENDateMacroType | |||
TimeTrackingEntityFilter
Allows you to query for one or more names on the QuickBooks Vendor list, Employee list, or Other Names list.
|
ITimeTrackingEntityFilter | |||
ORTimeTrackingEntityFilter |
IORTimeTrackingEntityFilter | Y | ||
ListIDList
One or more ListID values. Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IBSTRList | |||
FullNameList
A list of one or more FullName values. FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IBSTRList | |||
IncludeRetElementList
You use this if you want to limit the data that will be returned in the response. In this list, you specify the name of each top-level element or aggregate that you want to be returned in the response to the request. You cannot specify fields within an aggregate, for example, you cannot specify a City within an Address: you must specify Address and will get the entire address. The names specified in the list are not parsed, so you must be especially careful to supply valid names, properly cased. No error is returned in the status code if you specify an invalid name. Notice that if you want to return custom data or private data extensions, you must specify the DataExtRet element and you must supply the OwnerID set to either a value of 0 (custom data) or the GUID for the private data.
|
IBSTRList | 50 chars | 4.0 |
| Tag | Type | Max length | Implementation | Required |
|---|---|---|---|---|
IResponse
The time-tracking transactions that are returned in this query include time tracking information that was entered into QuickBooks manually or gathered using the QuickBooks “Timer” or “Stopwatch.” Note that the QuickBooks Timer application can run on its own without QuickBooks, but the QuickBooks SDK cannot access the Timer data directly. The Timer data must be imported into QuickBooks before it is accessible via the SDK.)
|
||||
StatusCode
A number that corresponds to a statusSeverity and statusMessage. Five status codes relate directly to signon messages: 2000, 2010, 2020, 2030, and 2040. For details about these and other statusCode values that can be returned, see the statusCode table on the Error Codes page.
|
IQBIntType | Y | ||
StatusSeverity
One of the following values: INFO The request was completed, and the results are consistent with what your application expected. WARNING The request was completed, but the results might not be consistent with what you expected. ERROR The request was not completed. No data will appear in the server’s response after the statusMessage.
|
IQBStringType | Y | ||
StatusMessage
A user-readable explanation of the success or error condition that is indicated by the statusCode. For details about the statusMessage values that can be returned, see the “Explanation” column of the statusCode table on the Error Codes page.
|
IQBStringType | Y | ||
retCount
The retCount is returned in a query if in the query request you specified the metaData attribute with a value of MetaDataOnly (in which case the retCount is the only data returned in the query response) or MetaDataAndResponseData (the query response contains object data AND the approximate count). The retCount value contains the approximate count of the objects that could be expected to be returned from the query. A common use of this feature is to specify a count with no data in order to determine how many objects to expect from the actual query. You should be aware that the count returned in retCount is not guaranteed to be exact: it could be off slightly due to new object creation or deletions.
|
IQBIntType | 4.0 |
Y | |
iteratorRemainingCount
This attribute is provided in the response in a query using iterators, indicating the number of objects remaining in the iteration. This can help you specify a MaxReturn value tailored to the number of objects still to be iterated through in your query.
|
IQBIntType | 5.0 |
Y | |
iteratorID
Returned in the response in the first iteration and supplied in subsequent iterations, this identifies which iteration is to be used in the query continuing the iteration. Required because many different iterations may be currently in use.
|
IQBUUIDType | 5.0 |
Y | |
Detail |
ITimeTrackingRetList | |||
(List
of ITimeTrackingRet Objects)
|
||||
TxnID
QuickBooks generates a unique TxnID for each transaction that is added to QuickBooks. A TxnID returned from a request can be used to refer to the transaction in subsequent requests. Notice that you cannot supply the TxnID of a TimeTracking transaction to TransactionQueryRq requests. If you do, you get an error stating that no such record could be found, even though the transaction is in QuickBooks. This behavior reflects the behavior in the QuicKBooks UI in the Find window.
|
IQBIDType | Y | ||
TimeCreated
Time the object was created.
|
IQBDateTimeType | Y | ||
TimeModified
Time the object was last modified.
|
IQBDateTimeType | Y | ||
EditSequence
A number that the server generates and assigns to this object. Every time the object is changed, the server will change its EditSequence value. When you try to modify a list object, you must provide its EditSequence. The server compares the EditSequence you provide with the EditSequence in memory to make sure you are dealing with the latest copy of the object. If you are not, the server will reject the request and return an error. Because EditSequence is only used to check whether two objects match, there is no reason to interpret its value.
|
IQBStringType | 16 chars | Y | |
TxnNumber
An identifying number for this transaction.
|
IQBIntType | |||
TxnDate
The date of the transaction. In some cases, if you leave TxnDate out of an -Add message, QuickBooks will prefill TxnDate with the date of the last-saved transaction of the same type.
|
IQBDateType | Y | ||
EntityRef
A QuickBooks “entity” is a customer, vendor, employee, or person on the QuickBooks “other names” list. Special cases to note: In a BillToPayQuery message, EntityRef refers to the vendor name.In JournalCreditLine and JournalDebitLine messages for A/R accounts, EntityRef must refer to a customer, or else the transaction will not be recorded. For A/P accounts the EntityRef must refer to a vendor, or else the transaction will not be recorded.In a TimeTracking message, EntityRef cannot refer to a customer, only to an employee, vendor, or person on the “other names” list whose time is being tracked.
|
IQBBaseRef | Y | ||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 209 chars | ||
CustomerRef
The customer list includes information about the QuickBooks user’s customers and the individual jobs that are being performed for them. A CustomerRef aggregate refers to one of the customers (or customer jobs) on the list. In a request, if a CustomerRef aggregate includes both FullName and ListID, FullName will be ignored. Special cases to note:In SalesReceipt and ReceivePayment requests, CustomerRef refers to the customer or customer job to which the payment is credited.In a TimeTracking request, CustomerRef refers to the customer or customer job to which this time could be billed. If IsBillable is set to true, CustomerRef is required in TimeTrackingAdd. In an ExpenseLineAdd request, if AccountRef refers to an A/P account, CustomerRef must refer to a vendor (not to a customer). If AccountRef refers to any other type of account, the CustomerRef must refer to a customer.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 209 chars | ||
ItemServiceRef
A service item refers to services that a business charges for or purchases. Examples include specialized labor, consulting hours, and professional fees. An ItemServiceRef aggregate refers to an item on the ItemService list. In a request, if an ItemServiceRef aggregate includes both FullName and ListID, FullName will be ignored. In a TimeTracking message, ItemServiceRef refers to the type of work. If no CustomerRef is specified, then ItemServiceRef is not needed. If IsBillable is set to true, then TimeTrackingAdd must include both ItemServiceRef and CustomerRef.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
Duration
Time spent doing the work. In a TimeTrackAdd request, notice that although you can specify seconds, seconds are not returned in the response because the UI does not use seconds.
|
IQBTimeIntervalType | Y | ||
ClassRef
Classes can be used to separate transactions into meaningful categories. (For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. A ClassRef aggregate refers to one of these named classes. For example, in a TimeTracking message, ClassRef refers to the QuickBooks class into which the timed activity falls. If a ClassRef aggregate includes both FullName and ListID, FullName will be ignored. In an InvoiceAdd request, if you specify a ClassRef for the whole invoice, that same ClassRef is automatically used in the line items. If you want to clear that (that is, have NO ClassRef for the line item, you can clear it in the line item by simply not specifying it in the line item.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 159 chars | ||
PayrollItemWageRef
Each payroll wage item describes and names a payment scheme, for example, Regular Pay or Overtime Pay. A PayrollItemWageRef aggregate refers to one of these wage items. In a request, if a PayrollItemWageRef aggregate includes both FullName and ListID, FullName will be ignored. Within QuickBooks, a timesheet can specify a payroll wage item only if the following criteria are met: The name on the timesheet (which corresponds to the EntityRef in the TimeTracking object) is on the QuickBooks Employee list, and The “Use time data to create paychecks” preference is turned on in the QuickBooks Payroll Info window that provides detailed employee information employee.
|
IQBBaseRef | |||
ListID
Along with FullName, ListID is a way to identify a list object. When a list object is added to QuickBooks through the SDK or through the QuickBooks user interface, the server assigns it a ListID. A ListID is not unique across lists, but it is unique across each particular type of list. For example, two customers could not have the same ListID, and a customer could not have the same ListID as an employee (because Customer and Employee are both name lists). But a customer could have the same ListID as a non-inventory item.
|
IQBIDType | |||
FullName
FullName (along with ListID) is a way to identify a list object. The FullName is the name prefixed by the names of each ancestor, for example Jones:Kitchen:Cabinets. FullName values are not case-sensitive.
|
IQBStringType | 31 chars | ||
Notes
Additional information.
|
IQBStringType | 4095 chars | ||
BillableStatus
The billing status of this item line or expense line.
|
IQBENBillableStatusType | 6.0 | ||
ExternalGUID
Allows for the attachment of a user defined GUID value.
|
IQBGUIDType | 9.0 | ||
IsBillable
NOT USABLE IN QBXML SPEC 6.0 AND LATER!! Use BillableStatus instead. If IsBillable is true, the tracked time is billable, and you must specify CustomerRef and ItemServiceRef so that an invoice can be created. If no invoice will be created, set IsBillable to false. (IsBillable is true by default.)
|
IQBBoolType | |||
IsBilled
If IsBilled is true, the tracked time has already been billed.
|
IQBBoolType |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 | <?xml version="1.0" encoding="utf-8"?> <?qbxml version="17.0"?> <QBXML> <QBXMLMsgsRq onError="stopOnError"> <TimeTrackingQueryRq metaData="ENUMTYPE" iterator="ENUMTYPE" iteratorID="UUIDTYPE"> <!-- BEGIN OR --> <TxnID >IDTYPE</TxnID> <!-- optional, may repeat --> <!-- OR --> <MaxReturned >INTTYPE</MaxReturned> <!-- optional --> <!-- BEGIN OR --> <ModifiedDateRangeFilter> <!-- optional --> <FromModifiedDate >DATETIMETYPE</FromModifiedDate> <!-- optional --> <ToModifiedDate >DATETIMETYPE</ToModifiedDate> <!-- optional --> </ModifiedDateRangeFilter> <!-- OR --> <TxnDateRangeFilter> <!-- optional --> <!-- BEGIN OR --> <FromTxnDate >DATETYPE</FromTxnDate> <!-- optional --> <ToTxnDate >DATETYPE</ToTxnDate> <!-- optional --> <!-- OR --> <!-- DateMacro may have one of the following values: All, Today, ThisWeek, ThisWeekToDate, ThisMonth, ThisMonthToDate, ThisCalendarQuarter, ThisCalendarQuarterToDate, ThisFiscalQuarter, ThisFiscalQuarterToDate, ThisCalendarYear, ThisCalendarYearToDate, ThisFiscalYear, ThisFiscalYearToDate, Yesterday, LastWeek, LastWeekToDate, LastMonth, LastMonthToDate, LastCalendarQuarter, LastCalendarQuarterToDate, LastFiscalQuarter, LastFiscalQuarterToDate, LastCalendarYear, LastCalendarYearToDate, LastFiscalYear, LastFiscalYearToDate, NextWeek, NextFourWeeks, NextMonth, NextCalendarQuarter, NextCalendarYear, NextFiscalQuarter, NextFiscalYear --> <DateMacro >ENUMTYPE</DateMacro> <!-- optional --> <!-- END OR --> </TxnDateRangeFilter> <!-- END OR --> <TimeTrackingEntityFilter> <!-- optional --> <!-- BEGIN OR --> <ListID >IDTYPE</ListID> <!-- optional, may repeat --> <!-- OR --> <FullName >STRTYPE</FullName> <!-- optional, may repeat --> <!-- END OR --> </TimeTrackingEntityFilter> <!-- END OR --> <IncludeRetElement >STRTYPE</IncludeRetElement> <!-- optional, may repeat --> </TimeTrackingQueryRq> <TimeTrackingQueryRs statusCode="INTTYPE" statusSeverity="STRTYPE" statusMessage="STRTYPE" retCount="INTTYPE" iteratorRemainingCount="INTTYPE" iteratorID="UUIDTYPE"> <TimeTrackingRet> <!-- optional, may repeat --> <TxnID >IDTYPE</TxnID> <!-- required --> <TimeCreated >DATETIMETYPE</TimeCreated> <!-- required --> <TimeModified >DATETIMETYPE</TimeModified> <!-- required --> <EditSequence >STRTYPE</EditSequence> <!-- required --> <TxnNumber >INTTYPE</TxnNumber> <!-- optional --> <TxnDate >DATETYPE</TxnDate> <!-- required --> <EntityRef> <!-- required --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </EntityRef> <CustomerRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </CustomerRef> <ItemServiceRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ItemServiceRef> <Duration >TIMEINTERVALTYPE</Duration> <!-- required --> <ClassRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </ClassRef> <PayrollItemWageRef> <!-- optional --> <ListID >IDTYPE</ListID> <!-- optional --> <FullName >STRTYPE</FullName> <!-- optional --> </PayrollItemWageRef> <Notes >STRTYPE</Notes> <!-- optional --> <!-- BillableStatus may have one of the following values: Billable, NotBillable, HasBeenBilled --> <BillableStatus >ENUMTYPE</BillableStatus> <!-- optional --> <ExternalGUID >GUIDTYPE</ExternalGUID> <!-- optional --> <IsBillable >BOOLTYPE</IsBillable> <!-- optional --> <IsBilled >BOOLTYPE</IsBilled> <!-- optional --> </TimeTrackingRet> </TimeTrackingQueryRs> </QBXMLMsgsRq> </QBXML> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 | 'The following sample code is generated as an illustration of
'Creating requests and parsing responses ONLY
'This code is NOT intended to show best practices or ideal code
'Use at your most careful discretion
imports System
imports System.Net
imports System.Drawing
imports System.Collections
imports System.ComponentModel
imports System.Windows.Forms
imports System.Data
imports System.IO
imports Interop.QBFC16
Module com.intuit.idn.samples
Public Class Sample
Public Sub DoTimeTrackingQuery()
Dim sessionBegun as Boolean
sessionBegun = False
Dim connectionOpen as Boolean
connectionOpen = False
Dim sessionManager as QBSessionManager
sessionManager = nothing
Try
'Create the session Manager object
sessionManager = new QBSessionManager
'Create the message set request object to hold our request
Dim requestMsgSet as IMsgSetRequest
requestMsgSet = sessionManager.CreateMsgSetRequest("US",16,0)
requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue
BuildTimeTrackingQueryRq(requestMsgSet)
'Connect to QuickBooks and begin a session
sessionManager.OpenConnection("","Sample Code from OSR")
connectionOpen = True
sessionManager.BeginSession("", ENOpenMode.omDontCare)
sessionBegun = True
'Send the request and get the response from QuickBooks
Dim responseMsgSet as IMsgSetResponse
responseMsgSet = sessionManager.DoRequests(requestMsgSet)
'End the session and close the connection to QuickBooks
sessionManager.EndSession()
sessionBegun = False
sessionManager.CloseConnection()
connectionOpen = False
WalkTimeTrackingQueryRs(responseMsgSet)
Catch e as Exception
MessageBox.Show(e.Message, "Error")
if (sessionBegun) then
sessionManager.EndSession()
End If
if (connectionOpen) then
sessionManager.CloseConnection()
End If
End Try
End Sub
Public Sub BuildTimeTrackingQueryRq(requestMsgSet as IMsgSetRequest)
Dim TimeTrackingQueryRq as ITimeTrackingQuery
TimeTrackingQueryRq= requestMsgSet.AppendTimeTrackingQueryRq()
Dim ORTimeTrackingTxnQueryElementType22399 as String
ORTimeTrackingTxnQueryElementType22399 = "TxnIDList"
if (ORTimeTrackingTxnQueryElementType22399 == "TxnIDList") then
'Set field value for TxnIDList
'May create more than one of these if needed
TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TxnIDList.Add("200000-1011023419")
End If
if (ORTimeTrackingTxnQueryElementType22399 == "TimeTrackingTxnFilter") then
'Set field value for MaxReturned
TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.MaxReturned.SetValue(6)
Dim ORDateRangeFilterElementType22400 as String
ORDateRangeFilterElementType22400 = "ModifiedDateRangeFilter"
if (ORDateRangeFilterElementType22400 == "ModifiedDateRangeFilter") then
'Set field value for FromModifiedDate
TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
'Set field value for ToModifiedDate
TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false)
End If
if (ORDateRangeFilterElementType22400 == "TxnDateRangeFilter") then
Dim ORTxnDateRangeFilterElementType22401 as String
ORTxnDateRangeFilterElementType22401 = "TxnDateFilter"
if (ORTxnDateRangeFilterElementType22401 == "TxnDateFilter") then
'Set field value for FromTxnDate
TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007"))
'Set field value for ToTxnDate
TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007"))
End If
if (ORTxnDateRangeFilterElementType22401 == "DateMacro") then
'Set field value for DateMacro
TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll)
End If
End If
Dim ORTimeTrackingEntityFilterElementType22402 as String
ORTimeTrackingEntityFilterElementType22402 = "ListIDList"
if (ORTimeTrackingEntityFilterElementType22402 == "ListIDList") then
'Set field value for ListIDList
'May create more than one of these if needed
TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.TimeTrackingEntityFilter.ORTimeTrackingEntityFilter.ListIDList.Add("200000-1011023419")
End If
if (ORTimeTrackingEntityFilterElementType22402 == "FullNameList") then
'Set field value for FullNameList
'May create more than one of these if needed
TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.TimeTrackingEntityFilter.ORTimeTrackingEntityFilter.FullNameList.Add("ab")
End If
End If
'Set field value for IncludeRetElementList
'May create more than one of these if needed
TimeTrackingQueryRq.IncludeRetElementList.Add("ab")
End Sub
Public Sub WalkTimeTrackingQueryRs( responseMsgSet as IMsgSetResponse)
if (responseMsgSet is nothing) then
Exit Sub
End If
Dim responseList as IResponseList
responseList = responseMsgSet.ResponseList
if (responseList is nothing) then
Exit Sub
End If
'if we sent only one request, there is only one response, we'll walk the list for this sample
for j=0 to responseList.Count-1
Dim response as IResponse
response = responseList.GetAt(j)
'check the status code of the response, 0=ok, >0 is warning
if (response.StatusCode >= 0) then
'the request-specific response is in the details, make sure we have some
if (not response.Detail is nothing) then
'make sure the response is the type we're expecting
Dim responseType as ENResponseType
responseType = CType(response.Type.GetValue(),ENResponseType)
if (responseType == ENResponseType.rtTimeTrackingQueryRs) then
'upcast to more specific type here, this is safe because we checked with response.Type check above
Dim TimeTrackingRet as ITimeTrackingRetList
TimeTrackingRet = CType(response.Detail,ITimeTrackingRetList)
WalkTimeTrackingRet(TimeTrackingRet)
End If
End If
End If
Next j
End Sub
Public Sub WalkTimeTrackingRet(TimeTrackingRet as ITimeTrackingRetList)
if (TimeTrackingRet is nothing) then
Exit Sub
End If
'Go through all the elements of ITimeTrackingRetList
'Get value of TxnID
Dim TxnID22403 as String
TxnID22403 = TimeTrackingRet.TxnID.GetValue()
'Get value of TimeCreated
Dim TimeCreated22404 as DateTime
TimeCreated22404 = TimeTrackingRet.TimeCreated.GetValue()
'Get value of TimeModified
Dim TimeModified22405 as DateTime
TimeModified22405 = TimeTrackingRet.TimeModified.GetValue()
'Get value of EditSequence
Dim EditSequence22406 as String
EditSequence22406 = TimeTrackingRet.EditSequence.GetValue()
'Get value of TxnNumber
if ( not TimeTrackingRet.TxnNumber is nothing) then
Dim TxnNumber22407 as Integer
TxnNumber22407 = TimeTrackingRet.TxnNumber.GetValue()
End If
'Get value of TxnDate
Dim TxnDate22408 as DateTime
TxnDate22408 = TimeTrackingRet.TxnDate.GetValue()
'Get value of ListID
if ( not TimeTrackingRet.EntityRef.ListID is nothing) then
Dim ListID22409 as String
ListID22409 = TimeTrackingRet.EntityRef.ListID.GetValue()
End If
'Get value of FullName
if ( not TimeTrackingRet.EntityRef.FullName is nothing) then
Dim FullName22410 as String
FullName22410 = TimeTrackingRet.EntityRef.FullName.GetValue()
End If
if (not TimeTrackingRet.CustomerRef. is nothing) then
'Get value of ListID
if ( not TimeTrackingRet.CustomerRef.ListID is nothing) then
Dim ListID22411 as String
ListID22411 = TimeTrackingRet.CustomerRef.ListID.GetValue()
End If
'Get value of FullName
if ( not TimeTrackingRet.CustomerRef.FullName is nothing) then
Dim FullName22412 as String
FullName22412 = TimeTrackingRet.CustomerRef.FullName.GetValue()
End If
End If
if (not TimeTrackingRet.ItemServiceRef. is nothing) then
'Get value of ListID
if ( not TimeTrackingRet.ItemServiceRef.ListID is nothing) then
Dim ListID22413 as String
ListID22413 = TimeTrackingRet.ItemServiceRef.ListID.GetValue()
End If
'Get value of FullName
if ( not TimeTrackingRet.ItemServiceRef.FullName is nothing) then
Dim FullName22414 as String
FullName22414 = TimeTrackingRet.ItemServiceRef.FullName.GetValue()
End If
End If
'Get value of Duration
Dim Duration22415 as IQBTimeIntervalType
Duration22415 = TimeTrackingRet.Duration.GetValue()
if (not TimeTrackingRet.ClassRef. is nothing) then
'Get value of ListID
if ( not TimeTrackingRet.ClassRef.ListID is nothing) then
Dim ListID22416 as String
ListID22416 = TimeTrackingRet.ClassRef.ListID.GetValue()
End If
'Get value of FullName
if ( not TimeTrackingRet.ClassRef.FullName is nothing) then
Dim FullName22417 as String
FullName22417 = TimeTrackingRet.ClassRef.FullName.GetValue()
End If
End If
if (not TimeTrackingRet.PayrollItemWageRef. is nothing) then
'Get value of ListID
if ( not TimeTrackingRet.PayrollItemWageRef.ListID is nothing) then
Dim ListID22418 as String
ListID22418 = TimeTrackingRet.PayrollItemWageRef.ListID.GetValue()
End If
'Get value of FullName
if ( not TimeTrackingRet.PayrollItemWageRef.FullName is nothing) then
Dim FullName22419 as String
FullName22419 = TimeTrackingRet.PayrollItemWageRef.FullName.GetValue()
End If
End If
'Get value of Notes
if ( not TimeTrackingRet.Notes is nothing) then
Dim Notes22420 as String
Notes22420 = TimeTrackingRet.Notes.GetValue()
End If
'Get value of BillableStatus
if ( not TimeTrackingRet.BillableStatus is nothing) then
Dim BillableStatus22421 as ENBillableStatus
BillableStatus22421 = TimeTrackingRet.BillableStatus.GetValue()
End If
'Get value of ExternalGUID
if ( not TimeTrackingRet.ExternalGUID is nothing) then
Dim ExternalGUID22422 as String
ExternalGUID22422 = TimeTrackingRet.ExternalGUID.GetValue()
End If
'Get value of IsBillable
if ( not TimeTrackingRet.IsBillable is nothing) then
Dim IsBillable22423 as Boolean
IsBillable22423 = TimeTrackingRet.IsBillable.GetValue()
End If
'Get value of IsBilled
if ( not TimeTrackingRet.IsBilled is nothing) then
Dim IsBilled22424 as Boolean
IsBilled22424 = TimeTrackingRet.IsBilled.GetValue()
End If
End Sub
End Class
End Module
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 | //The following sample code is generated as an illustration of //Creating requests and parsing responses ONLY //This code is NOT intended to show best practices or ideal code //Use at your most careful discretion using System; using System.Net; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.IO; using Interop.QBFC16; namespace com.intuit.idn.samples { public class Sample { public void DoTimeTrackingQuery() { bool sessionBegun = false; bool connectionOpen = false; QBSessionManager sessionManager = null; try { //Create the session Manager object sessionManager = new QBSessionManager(); //Create the message set request object to hold our request IMsgSetRequest requestMsgSet = sessionManager.CreateMsgSetRequest("US",16,0); requestMsgSet.Attributes.OnError = ENRqOnError.roeContinue; BuildTimeTrackingQueryRq(requestMsgSet); //Connect to QuickBooks and begin a session sessionManager.OpenConnection("","Sample Code from OSR"); connectionOpen = true; sessionManager.BeginSession("", ENOpenMode.omDontCare); sessionBegun = true; //Send the request and get the response from QuickBooks IMsgSetResponse responseMsgSet = sessionManager.DoRequests(requestMsgSet); //End the session and close the connection to QuickBooks sessionManager.EndSession(); sessionBegun = false; sessionManager.CloseConnection(); connectionOpen = false; WalkTimeTrackingQueryRs(responseMsgSet); } catch (Exception e) { MessageBox.Show(e.Message, "Error"); if (sessionBegun) { sessionManager.EndSession(); } if (connectionOpen) { sessionManager.CloseConnection(); } } } void BuildTimeTrackingQueryRq(IMsgSetRequest requestMsgSet) { ITimeTrackingQuery TimeTrackingQueryRq= requestMsgSet.AppendTimeTrackingQueryRq(); //Set attributes //Set field value for metaData TimeTrackingQueryRq.metaData.SetValue("IQBENmetaDataType"); //Set field value for iterator TimeTrackingQueryRq.iterator.SetValue("IQBENiteratorType"); //Set field value for iteratorID TimeTrackingQueryRq.iteratorID.SetValue("IQBUUIDType"); string ORTimeTrackingTxnQueryElementType22373 = "TxnIDList"; if (ORTimeTrackingTxnQueryElementType22373 == "TxnIDList") { //Set field value for TxnIDList //May create more than one of these if needed TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TxnIDList.Add("200000-1011023419"); } if (ORTimeTrackingTxnQueryElementType22373 == "TimeTrackingTxnFilter") { //Set field value for MaxReturned TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.MaxReturned.SetValue(6); string ORDateRangeFilterElementType22374 = "ModifiedDateRangeFilter"; if (ORDateRangeFilterElementType22374 == "ModifiedDateRangeFilter") { //Set field value for FromModifiedDate TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.FromModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); //Set field value for ToModifiedDate TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.ORDateRangeFilter.ModifiedDateRangeFilter.ToModifiedDate.SetValue(DateTime.Parse("12/15/2007 12:15:12"),false); } if (ORDateRangeFilterElementType22374 == "TxnDateRangeFilter") { string ORTxnDateRangeFilterElementType22375 = "TxnDateFilter"; if (ORTxnDateRangeFilterElementType22375 == "TxnDateFilter") { //Set field value for FromTxnDate TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.FromTxnDate.SetValue(DateTime.Parse("12/15/2007")); //Set field value for ToTxnDate TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.TxnDateFilter.ToTxnDate.SetValue(DateTime.Parse("12/15/2007")); } if (ORTxnDateRangeFilterElementType22375 == "DateMacro") { //Set field value for DateMacro TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.ORDateRangeFilter.TxnDateRangeFilter.ORTxnDateRangeFilter.DateMacro.SetValue(ENDateMacro.dmAll); } } string ORTimeTrackingEntityFilterElementType22376 = "ListIDList"; if (ORTimeTrackingEntityFilterElementType22376 == "ListIDList") { //Set field value for ListIDList //May create more than one of these if needed TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.TimeTrackingEntityFilter.ORTimeTrackingEntityFilter.ListIDList.Add("200000-1011023419"); } if (ORTimeTrackingEntityFilterElementType22376 == "FullNameList") { //Set field value for FullNameList //May create more than one of these if needed TimeTrackingQueryRq.ORTimeTrackingTxnQuery.TimeTrackingTxnFilter.TimeTrackingEntityFilter.ORTimeTrackingEntityFilter.FullNameList.Add("ab"); } } //Set field value for IncludeRetElementList //May create more than one of these if needed TimeTrackingQueryRq.IncludeRetElementList.Add("ab"); } void WalkTimeTrackingQueryRs(IMsgSetResponse responseMsgSet) { if (responseMsgSet == null) return; IResponseList responseList = responseMsgSet.ResponseList; if (responseList == null) return; //if we sent only one request, there is only one response, we'll walk the list for this sample for(int i=0; i < responseList.Count; i++) { IResponse response = responseList.GetAt(i); //check the status code of the response, 0=ok, >0 is warning if (response.StatusCode >= 0) { //the request-specific response is in the details, make sure we have some if (response.Detail != null) { //make sure the response is the type we're expecting ENResponseType responseType = (ENResponseType)response.Type.GetValue(); if (responseType == ENResponseType.rtTimeTrackingQueryRs) { //upcast to more specific type here, this is safe because we checked with response.Type check above ITimeTrackingRetList TimeTrackingRet = (ITimeTrackingRetList)response.Detail; WalkTimeTrackingRet(TimeTrackingRet); } } } } } void WalkTimeTrackingRet(ITimeTrackingRetList TimeTrackingRet) { if (TimeTrackingRet == null) return; //Go through all the elements of ITimeTrackingRetList //Get value of TxnID string TxnID22377 = (string)TimeTrackingRet.TxnID.GetValue(); //Get value of TimeCreated DateTime TimeCreated22378 = (DateTime)TimeTrackingRet.TimeCreated.GetValue(); //Get value of TimeModified DateTime TimeModified22379 = (DateTime)TimeTrackingRet.TimeModified.GetValue(); //Get value of EditSequence string EditSequence22380 = (string)TimeTrackingRet.EditSequence.GetValue(); //Get value of TxnNumber if (TimeTrackingRet.TxnNumber != null) { int TxnNumber22381 = (int)TimeTrackingRet.TxnNumber.GetValue(); } //Get value of TxnDate DateTime TxnDate22382 = (DateTime)TimeTrackingRet.TxnDate.GetValue(); //Get value of ListID if (TimeTrackingRet.EntityRef.ListID != null) { string ListID22383 = (string)TimeTrackingRet.EntityRef.ListID.GetValue(); } //Get value of FullName if (TimeTrackingRet.EntityRef.FullName != null) { string FullName22384 = (string)TimeTrackingRet.EntityRef.FullName.GetValue(); } if (TimeTrackingRet.CustomerRef != null) { //Get value of ListID if (TimeTrackingRet.CustomerRef.ListID != null) { string ListID22385 = (string)TimeTrackingRet.CustomerRef.ListID.GetValue(); } //Get value of FullName if (TimeTrackingRet.CustomerRef.FullName != null) { string FullName22386 = (string)TimeTrackingRet.CustomerRef.FullName.GetValue(); } } if (TimeTrackingRet.ItemServiceRef != null) { //Get value of ListID if (TimeTrackingRet.ItemServiceRef.ListID != null) { string ListID22387 = (string)TimeTrackingRet.ItemServiceRef.ListID.GetValue(); } //Get value of FullName if (TimeTrackingRet.ItemServiceRef.FullName != null) { string FullName22388 = (string)TimeTrackingRet.ItemServiceRef.FullName.GetValue(); } } //Get value of Duration IQBTimeIntervalType Duration22389 = (IQBTimeIntervalType)TimeTrackingRet.Duration.GetValue(); if (TimeTrackingRet.ClassRef != null) { //Get value of ListID if (TimeTrackingRet.ClassRef.ListID != null) { string ListID22390 = (string)TimeTrackingRet.ClassRef.ListID.GetValue(); } //Get value of FullName if (TimeTrackingRet.ClassRef.FullName != null) { string FullName22391 = (string)TimeTrackingRet.ClassRef.FullName.GetValue(); } } if (TimeTrackingRet.PayrollItemWageRef != null) { //Get value of ListID if (TimeTrackingRet.PayrollItemWageRef.ListID != null) { string ListID22392 = (string)TimeTrackingRet.PayrollItemWageRef.ListID.GetValue(); } //Get value of FullName if (TimeTrackingRet.PayrollItemWageRef.FullName != null) { string FullName22393 = (string)TimeTrackingRet.PayrollItemWageRef.FullName.GetValue(); } } //Get value of Notes if (TimeTrackingRet.Notes != null) { string Notes22394 = (string)TimeTrackingRet.Notes.GetValue(); } //Get value of BillableStatus if (TimeTrackingRet.BillableStatus != null) { ENBillableStatus BillableStatus22395 = (ENBillableStatus)TimeTrackingRet.BillableStatus.GetValue(); } //Get value of ExternalGUID if (TimeTrackingRet.ExternalGUID != null) { string ExternalGUID22396 = (string)TimeTrackingRet.ExternalGUID.GetValue(); } //Get value of IsBillable if (TimeTrackingRet.IsBillable != null) { bool IsBillable22397 = (bool)TimeTrackingRet.IsBillable.GetValue(); } //Get value of IsBilled if (TimeTrackingRet.IsBilled != null) { bool IsBilled22398 = (bool)TimeTrackingRet.IsBilled.GetValue(); } } } } |