notes-download-behavior.html

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 ADF REST and VBBO 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.
The add-in harvests the self-links from the download response and uses them for subsequent item-level operations. For example:

"links": [
  {
    "rel": "self",
    "href": "http://myhost/myapp/rest/v1/Employees/101"
  }
]

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