Catalog Items

Catalog items are goods or services that can be provided by one department in the University to another, such as catering, event space rental, and data backup services.

Each catalog item has a corresponding internalCatalog entry with an Internal Service Provider, which you can query for more information about the provider using the catalog item’s catalogId or catalogName:

/finance/internalServiceProviders?filter[internalCatalogs.id]=ci1.catalogId,ci2.catalogId

/finance/internalServiceProviders?filter[internalCatalogs.name]=ci1.catalogName,ci2.catalogName

Most catalog items can also be matched against internal service providers by their resourceProvider, though this is not a guarantee:

/finance/internalServiceProviders?filter[name]=ci1.resourceProvider,ci2.resourceProvider

When a catalog item is provisioned, it takes the form of an Internal Service Delivery with one or more ISD Lines. However, you cannot query these directly from a catalog item. Instead, you must first fetch the internal service provider associated with the catalog item, then query for ISD lines associated with that catalog:

/finance/internalServiceDeliveries?filter[providerId]=isp1.id,isp2.id,...
/finance/isdLines?filter[providerId]=isp1.id,isp2.id,...

The way the data has been modeled can be roughly thought of as:

• Internal service providers can have many internal catalogs
• Each internal catalog (from an internal service provider) can have many catalog items
• Internal service deliveries correspond to specific service provider catalogs and catalog items, one line per catalog item

You may be wondering: why not model this endpoint as catalogs with items, rather than individual line items in a catalog? And the answer is simply that all of this came together in pieces as it was requested and the data was made available to us, rather than being modeled holistically, in addition to not knowing what all Workday has because we don’t have access to this data in the Workday UI, so what may seem obvious from an accountant’s perspective or anyone looking at the data in Workday can easily fly under our radar. We plan on modeling this data more holistically eventually, and if you have thoughts on what you would like to see, feel free to contact us.

Filters

Catalog items can be filtered by:

• active (true or false)
• catalogId
• name
  • You can prefix the value of the filter[name] parameter with any of the following to get partial matches. Otherwise, only exact matches will be returned.
    • STARTS_WITH:
    • CONTAINS:
    • ENDS_WITH:
• dttmLoaded (when the record was last changed in our cached datastore)
  • You can prefix the value of the filter[dttmLoaded] parameter with any of the following to get date ranges. Otherwise, only exact matches will be returned.
    • GREATER_OR_EQUAL:
    • GREATER_THAN:
    • LESS_OR_EQUAL:
    • LESS_THAN:

Units of Measure

The following units of measure and abbreviations are used:

EDI code	Unit of Measure
BG	Bag
BE	Beam
BX	Box
CA	Case
C5	Cello Pack
DA	Day
DR	Drum
EA	Each
FT	Foot
GA	Gallon
GB	Gigabytes
GR	Gram
HR	Hour
KG	Kilogram
LT	Liter
LO	Lot
MB	Megabyte
MR	Meter
MG	Milligram
ML	Milliliter
ME	Minute
PK	Pack
P2	Package
PR	Pair
LB	Pound
QT	Quart
RM	Ream
ST	Set
SF	Square Foot
UN	Unit
WK	Week
YD	Yard
YR	Year