Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Given the format of an Order Feed 9see (see below), there are two recommended ways of processing it:

...

  • YYYY-MM-DD is the year, month, and date that the feed was generated.

  • <sis_term_id> is the institution's SIS identifier for the term.

File format

The order feed is formatted as a CSV file with the following properties:

  • All values are in double-quotes.

  • If no value is required or available for a field, the string "null" is the value, not a blank.

  • All lines are terminated with a UTF-8 Unix style newline.

  • The escape character is a backslash (\\).

  • Timestamps are in ISO 8601 format and must include the time (e.g., `2020-12-15 04:35`).

File contents

The contents of an Order report represent the "current state" of orders and their sections and content items. Aside from the "is_deleted" flag (see below), an Order report will not describe how a particular order has changed since it was last reported. It is up to institutions consuming the Order report to track this for themselves if they wish.

In the nightly reports, any new orders or orders that changed the previous day are represented. Changes may include:

  • Deleting an order.
  • Restoring an order.
  • Adding or removing sections from an order.
  • Adding or removing content items from an order.

Each line of an order feed references only one section and one content item of a particular order. Consequently, a report of a single order is distributed over one or more rows, depending on the number of sections and content items on the order. If, for example, there are two content items on a single order for two sections, then this order is represented in four rows.

The order feed data columns are as follows.:

 

order_id

A unique Unizin ID for the order.

order_created

A date & time in ISO 8601.

order_updated

A date & time in ISO 8601.

sis_section_id

An SIS section ID that is on the order.

sis_content_id

This is only applicable for IU. In many cases, the value will be `"null"`.

is_deleted

If "true," the Order to which the content-section pair belongs has been deleted.

author

The authors of a content item that is on the order. If multiple authors are present, they are separated by a semicolon.

title

The title of a content item that is on the order.

searchable_isbn

The best ISBN students can use to search for and find the title on the web.
publication_dateThe publication date of the title, if available from the publisher. This is a date in ISO 8601 (note: it is only a date object).

delivery_solution

The name of the reader used to deliver the solution. Values will be either "Unizin Engage" or "Publisher DLT".

sis_publisher_id

This is only applicable for IU. In many cases, it will be `"null"`.

publisher_name

The name of the content item’s publisher.

edition

The edition of the content item.

offer_price

The offer price for the content item (this is the price that students will be charged).

print_list_price

The print list price for the content item (this is the nominal price of the content item. Offer prices are generally calculated as a function of the print list price).

is_royalty

This is a boolean value corresponding to whether or not the person who ordered the content item for this section asserted that they may earn royalties. Note: this is an order level assertion but we'll present it as if for each content item, anyway. In short, it should not be assumed that if this value is true, it is because the user ordering the content stands to early royalties from this particular content itemsTitems.