Notes on Download Behavior

Review these notes for more on Oracle Visual Builder Add-in for Excel download behavior:

• NetSuite services do not return full row details when responding to a GET request on the collection path. As a result, the add-in must issue individual GET requests on the item path for each item returned from the collection path.
• For Oracle ADF REST Resource and Visual Builder Business Objects services, the add-in sends additional GET requests to the LOV data source to get rows with missing identity values only. For other service types, the add-in may get all rows in the LOV data source to fix the cache miss.

  If the add-in still can't find the display value for an identity value, the identity value is written to the worksheet without the swap.

• REST services are stateless. As a result there are several issues to consider:
  • The query is re-executed for each page request
  • REST services cannot guarantee "read consistency" across multiple requests. If the data is changed during a multi-page download, it is possible for some rows to be missed entirely or downloaded more than once.

  Note:

  If pagination is not configured for a given business object, the add-in attempts to fetch and process all available rows in a single request. For larger volumes, such requests may time out.
• If Send Only Changed Data During Upload is enabled, the add-in caches a copy of the data during download to be used for comparisons later on during upload.

For more information how some features affect the add-in's download behavior, see:

• Configure Search Options for Download
• Configure Pagination for a Business Object
• Work with Service Path Parameters in a Table Layout
• Use Polymorphic Business Objects and Fields
• Use Lists of Values in an Excel Workbook
• Use Macros in an Integrated Excel Workbook
• Use Multiple Layouts for Multi-level Business Objects