SWAPI – Pricebook Queries UTC

Allow PricebookItemQuery and PricebookTaskQuery to be queried based upon UTC date time.  LastUpdatedUTC is being added so that it will not be necessary to know each individual company’s time zone in order to get accurate results.  LastUpdatedUTC can always be used and SWAPI will convert the UTC value submitted into the company’s time zone automatically for querying

Added 1 parameter:

· LastUpdatedUTC - date/time in terms of UTC time

· LastUpdatedUTC uses date time format as YYYY-MM-DDThh:mm:ss.

· This time is Coordinated Universal Time (Zulu time) format without a time zone designator.

· Only submit either LastUpdated or LastUpdateUTC, but not both.

PricebookItemQuery

Request

<?xml version="1.0" encoding="utf-8"?>

<SessionRequest Version="string" SessionID="{528D6F47-A603-4051-B33A-55E6F6704D2C}" RequestID="string">

<PricebookItemQuery Filter="string" Max="string" OrderBy="string" StyleNo="string" StyleOptions="string" PageSize="string" PageNo="string">

<LastUpdated>dateTime</LastUpdated>

<ItemType>string</ItemType>

<LastUpdatedUTC>UTC dateTime</LastUpdatedUTC>

</PricebookItemQuery>

</SessionRequest>

Response

<?xml version="1.0" encoding="utf-8"?>

<PricebookItemQueryData RequestID="string">

<PricebookItemQueryRecord>

<ItemID>integer</ItemID>

<ItemNumber>string(15)</ItemNumber>

<ItemCategory>string(15)</ItemCategory>

<ItemGroup>string(15)</ItemGroup>

<Description>string(100)</Description>

<LastPriceUpdate>dateTime</LastPriceUpdate>

<StandardPrice>float</StandardPrice>

<UseAsTask>boolean</UseAsTask>

<TaskRetailPrice>float</TaskRetailPrice>

<TaskTotalPrice>float</TaskTotalPrice>

<TaskPartPrice>float</TaskPartPrice>

<TaskLaborPrice>float</TaskLaborPrice>

<TaskMiscPrice>float</TaskMiscPrice>

<TaxAmount>float</TaxAmount>

<LaborAllotted>float</LaborAllotted>

<AddTax>boolean</AddTax>

<IsActive>boolean</IsActive>

<ItemType>string(1)</ItemType>

<UPC>string(20)</UPC>

<Manufacturer>string(6)</Manufacturer>

<ModelNo>string(20)</ModelNo>

<IsSerialized>boolean</IsSerialized>

<ItemDetailUpdated>dateTime</ItemDetailUpdated>

<dsVendorItemList>

<dsVendorItem>

<AP_VendorID>integer</AP_VendorID>

<ItemID>integer</ItemID>

<VendorItemNumber>string(15)</VendorItemNumber>

<ListPrice>float</ListPrice>

<OurCost>float</OurCost>

<LastCost>float</LastCost>

<IsPrimary>boolean</IsPrimary>

<IsSecondary>boolean</IsSecondary>

</dsVendorItem>

</dsVendorItemList>

</PricebookItemQueryRecord>

</PricebookItemQueryData>

PricebookTaskQuery

Request

<?xml version="1.0" encoding="utf-8"?>

<SessionRequest Version="string" SessionID="{528D6F47-A603-4051-B33A-55E6F6704D2C}" RequestID="string">

<PricebookTaskQuery Filter="string" Max="string" OrderBy="string" StyleNo="string" StyleOptions="string">

<LastUpdated>dateTime</LastUpdated>

<LastUpdatedUTC>UTC dateTime</LastUpdatedUTC>

</PricebookTaskQuery>

</SessionRequest>

Response

<?xml version="1.0"?>

<PricebookTaskQueryData RequestID="string">

<PricebookTaskQueryRecord>

<ItemID>integer</ItemID>

<ItemNumber>string(15)</ItemNumber>

<ItemCategory>string(15)</ItemCategory>

<ItemGroup>string(15)</ItemGroup>

<Description>string(100)</Description>

<LastPriceUpdate>dateTime</LastPriceUpdate>

<TaskRetailPrice>float</TaskRetailPrice>

<TaskTotalPrice>float</TaskTotalPrice>

<TaskPartPrice>float</TaskPartPrice>

<TaskLaborPrice>float</TaskLaborPrice>

<TaskMiscPrice>float</TaskMiscPrice>

<TaxAmount>float</TaxAmount>

<LaborAlloted>float</LaborAlloted>

<AddTax>boolean</AddTax>

<IsActive>boolean</IsActive>

<ItemType>string(1)</ItemType>

<ItemDetailUpdated>dateTime</ItemDetailUpdated>

<IsDiagItem>boolean</IsDiagItem>

<TaskNote>string(255)</TaskNote>

<dsPricelevelList>

<dsPricelevel>

<ItemID>integer</ItemID>

<TotalSale>float</TotalSale>

<PartSale>float</PartSale>

<LaborSale>float</LaborSale>

<MiscSale>float</MiscSale>

<TaxAmount>float</TaxAmount>

<PriceLevel>string(20)</PriceLevel>

<PLevel>integer</PLevel>

</dsPricelevel>

</dsPricelevelList>

</PricebookTaskQueryRecord>

</PricebookTaskQueryData>