1. Operations Guide, Volume 1 - Batch Overviews and Designs
  2. Administration Batch
  3. Merch API Data Rebuild Request Wrapper Script (merchapidatarebuildrequest)
  4. Design Overview

Design Overview

This wrapper batch program is used to make an entry in the MERCHAPI_ASYNC_REQUEST table for data refresh requests. There are two data refresh types: one is TRUNCATE_AND_LOAD and the other one is REBUILD.

  • TRUNCATE_AND_LOAD will be used for severe data corruption.

  • REBUILD is used to build the JSON message for all the records.

The LAST_UPDATE_DATETIME update is dependent on the value of REFRESH_UPDATE_TIMESTAMP_IND. The silent update (REBUILD with no timestamp update) is applicable when a new field is added or removing the deprecated fields and don’t want to force-publish these changes. REBUILD with timestamp update is used in case of data discrepancies within Merchandising and Cache table or Merchandising and consuming system.