ASP.NET Web API Help Page

Introduction

Provide a general description of your APIs here.

OrderGuide

Order Guide Controller

API	Description
POST api/orderguide/deleteFutureBlindEndDateForStoreItem	delete given Future Blinding Date for Item.
GET api/orderguide/GetListAutoDistroStoreBlinding	get Auto dISTRO Future Blind Dates.
POST api/orderguide/UpdateBlindingDateForStoreItem	Update Blinding Date for Store Item.
POST api/orderguide/AddItemBlindingForStoreItem	Add Blinding Date for Store Item.
GET api/orderguide/listorderguide?orderNbr={orderNbr}&storeNbr={storeNbr}&whseNbr={whseNbr}&orderTypeNbr={orderTypeNbr}&itemsPerPage={itemsPerPage}&firstItemIndex={firstItemIndex}&sortAttributeName={sortAttributeName}&classNbrFilter={classNbrFilter}&subClassNbrFilter={subClassNbrFilter}&searchFilter={searchFilter}&otherFilter={otherFilter}&itemGeniusFilter={itemGeniusFilter}&salesFilter={salesFilter}	Lists OG for printer version
GET api/orderguide/GetQtyAvailable?itemNbr={itemNbr}&whseNbr={whseNbr}	Returns Qty Available at the warehouse for an item Takes the qty on hand in whse (including incoming shuttles) and reduces that number by what is already on reserve
POST api/orderguide/UpsertImageFeedbackDetails	Insert/Update the image feedback details
GET api/orderguide/getAllItemsImageFeedbackDetails	Retrieve all items image feedback related details
GET api/orderguide/getAllImageFeedbackItems?itemNbr={itemNbr}&UPC={UPC}	Get image feedback details by item
POST api/orderguide/updateImageStatus	Updating Status of an image by item number
GET api/orderguide/getExportImageFeedbackDetails	Method to retrieve image feedback details by item,store and image url for export
GET api/orderguide/test	Method to retrieve image feedback details by item,store and image url for export
GET api/orderguide/UpdateEOH?storeNbr={storeNbr}&itemNbr={itemNbr}&EOH={EOH}&shownEOH={shownEOH}&OrderTypeNbr={OrderTypeNbr}	Update Estimated Order in Hand in AS400
GET api/orderguide/estimatedonhand?storeNbr={storeNbr}&itemNbr={itemNbr}	Get Single EstimatedOnHand
POST api/orderguide/estimatedonhand	Get Single EstimatedOnHand
POST api/orderguide/estimatedonhands	Get Multiple EstimatedOnHand
PUT api/orderguide/saveestimatedonhand	Save EstimatedOnHand (idempotent)
POST api/orderguide/UpdateEOHItems	Update List of Estimated Order in Hand
POST api/orderguide/openorderwindow	This service will return a complete Open Orders Items.
GET api/orderguide/getPoolDetails?sowLogID={sowLogID}	This service will return a complete Pool Object with Pool Header, which contains a list of Pool Details, which each Pool Detail contains a list of Pool Items.
GET api/orderguide/getpreorderpoolitems?sowLogID={sowLogID}	This service will return a complete Pool Items.
GET api/orderguide/getpreorderinfo?id={id}	Returns Pre-Order Information determined by Order Window Log ID
POST api/orderguide/checkforresumedorder	Retrieve all Items along with are ordered in previous order
GET api/orderguide/preOrderHasBulkOrderItem?storeNbr={storeNbr}&whseNbr={whseNbr}	see if today's preoder has a bulk order item.
GET api/orderguide/getLatestExpiredOrderID?storeNbr={storeNbr}&storeOrderTypeNbr={storeOrderTypeNbr}	Retrieve SowID which is exprired.
POST api/orderguide/getSplitedStoreOrder	Service to get splited store order log id
POST api/orderguide/getSplitStorePreOrderItems
GET api/orderguide/getSplitedPrimaryStoreDetails?storeNbr={storeNbr}&deliveryDate={deliveryDate}&whseNbr={whseNbr}&orderType={orderType}	Get primary store number(s) by secondary store number
POST api/orderguide/submitorder	This API will submit an order to the warehouse and transmit to the WMS system that the order is ready for sending to the store.
GET api/orderguide/getNewArrivalOGItems?storeNbr={storeNbr}	Fetch all New Arrivals Items
POST api/orderguide/getNextIncrement	This service is used to fetch Next Icrement/Decrement values. Fetch next Increment Value Fetch next Decrement Value
POST api/orderguide/getQtyDifference	Fetch Quantity available
POST api/orderguide/InsertNewArrivalOrder	Insert Items in local database and update the data in distribution tables. NEW_ITEM_ARRIVAL_ORDER_DETAIL DISTRIBUTION_ITEM DISTRIBUTION_WAREHOUSE DISTRIBUTION_STORE
POST api/orderguide/UpdateNewArrivalOrderGuideRealTime
POST api/orderguide/UpdateNewArrivalOrderGuideReserveQty
POST api/orderguide/CheckForNewOrderGuideItems	Checks for New Order Guide Items
POST api/orderguide/SyncOrderGuideItems	Sync Order Guide Items
GET api/orderguide/createorderandguide?storeOrderWindowLogId={storeOrderWindowLogId}&splitStoreNbr={splitStoreNbr}	This service will return an Order Header. If the order has not been created it will 1) Cut off the Flow and Crossdock orders 2) Create the Order on the AS400 3) Copy the Items on the order from the as400 to SQL 4) Create the Order Guide on the AS400 5) Copy the Order Guide to SQL 6) Update Distribution Qty's and OG settings 7) Update Items for MinShip Override if needed If the order has already been created it will simply return the order header without creating a new order.
GET api/orderguide/GetNeverOutItems?whseNbr={whseNbr}	Fetch Never Out Items by WhseNbr.
POST api/orderguide/createreadonlyorderguide	This will create a read only version of the order guide, it will create an order with a fake order number, and insert into the READ_ONLY_ORDER_GUIDE_TABLE. Precaution: if the as400 program is called more than once before it finishes for the same store/whse combo it will fail.
GET api/orderguide/getorderguidestatus?storeOrderWindowLogId={storeOrderWindowLogId}	Fetch Order Guide Status.
POST api/orderguide/expireorder	Expire Order
GET api/orderguide/getpendingdocs?storeNbr={storeNbr}&itemNbr={itemNbr}&palletMod={palletMod}	Get pending documents of an item
POST api/orderguide/refresh	API request to refresh the dynamic components on an Order Guide. These include the Order Guide Items, Summary and Truck information (Progress Bars)
GET api/orderguide/getOrderTruckAndDeptTotals?as400OrderNbr={as400OrderNbr}&includeCurrentOrderTotals={includeCurrentOrderTotals}	API request Truck and Departments Totals from AS400.
GET api/orderguide/getOrderTruckAndDeptTotals2?as400OrderNbr={as400OrderNbr}&includeCurrentOrderTotals={includeCurrentOrderTotals}	API request Truck and Departments Totals from AS400.
GET api/orderguide/getOrderTruckandDeptTotalsByLogID2?logID={logID}	API request Truck and Departments Totals by logID.
GET api/orderguide/getOrderTruckandDeptTotalsByLogID?logID={logID}&splitStoreNumber={splitStoreNumber}	API request Truck and Departments Totals by logID.
GET api/orderguide/items?OrderNbr={OrderNbr}&StoreNbr={StoreNbr}&WhseNbr={WhseNbr}&OrderTypeNbr={OrderTypeNbr}	Returns Pre-Order Information determined by Order Window Log ID
GET api/orderguide/filters?storeNbr={storeNbr}	Order Guide Filters [Genius, Other, Sales]
POST api/orderguide/updateqtyonorder	This will Update the qty on order with the next value calculated based on the updateType.
POST api/orderguide/itemdetails	Item Details [Tabs: Sales, Timeline, Module + Details (WishList Store Count + Expiry Date)]
POST api/orderguide/itemdetailsSales	ItemDetails - Sales Tab
POST api/orderguide/itemdetailsTimeLine	ItemDetails - TimelineTab
POST api/orderguide/itemdetailsModule	ItemDetails - ModuleTab
POST api/orderguide/getpalletitemdetails	ItemDetails - ModuleTab
GET api/orderguide/itemwishlist?storeNbr={storeNbr}&itemNbr={itemNbr}&as400order={as400order}&isAdd={isAdd}	Update Store Item Wish List
GET api/orderguide/itempromote?storeNbr={storeNbr}&itemNbr={itemNbr}&upc={upc}&v={v}	Update New Item Alert Store Approval
GET api/orderguide/getUserFiltersByRoleID?storeNbr={storeNbr}&roleID={roleID}	Retrieve user filters from username and store number + allow submit setting
GET api/orderguide/getUserFilters?storeNbr={storeNbr}&email={email}	Retrieve user filters from username and store number + allow submit setting
POST api/orderguide/ordersummary	Validate Order and submit Order
POST api/orderguide/delayQtyOnOrder	This service will delay qty on order
POST api/orderguide/UpdatePushPanelQty	UpdatePushPanelQty: This web service will calculate the necessary changes to a push item based on which button has been pressed, the current qty, and any buttons that have previously been pressed.
POST api/orderguide/UpdatePushPanelUserChanges	UpdatePushPanelUserChanges: This web service will run when a user clicks the Update button on the distribution push panel. It will Do all of the updates needed to the AS400 and the SQL tables.
POST api/orderguide/updateqtyonorderwithqtyrequested	Update item with modified quantity and set the nextIncrement and Decrement values for Item.
GET api/orderguide/loadFutureBlindEdndatesForStoreItem?storeNbr={storeNbr}&itemNbr={itemNbr}	get Future Blind Dates for Item.
POST api/OrderGuide?qtyToAdjust={qtyToAdjust}	Updates the order quantity in the database.
POST api/OrderGuide?minShipCode={minShipCode}&storeNbr={storeNbr}	Validate the Item Cases/layers.
POST api/OrderGuide?OrderNbr={OrderNbr}	returns a list of [RTO_ORDER_TOTALS] records
GET api/OrderGuide?OrderNbr={OrderNbr}&DeptCode={DeptCode}	returns a single RTO_ORDER_TOTALS record
POST api/OrderGuide?shipReserveRaw={shipReserveRaw}	Retrieve Warehouse for UOG Items.
POST api/OrderGuide?poolID={poolID}	inserts a record into STORE_ORDER_WINDOW_LOG
GET api/OrderGuide?orderNbr={orderNbr}&whseNbr={whseNbr}	No documentation available.
POST api/OrderGuide?storeNbr={storeNbr}&userName={userName}&whseChangeQty={whseChangeQty}&deliveryDate={deliveryDate}	This will return the distribution ID
POST api/OrderGuide?holdingOrderNbr={holdingOrderNbr}&holdingOrderSeqNbr={holdingOrderSeqNbr}&itemNbr={itemNbr}	Update Distribution Reason in AS400 table qs36f.dstopdp
GET api/OrderGuide?dt={dt}	Method is used for formating data.
POST api/OrderGuide?storeOrderWindowLogId={storeOrderWindowLogId}&splitStoreNbr={splitStoreNbr}	Creating a new order.
POST api/OrderGuide?whseNbr={whseNbr}&whseOrderTypeNbr={whseOrderTypeNbr}&DeliveryDate={DeliveryDate}&splitStoreNbr={splitStoreNbr}	Create Real Time Order Guide
POST api/OrderGuide?storeNbr={storeNbr}&whseNbr={whseNbr}&whseOrderTypeNbr={whseOrderTypeNbr}&logId={logId}	No documentation available.
POST api/OrderGuide?storeNbr={storeNbr}&whseNbr={whseNbr}	Check record status is locked
POST api/OrderGuide?lastStep={lastStep}	This will update the Order Guide Status table with the current time and last completed step... this is used after each major section of code in the order guide.
GET api/OrderGuide?expireDate={expireDate}	Compare today date with exprire date.
POST api/OrderGuide?storeNbr={storeNbr}&whseNbr={whseNbr}&poNbr={poNbr}&splitStoreNbr={splitStoreNbr}	No documentation available.

DsdUpload

API	Description
POST api/fog/processUploadFile	Processing the upload csv file and verifying each line.Returnning the list of processed items.
POST api/fog/saveProcessedDSDUpload	Method will crate store/storeGroup obj for each item. Then call InsertFlexOrderGuide async method to save items.
POST api/DsdUpload	No documentation available.
GET api/DsdUpload	Method is to create storeNotInGroup and StoreInGroup object for each item. This is done to re-use insert method when saving upload items.

InventoryAdmin

API	Description
GET api/inventoryadmin/getlastcloseddate?StoreNbr={StoreNbr}	Input is store number,output is last closed date. Getting last closed date when user inputs the store #
POST api/inventoryadmin/updatelastcloseddate	Updating last closed date
GET api/inventoryadmin/getpoheader?StoreNbr={StoreNbr}&PoNbr={PoNbr}	Input is store number,output is last closed date
POST api/inventoryadmin/deletepo	Delete PO based on store and po numbers
POST api/inventoryadmin/adjustpodate	Adjusting PO date within the store # and PO #.
GET api/inventoryadmin/getCreditMemo?storeNbr={storeNbr}&creditMemoNbr={creditMemoNbr}&creditMemoDate={creditMemoDate}	Get credit memo details from as400
POST api/inventoryadmin/adjustCreditMemoDate	Service to adjust credit memo date in 2 tables in as400
POST api/inventoryadmin/deleteCreditMemo	Delete credit memo record for selected credit memo from two as400 tables

StoreSetup

API	Description
GET api/storesetup/listOperatorEmailAddresses	list all operator emails
GET api/storesetup/isStoreNbrAvailable?storeNbr={storeNbr}	get store
GET api/storesetup/getAllStores	get store
GET api/storesetup/getTerms	get terms
GET api/storesetup/getLatLong?address={address}&city={city}&state={state}	get latitude longitude from api https://developer.mapquest.com/documentation/open/
GET api/storesetup/getRegion	get region
GET api/storesetup/getFinRegion	Get all Finance Regions
GET api/storesetup/getSubFinRegion?finRegionID={finRegionID}	Get all Sub Finance Regions
GET api/storesetup/getFinRegionValues?storeNbr={storeNbr}	Get Finance and Sub Finance Regions values by storeNbr
GET api/storesetup/getWebRegion	get web region
GET api/storesetup/getStore?storeNbr={storeNbr}	get store for store setup
GET api/storesetup/getNewStore?newStoreNbr={newStoreNbr}&likeStoreNbr={likeStoreNbr}&openDate={openDate}	get new store for store setup
POST api/storesetup/saveStoreGp	get store gp
POST api/storesetup/saveStore	get new store for store setup

SystemMessage

API	Description
GET api/systemMessage/listActiveSystemMessage	Retrieve list of active (enabled and not past display_until date) system messages
GET api/systemMessage/getAllSystemMessageResults	Query sql tables to get the results to list in the table
POST api/systemMessage/upsertSystemMessageRecordChange	The service will update the row edited if id>0. If id==0,system will insert a new record to database.
POST api/systemMessage/deleteSystemMessageRow	No documentation available.

Coupon

API	Description
POST api/marketing/upsertCouponRequest	Submit Request To Service Now
POST api/marketing/submitRequestToServiceNow	Submit Request To Service Now
GET api/marketing/getNextValidPlu?storeNbr={storeNbr}	Get Next Valid Plu
POST api/Coupon?plu={plu}	Method to validate whether the plu is used or not

OrderNowRestrictions

API	Description
GET api/rto/ordertypes?storeNbr={storeNbr}&orderType={orderType}&warehouseNbr={warehouseNbr}&state={state}&orderNow={orderNow}	Get List of Store - Order Type - Warehouse Combinations
POST api/rto/swot/add	Add New Store Warehouse Order Type (SWOT)
POST api/rto/swot/delete	Delete Store Warehouse Order Type (SWOT)
POST api/rto/swot/update	Update Store Warehouse Order Type (SWOT)
GET api/nightjob/autoinsertordertypes	Retrieve a list of new stores that have no records in RTO_STORE_TYPE table. Get the list or Order types need to be inserted automatically. Insert new (default) order type records for new stores by Night Job

Pinks

API	Description
GET api/pink/statuscodes	Get status codes for pink items
GET api/pink/pinkitems?_storeNbr={_storeNbr}&_pinkId={_pinkId}&_buyerNbr={_buyerNbr}&_itmNbr={_itmNbr}&_statusCode={_statusCode}&_dateRange={_dateRange}	Get pink items
GET api/pink/listmarkdown?storeNbr={storeNbr}&itemNbr={itemNbr}	Get markdown list by store and item number
GET api/pink/getpinkshipment?invoiceNbr={invoiceNbr}&itemNbr={itemNbr}	Get Pink Shipment Invoice Details
GET api/pink/getlasttenshipments?storeNbr={storeNbr}&itemNbr={itemNbr}	Get Buyer Research Last 10 Shipment Details
GET api/pink/insertpinkas400?storeNbr={storeNbr}&buyerNbr={buyerNbr}&vendorNbr={vendorNbr}&itemNbr={itemNbr}&pinkQty={pinkQty}&units={units}&retail={retail}&todayDate={todayDate}&dateInserted={dateInserted}&transfer={transfer}&pack={pack}&size={size}&description={description}&dept={dept}&bestIfUsedBy={bestIfUsedBy}&pullCode={pullCode}&receiptDate={receiptDate}&vendorCharge={vendorCharge}&reasonCode={reasonCode}&vendorComments={vendorComments}&pinkId={pinkId}&isRWItem={isRWItem}	Insert Pink on AS400
GET api/pink/deletepink?pinkId={pinkId}&userId={userId}	Delete pink details
GET api/pink/getoriginalretail?pinkId={pinkId}	Get Original Requested Retail
GET api/pink/getitemmovement?itemNum={itemNum}&storeNbr={storeNbr}	Get item movement list by item and store numbers
GET api/pink/savependingpink?totalTransfer={totalTransfer}&totalRetail={totalRetail}&buyerNbr={buyerNbr}&vendorNbr={vendorNbr}&pinkQty={pinkQty}&retail={retail}&transfer={transfer}&pinkId={pinkId}&userId={userId}	Once buyer changes at least one of the following parameters, they will be able to Save it to Pink table.
GET api/pink/updatepinktable?as400id={as400id}&totalTransfer={totalTransfer}&totalRetail={totalRetail}&buyerNbr={buyerNbr}&buyerComments={buyerComments}&vendorNbr={vendorNbr}&pinkQty={pinkQty}&requestStatus={requestStatus}&deniedReason={deniedReason}&retail={retail}&transfer={transfer}&pinkInvoice={pinkInvoice}&pinkId={pinkId}&vendorCharge={vendorCharge}&vendorComments={vendorComments}&reasonCode={reasonCode}&userId={userId}	Update the pink details
GET api/pink/createpinkitem?itemNum={itemNum}&storeNbr={storeNbr}	Populate pink item with retail, transfer, etc, to be used on submit screen to calculate credit and other information
GET api/pink/getpinktenshipments?storeNbr={storeNbr}&itemNbr={itemNbr}	Returns shipments of Pink Item within last 10 days. We will use the transfer, retail and date of these shipments to determine eligibility and credit on submit screen.
GET api/pink/getlastshippedandtransfer?storeNum={storeNum}&itemNum={itemNum}	Returns last day pink was requested from the store and the most recent transfer from DB2
GET api/pink/pinkreasons	Get reason codes and descriptions for pink items
GET api/pink/defaulttransfer?dept={dept}	Get default transfer percentage for pink items (used if they have no history at store to determine their transfer)
GET api/pink/transferandretailfornoinvoice?storeNbr={storeNbr}&itemNbr={itemNbr}&isRandWt={isRandWt}	Return most recent retail and transfer for an item if no invoice is selected from pink submit screen
GET api/pink/checkpinkeligibility?storeNbr={storeNbr}&totalRetail={totalRetail}&daysSinceReceipt={daysSinceReceipt}&itemClass={itemClass}&subClass={subClass}&pinkReason={pinkReason}	Used to determine the percentage of retail and transfer a store is eligible for (0%, 50% transfer or 100% of both retail and transfer)
POST api/pink/uploadPinkPhoto	Save or upload the pink images
POST api/pink/submit	This service will invoice on pnkmstp (as400) if approved and needs no buyer approval, insert to sql (regardless of status) and send email to buyer(s)/store to update them on the status of pink request
POST api/pink/sendstoreemail	send store email to update the status of pink request
GET api/pink/sendbuyeremail	Send email to associated buyers,dept heads and few more people in cc that there is Pending Pink Requests >=$1000 awaiting To be run on the 1st of every month
GET api/pink/getStores	No documentation available.
GET api/pink/getWarehouses	No documentation available.
POST api/Pinks?pinkInvoice={pinkInvoice}&pinkId={pinkId}&updateType={updateType}&userId={userId}	Update the pink log
GET api/Pinks	Validate whether the item number list has pallet or not
GET api/Pinks?itemNbr={itemNbr}	Get the pallet child items by item number
POST api/Pinks?itemNbr={itemNbr}&storeNbr={storeNbr}	The method will check if item is dsd item by checking the item in Bid Sheet table. If it ever was there then it is DSD item. We are only running it when store submits the Pink request.

StoreSettings

API	Description
GET api/rto/distrooverridebystore?dept={dept}	Web service to return list of dept override setting for each store
POST api/rto/upsertdistrominshipoverride	Web service to upsert override by distro type or minship
POST api/rto/updateminship	Web service to update minship override by dept and store number
POST api/rto/updateHispanicFlowStore	Update Hispanic Flow
GET api/rto/getHispanicFlowStores	Retrieve Hispanic Flow
GET api/rto/getStoreDetailsList?storeNbr={storeNbr}&allowEdit={allowEdit}	Getting store Detals
POST api/rto/UpdateStoreAllowEdit?storeNbr={storeNbr}&allowEdit={allowEdit}	Updating ALLOW_EDIT_RTO_EST_OH value in STORE Table

MaxQtyOverride

API	Description
POST api/distribution/updateMaxQtyOverride	Update Max Quantity

OperatorAdmin

Store Operator Admin Portal Provides the ability for the Store Operator to add Employees providing access to RTO based on Access Level. In addition, each user can be assigned Default (Roles) Filters

API	Description
GET api/OperatorAdmin/GetStoreUsers?storeNbr={storeNbr}	No documentation available.
GET api/OperatorAdmin/GetAccessLevels	Retrieves list of Store User Access Levels, excluding Operator
GET api/OperatorAdmin/GetValidDomains	Retrieves a list of Store User Valid Domains
GET api/OperatorAdmin/GetStoreOrderRoles?storeNbr={storeNbr}	Retrieves a list of Roles (Filters) defined by the Store specified
GET api/OperatorAdmin/GetStoreOrderRoleFilters?storeNbr={storeNbr}&roleID={roleID}	Retrieves a list of Role Filters defined by the Store specified
GET api/OperatorAdmin/AddStoreOrderRole?storeNbr={storeNbr}&roleName={roleName}&allowSubmit={allowSubmit}	Add STORE_ORDER_ROLE
GET api/OperatorAdmin/AddStoreOrderRoleFiltersFromDefault?storeNbr={storeNbr}&newRoleID={newRoleID}&copiedRoleID={copiedRoleID}	Add STORE_ORDER_ROLE_ROLE from default
GET api/OperatorAdmin/DeleteStoreOrderRole?storeNbr={storeNbr}&roleID={roleID}	Delete Store Order Role
GET api/OperatorAdmin/DeleteStoreOrderRoleFilter?storeNbr={storeNbr}&roleID={roleID}&roleFilterID={roleFilterID}	Delete Store Order Role Filter
POST api/OperatorAdmin/AddStoreOrderRoleFilter	Upsert Store Order Role Filters
POST api/OperatorAdmin/ResequenceStoreOrderRoleFilter	Upsert Store Order Role Filters
POST api/OperatorAdmin/AddStoreUser	Upsert Store User
POST api/OperatorAdmin/DeleteStoreUser?storeNbr={storeNbr}&Email={Email}	Delete Store User
GET api/OperatorAdmin/UpdateAllowSubmitForStoreOrderRole?storeNbr={storeNbr}&roleID={roleID}&allowSubmit={allowSubmit}	UpdateAllowSubmitForStoreOrderRole

CloudTrickle

API	Description
GET api/rts/getCloudTrickleTableDefinitionsVersionNumber	get latest version number of table definitions for cloud trickle
GET api/rts/getCloudTrickleTableDefinitions	get table definitions for cloud trickle
GET api/rts/getCloudTricklePosSettings?storeNbr={storeNbr}	get RTS POS settings
GET api/rts/getTlogToProcess?storeNbr={storeNbr}	get tlogs to process
POST api/rts/insertTlogToProcess	insert tlogs to process
POST api/rts/markTlogAsProcessed	mark tlogs as processed

Admin

Security Administration Management API Collection. Here you can create sets of Pages that belong to an associated Group, Users/Groups to which have access to those Pages, and extended Role privileges that can be used to control access to specific features or sections within a page.

API	Description
GET api/Admin	Returns a list of parts that make up the ACL [Group, Page, Role, User], as well as the current ACLs themselves
POST api/Admin/Groups	Create new Group Association Name record (Used for Grouping Pages)
PUT api/Admin/Groups	Update existing Group Association Name
DELETE api/Admin/Groups?id={id}	Delete Group association entry
POST api/Admin/Pages	Create new Page record
PUT api/Admin/Pages	Update existing Page
DELETE api/Admin/Pages?id={id}	Delete Page entry
POST api/Admin/Roles	Create new Role record
PUT api/Admin/Roles	Update existing Role record
DELETE api/Admin/Roles?id={id}	Delete Role entry
POST api/Admin/Users	Create new User record
PUT api/Admin/Users	Update existing User record
DELETE api/Admin/Users?id={id}	Delete User entry
POST api/Admin/ACL	Create new ACL (Access Control List) record
PUT api/Admin/ACL?id={id}	Update existing ACL (Access Control List) record
DELETE api/Admin/ACL?id={id}	Delete ACL entry

OSAllowanceStore

api call to get the list of stores/whses/opIn-optOut checks for OS Allowance page. Using store nbr and whse nbr and optIn/Opt out as optional parameters to retrieve the list from database. Joining cusmasp table to get the store names, WHSEP to get all available whses used for Ordering. Using 'A'as optIn parameter if both optIn-optOut selected to avoid the addition to query. and osoptinp table that keeps the optIn/optOut records

API	Description
GET api/osAllowanceStores/getOSAllowanceStoreResults?storeNbr={storeNbr}&WhseNbr={WhseNbr}&optIn={optIn}	Get the results list for selected stores/whses/option selected
POST api/osAllowanceStores/submitOptionChange	Update and save optIn/optOut changes for stores. Passing parameters from the front end to stored procedure as storeNbr-whseNbr-OptIn/Out-CreatedBy-EffectiveDate Adding extra check for user name to trim if more than 10 characters.

UOGSecondaryWhseClassSubclassExclusion

API	Description
GET api/rto/UpdateEmptyListUOGSecondaryExclusionsNew
GET api/rto/listUOGSecondaryExclusionsNew
GET api/rto/listUOGSecondaryExclusions
POST api/rto/insertUOGSecondaryExclusion	Insert into UOG_SECONDARY_WHSE_CLASS_SUBCLASS_EXCLUSION
POST api/rto/deleteUOGSecondaryExclusion	Delete for UOG_SECONDARY_WHSE_CLASS_SUBCLASS_EXCLUSION

StoreOrderDashboard

API	Description
GET api/rto/updateorderstatus?status={status}&orderNbr={orderNbr}&user={user}	Update Status of order (not cancel or expire)
GET api/rto/getstoreorderdashboard?storeNbr={storeNbr}&status={status}&showNotStarted={showNotStarted}&windowDate={windowDate}	Returns the data to populate the store order dashboard and store order window grid
POST api/rto/allowsubmit	This method allows the enablement of an Order Window by Order Number Sets the IGNORE_WEIGHT_CUBE_LIMITS which in turn sets the AdminIgnoreLimits property in the Order Guide object to true. If true, cube and weight limits are ignored, and submit is enabled.
GET api/rto/extendWindowTime?logID={logID}	Extended Window Time one hour
POST api/rto/hasActiveOrderWindow	Check if store has active order window
GET api/rto/getStoreOrderTypeDetails?storeNbr={storeNbr}&inOrderTypeNbr={inOrderTypeNbr}	Fetch all Warehouses by StoreOrderType number.
GET api/rto/getInclusionWhsesForWindow?sowLogID={sowLogID}	This will return the inclusion whses for a store that has opened a new order window, this will use the log ID as the parameter so that it can be used both for scheduled orders as well as
POST api/rto/updateDeliveryDateForOrder	Update Delivery Date in STORE_ORDER_WINDOW_LOG_UOG table.
GET api/rto/disableMaxQty?orderNbr={orderNbr}&updatedBy={updatedBy}	Disable Max Ship For Store Order
GET api/rto/ExportStoreOrders?windowDate={windowDate}	Create data for export store orders
GET api/StoreOrderDashboard?storeNbr={storeNbr}&orderTypeNbr={orderTypeNbr}	This method will return the next order window for a store given an order type. it will take the current date and time and check for the next available order widow based on the cutoff date/time
GET api/StoreOrderDashboard?cutOffDay={cutOffDay}&cutOffTime={cutOffTime}	This will get the start time that a store can begin ordering

RouteDeliveryAdmin

Get route delivery admin vendors information

API	Description
GET api/routeDeliveryAdmin/getRouteDeliveryVendors	Get all route delivery admin vendors information
GET api/routeDeliveryAdmin/deleteRouteDeliveryVendor?vendorNbr={vendorNbr}	Remote Delivery vendor from as400
GET api/routeDeliveryAdmin/getVendors?searchVendor={searchVendor}	Get vendor list by search
POST api/routeDeliveryAdmin/addRouteVenodr	Insert vendor into route delivery admin table(RTEDLVVENP) in AS400
GET api/routeDeliveryAdmin/getSearchVendors	No documentation available.

PublicWOW

Contains WOW Alert API's to be consumed by third party vendors.

API	Description
GET api/wowalerts/GetApprovedWowAlerts?createdate={createdate}	Get final list of Wow alerts for a given day
GET api/wowalerts/getStoresWowsByDate?wowdate={wowdate}&listOfStores={listOfStores}	Get list of wow alerts by date by list of stores
GET api/wowalerts/GetTodaysApprovedNewItemAlerts?storeNum={storeNum}	Will return the list of New Item Alerts (aka Digial Ad Items) for the current day. Currently only intended to be run on Mondays.
GET api/PublicWOW?createdate={createdate}	Generates the list of WOW alerts that are approved for public API
GET api/PublicWOW?wowdate={wowdate}&listOfStores={listOfStores}
POST api/PublicWOW	No documentation available.

HelperTools

API	Description
GET api/fog/RemoveBatchRecords?vendorNbr={vendorNbr}	This method is for Dev use only in QA tools page. Once records are removed, buyers can access vendor records in as400
POST api/fog/removeItemLock?userName={userName}	No documentation available.

Fog

API	Description
GET api/fog/GetVendorContact?VendorNbr={VendorNbr}	Vendor contact information
POST api/fog/updateVendorContact
GET api/fog/searchvendors?searchVendor={searchVendor}	Vendor seach service
GET api/fog/GetFogVendorsByStore?storeNbr={storeNbr}	Vendor seach service
GET api/fog/newitemsearch?searchString={searchString}&vendorNbr={vendorNbr}	New Item search service : US 4959. Buyers select existing items associated with vendor selected
POST api/fog/getitemstobeaddedlist
POST api/fog/createstoregroup	Creating new store group,inserting it to the fog_store_group_header
POST api/fog/deletestoregroup	Removing one store Group at a time from the fog_store_group_header table
GET api/fog/copystoregroup?destinationVendor={destinationVendor}&destinationGroupId={destinationGroupId}&sourceGroupId={sourceGroupId}
POST api/fog/updatestoregroupname	Updating the store group name by inserting it to fog_store_group_header
POST api/fog/insertstorestostoregroup	Inserting a list of stores to the Group detail table: Checking for unique combination of storeGroup and Store, then inserting it to the fog_store_group_detail
POST api/fog/removestorefromstoregroup	Delete the store from the store group: check if the store exists in the storeGroup and delete record
GET api/fog/vendorStoreSearch?searchText={searchText}&vendorNbr={vendorNbr}&groupNbr={groupNbr}&state={state}	No documentation available.
GET api/fog/listVendorStoreGroupStores?groupNbr={groupNbr}	No documentation available.
GET api/fog/listVendorStoreGroups?vendorNbr={vendorNbr}	No documentation available.
GET api/fog/getSearchFogGroups?vendorNbr={vendorNbr}&searchText={searchText}	No documentation available.
GET api/fog/listCountriesOfOrigin	get list of all used coutries stored in Flex Order Guide
GET api/fog/updateUnitOfMeasureTableList	No documentation available.
GET api/fog/listUnitOfMeasure	No documentation available.
POST api/fog/updateSequenceDSDItems	Service to update sequence for existing items by updating FLEX_ORDER_GUIDE_SORT table if item-vendor record already exist. OR inserting if item-vendor record doesnt exist in FLEX_ORDER_GUIDE_SORT table And then updating sequence in as400 table
POST api/fog/LoadCreateFOGOrderGuide	The service is gathering item information from flex _order _guide/fobidshp/other item info tables in order to return item latest values for user in Create Item Page for new bidsheet creation.
GET api/fog/getExistingDSDOrderGuide?vendorNbr={vendorNbr}&groupByDate={groupByDate}	This will return a list of all DSD order guide records that have an ending date after today.
POST api/fog/updateExistingDsdOrderGuideEndDate	The method is updating the record from Date View
POST api/fog/upsertExistingDsdOrderGuideRecord	The method is updating the record from Items View
POST api/fog/checkForExistingPOinDateView	When user wants to delete item/date range with items, we want to check if there was a PO already created for the items
POST api/fog/deleteExistingDSDItem	No documentation available.
POST api/fog/deleteDateRangeForItems	The method is to delete all items associated with selected date range and vendor number. We are not sending item in parameters as we are sending a list if IDs to be deleted
POST api/fog/deleteExistingDSDItemDateRange	Service to delete specific existing DSD item date range selected by user on front end
POST api/fog/uploadFile	No documentation available.
POST api/fog/copyGroupPriceListToStoreAPI
POST api/fog/RemoveStoreFromGroupPriceListAPI
GET api/fog/checkIfGroupHasPriceList?groupNbr={groupNbr}
POST api/fog/checkForOverlappingDateRange	Per US17327 we need to validate if the new storesToBeAdded already have items about to be added with the overlapping date range. (items about to be added are the items associated to the original store group , overlapping dates: we need to check the items from any vendors for the new stores between the from date and to date of the original store group date range)
POST api/fog/updateGroupPriceListForStore
POST api/fog/InsertFlexOrderGuide	No documentation available.
GET api/fog/InsertLegacyBidSheet?vendorNbr={vendorNbr}	No documentation available.
POST api/fog/checkForExistingPOinItemView	When user wants to delete or update an item/date range with items, we want to check if there was a PO already created for the items
POST api/fog/checkExistingPOforAllItems	When user wants to delete an item, we want to check if there was a PO already created for the items and the delivery date is greater than Today
POST api/fog/validatePOforRemovedStores
GET api/fog/dsdsearchItems?searchText={searchText}&vendorNbr={vendorNbr}&row={row}&Dept={Dept}
POST api/Fog?FILTERED_ITEMS={FILTERED_ITEMS}&FILTERED_START_DATE_OPTION={FILTERED_START_DATE_OPTION}&FILTERED_START_DATE1={FILTERED_START_DATE1}&FILTERED_START_DATE2={FILTERED_START_DATE2}	No documentation available.
POST api/Fog?distinctGroups={distinctGroups}&distinctStores={distinctStores}&intVendorNbr={intVendorNbr}&userName={userName}	No documentation available.
POST api/Fog?vendorNbr={vendorNbr}&groupNbr={groupNbr}&storeNbr={storeNbr}	No documentation available.
POST api/Fog?groupNbr={groupNbr}&storeNbr={storeNbr}&userName={userName}&dateOptionSelected={dateOptionSelected}	This method creates a record for a new added store: It takes all group associated available items and copies it for the new store
POST api/Fog?vendorNbr={vendorNbr}&storeNbr={storeNbr}
POST api/Fog?groupNbr={groupNbr}
POST api/Fog?userName={userName}	Method will loop through saved records in sql and as400 and if there is a discrepancy(batch failed in as400 and item wasnt saved),it will remove record from sql and send user an email. Looping through all items because the next items after the failed one wont be inserted: example 3 items, item 1 was saved ,item #2 failed, item #3 wont get inserted to sql. We are removing item # 2 and #3 from sql(nothing was saved in as400) and sending user an email.
POST api/Fog?itemNbr={itemNbr}	No documentation available.
DELETE api/Fog?vendorNbr={vendorNbr}&itemNbr={itemNbr}	No documentation available.
DELETE api/Fog?vendorNbr={vendorNbr}&itemNbr={itemNbr}&storeNbr={storeNbr}&maxDeliveryDate={maxDeliveryDate}	No documentation available.
GET api/Fog?item={item}	No documentation available.
GET api/Fog?itemNbr={itemNbr}	No documentation available.
POST api/Fog?errorMsgHeader={errorMsgHeader}&actualError={actualError}	No documentation available.
POST api/Fog?groupNbr={groupNbr}&storeNbr={storeNbr}&userName={userName}&vendorNbr={vendorNbr}&dateOptionSelected={dateOptionSelected}	No documentation available.

Lexmark

API	Description
GET api/lexmark/getStoreLogin?storeNbr={storeNbr}	get lexmark store login info

WowAlert

API	Description
GET api/wowalerts/removeStoreItem?storeNbr={storeNbr}&itemNbr={itemNbr}	No documentation available.
POST api/wowalerts/addStoreItem?storeNbr={storeNbr}	No documentation available.
GET api/wowalerts/searchItems?searchText={searchText}&take={take}&storeNbr={storeNbr}	No documentation available.
GET api/wowalerts/getAlerts?storeNbr={storeNbr}	Lists veto and wow items for update
GET api/wowalerts/getWowVetoReasons?itemType={itemType}	Get veto reasons depending on type of item being vetoed
GET api/wowalerts/getstorewowstatus	Service to get the status of all stores (true/false) regarding their eligibility to receive wow alerts
POST api/wowalerts/updatewowdisabled	Updates WOW_DISABLED_STORES - inserts any disabled stores and removes all enabled stores
GET api/wowalerts/veto?user={user}&reason={reason}&itemType={itemType}&id={id}	Set approved status to "N", input a reason and save user changes
GET api/wowalerts/undoveto?itemType={itemType}&id={id}&user={user}	Undo Veto flag and remove reason from table
POST api/wowalerts/updateAdItem	Update Item in either wow or new alerts table
GET api/wowalerts/sendWowEmails?sendToSingleStoreNbr={sendToSingleStoreNbr}	Send wow alert mails to respective recipients
GET api/wowalerts/getblackoutdates	Service to retrieve black out dates from WOW_BLACKOUT_DATES sql table
POST api/wowalerts/addblackoutdate	Service to add a new black out date to sql table
POST api/wowalerts/updateblackoutdate	Service to update or delete -- we use the original date to look up the value in SQL
GET api/wowalerts/primeWowEmails	api to setup data for wow alert email job located @ /api/wowalerts/sendWowEmails
GET api/wowalerts/sendWowAlertEmails	api to send wow alert emails after "api/wowalerts/primeWowEmails" api has been run
GET api/wowalerts/sendWowAlertProduceEmails	api to send wow alert produce emails
GET api/wowalerts/getWOWExcludedVendorsList	Fetch excluded vendor list from WOW ALert API
GET api/wowalerts/addWOWExcludedVendor?vendorNbr={vendorNbr}&user={user}	Add vendor in Wow API
GET api/wowalerts/deleteWOWExcludedVendor?vendorNbr={vendorNbr}	This API will remove selected WOW excluded vendor record from database
GET api/wowalerts/getWOWParameters	API to fetch wow alert parameters and digital ad list
POST api/wowalerts/updateWOWAlertRecord	this API updates the wow alert record for either WOW alert Parameter or Digital Ad depending on a type selected by user on UI
POST api/WowAlert?storeNbr={storeNbr}	Method to send wow alert emails to respective recipients
POST api/WowAlert?storeNbr={storeNbr}&isMonday={isMonday}&operatorName={operatorName}&emailAddress={emailAddress}
POST api/WowAlert?isPrime={isPrime}	This will check the Prime status, if is prime is set to true, it will check if the LAST_PRIME_START is not today, and then set it to now, then return true. if isPrime is set to false, it will check to make sure LAST_PRIME_COMPLETE is set to some time today, then return true.

StoreFinancialReporting

API	Description
POST api/POC/PostStoreFinancialReport	No documentation available.
POST api/POC/SaveStoreFinancialReport	No documentation available.

TruckSettings

Handling incoming HTTP requests of Truck Settings and sending response back to the caller

API	Description
GET api/TruckSettings/GetAllTruckInfo	Returns a list of all Store Warehouse truck information This Method is not using.
GET api/TruckSettings/getStoreWhseTruck	Getting all Warehouse Truck information of active stores and storegroups.
GET api/TruckSettings/getAllWhse	This service returns a list of all warehouses.
GET api/TruckSettings/getTruckExceptionDetails?StoreNbr={StoreNbr}&WhseNbr={WhseNbr}	Retuns Truck Dimensions associated store and warehouse
GET api/TruckSettings/getTruckDimension	This service returns a list of all Trucks Dimensions.
POST api/TruckSettings/InsertStoreWhsTruck	Insert/Update record in Store warehouse truck Table
POST api/TruckSettings/deleteStoreWhsTruck	Delete Store Warehouse Truck Dimensions.
GET api/TruckSettings/getsearchgroups?searchText={searchText}	Retrieves list of stores and groups based on search text
POST api/TruckSettings/uploadOrderLimit	Upload case limit data into Store warehouse truck Table
GET api/TruckSettings?ExcludeClosed={ExcludeClosed}&ExcludeUnopened={ExcludeUnopened}	Returns list of active stores

OrderDetails

API	Description
GET api/WWO/GetOrderDetail?StoreNbr={StoreNbr}&orderNbr={orderNbr}&Whs={Whs}	Fetch all Order Details from AS400 Procedure GET_ORDER_ITEMS

StoreAttributes

API	Description
POST api/iofinancial/listStoreFinancialAttribute	Get the list of financial attribute stores
POST api/iofinancial/upsertStoreFinanacialAttribute	insert/update the store financial attribute
POST api/iofinancial/deleteStoreFinanacialAttribute	Service to delete store financial attribute from store financial attribute table
GET api/iofinancial/hasIOFinancialAccess?storeNbr={storeNbr}	Service to validate whether the store has io fincancial access or not

BreadPricing

API	Description
GET api/breadpricing/getstores?hasExtPriv={hasExtPriv}	Service to return all stores for those with extended privileges or stores with future opening dates for all others
GET api/breadpricing/getvendors?storeNbr={storeNbr}	Retrieve a list of all bread vendors for a given store
POST api/breadpricing/createstoredocs	This service creates store doc numbers, downloads from host, verifies and then applies these doc numbers to a store

Account

API	Description
GET api/Account/UserInfo	No documentation available.
POST api/Account/Logout	No documentation available.
GET api/Account/ManageInfo?returnUrl={returnUrl}&generateState={generateState}	No documentation available.
POST api/Account/ChangePassword	No documentation available.
POST api/Account/SetPassword	No documentation available.
POST api/Account/AddExternalLogin	No documentation available.
POST api/Account/RemoveLogin	No documentation available.
GET api/Account/ExternalLogin?provider={provider}&error={error}	No documentation available.
GET api/Account/ExternalLogins?returnUrl={returnUrl}&generateState={generateState}	No documentation available.
POST api/Account/Register	No documentation available.
POST api/Account/RegisterExternal	No documentation available.

DsdStoreOrder

API	Description
GET api/fog/getStoreVendors?storeNbr={storeNbr}	get store vendors with items having valid dates
GET api/fog/GetVendorNameByNbr?VendorNbr={VendorNbr}	Get Vendor Name
GET api/fog/getDSDstatus?storeNbr={storeNbr}	Method is looking for store rollout table to check for vendors being rollout for current date. Then out of those rollout vendors checking if any of them are active and filtering out. Then if any left, we are looking for an active bidsheet(current date) for store-vendor combination.If any-we return vendors list to display.
GET api/fog/getFlexOrderGuide?storeNbr={storeNbr}&vendorNbr={vendorNbr}&deliveryDate={deliveryDate}	get store vendors with items having valid dates
GET api/fog/getPoItemDetails?storeNbr={storeNbr}&poNbr={poNbr}&vendorNbr={vendorNbr}&deliveryDate={deliveryDate}	Get order details for store to start receiving PO selected
GET api/fog/getitemupc?itemNbr={itemNbr}&storeNbr={storeNbr}	Get UPC from ItemNbr + StoreNbr combination
GET api/fog/areStoresDefaultPartners?storeNbrA={storeNbrA}&storeNbrB={storeNbrB}&miles={miles}	AreStoresDefaultPartners
GET api/fog/listAuthorizedSplitPartners?vendorNbr={vendorNbr}&storeNbr={storeNbr}&miles={miles}&allow={allow}&separateOverrideList={separateOverrideList}	ListAuthorizedSplitPartners
GET api/fog/listStoresInRange?storeNbr={storeNbr}&miles={miles}	ListStoresInRange
GET api/fog/listDsdSplitOverride?vendorNbr={vendorNbr}	List Dsd Split Override
GET api/fog/upsertDsdSplitOverride?vendorNbr={vendorNbr}&storeNbrA={storeNbrA}&storeNbrB={storeNbrB}&allow={allow}	Upsert Dsd Split Override
GET api/fog/deleteDsdSplitOverride?vendorNbr={vendorNbr}&storeNbrA={storeNbrA}&storeNbrB={storeNbrB}	Delete Dsd Split Override
GET api/fog/disableSplitOrder?vendorNbr={vendorNbr}	Calling service removes record for selected vendor from db.DSD_SPLIT_VENDOR and db.DSD_SPLIT_OVERRIDE tables
GET api/fog/lookUpExistingSplitOrder?storeNbr={storeNbr}&vendorNbr={vendorNbr}	No documentation available.
POST api/fog/modifyDsdOrderGuide	No documentation available.
POST api/fog/submitDsdOrderGuide	Submit Dsd Order Guide
GET api/fog/splitVendorLookup?vendorNbr={vendorNbr}	No documentation available.
GET api/fog/getVendorSplitRules?vendorNbr={vendorNbr}	Service to get the existing rules for vendor split
GET api/fog/deleteSplitVendorRules?vendorNbr={vendorNbr}	No documentation available.
POST api/fog/saveSplitVendorRules	No documentation available.
GET api/fog/getVendorInfoByVID?vendorNbr={vendorNbr}	Featch Vendor Information by Vendor ID
POST api/fog/updateVendorInfo	Update Vendor Information
POST api/fog/CheckDuplicateDSDStoreRollout	No documentation available.
POST api/fog/DeleteDSDStoreRollout	No documentation available.
GET api/fog/getDSDStoreRollout	No documentation available.
GET api/DsdStoreOrder?storeNbr={storeNbr}	Method to call as400 store vendor DSD rollout table and find out what vendors are being rollout for specific store
POST api/DsdStoreOrder?storeNbr={storeNbr}&action={action}	The method is used to call as400 to create/update Purchase Order
GET api/DsdStoreOrder?storeNbr={storeNbr}&poNbr={poNbr}&vendorNbr={vendorNbr}&deliveryDate={deliveryDate}	No documentation available.

UpchargeMaintenance

API	Description
GET api/upchargemaintenance/getUpchargePercent	Returns a list of all upcharge Percents by deptartment form the upchgdp table
GET api/upchargemaintenance/getUpchargeExceptions	Returns a list of all Upcharge Exeptions
POST api/upchargemaintenance/submitChanges	Service to submit the upcharge maintenace changes

DataMaintenance

This will contain webservices to be used in any of the DataMaintenance/Admin applications

API	Description
GET api/DataMaintenance/getStoreWarehouseDeptGrid?storeNbr={storeNbr}	This will populate a list of all warehouses and departments and whether this store warehouse combonation is valid. This is to be used in a grid on the StoreWarehouseDept datamaintenance page.
GET api/datamaintenance/storeswithnowhsedeptmapping	Look Up Stores with no whse or dept mapping
POST api/datamaintenance/updatestorewhsedept
GET api/dataMaintenance/blackBoxDiagnostic?storeNbr={storeNbr}	blackBoxDiagnostic
GET api/dataMaintenance/physicalInventoryAudit?storeNbr={storeNbr}&toEmail={toEmail}	physicalInventoryAudit a.k.a. Inventory by SKU
GET api/dataMaintenance/clearWineInventory	Clear data added before 6 months
GET api/DataMaintenance/listAffinityStores	No documentation available.
GET api/DataMaintenance/addAffinityStore?storeNbr={storeNbr}&affinityStoreNbr={affinityStoreNbr}	No documentation available.
GET api/DataMaintenance/deleteAffinityStore?storeNbr={storeNbr}&affinityStoreNbr={affinityStoreNbr}	No documentation available.
GET api/DataMaintenance/upsertAffinityStore?currStoreNbr={currStoreNbr}&currAffinityStoreNbr={currAffinityStoreNbr}&newStoreNbr={newStoreNbr}&newAffinityStoreNbr={newAffinityStoreNbr}	This api upserts store and affinity store records into qs36f.AFPFSTRP
POST api/DataMaintenance/uploadAffinityStore	Method to upload the file for affinity stores,validate the records and insert if dont exist yet.
POST api/DataMaintenance/updateExistingPinkRecords	Adding new class,subclass,is_dsd_item columns to Pink table and need to fill in the data for the existing records
GET api/dataMaintenance/PopulateIncrementTable	Service to bulk insert into the INCREMENT table
GET api/dataMaintenance/WineShelfTalkerExtract	Service to retrieve the wine shelftalker details
POST api/DataMaintenance?apiEndPoint={apiEndPoint}&ApiUri={ApiUri}	Connecting Lexmark API
POST api/DataMaintenance?value={value}&significance={significance}	No documentation available.

GetRetail

API	Description
POST api/POC/getRetail	Retrieves the item information for a given list of UPC's and storenumbe, then returns the results for consumption by Cloud Trickle Agent

GetRetail2

API	Description
POST api/rts/getRetail	Retrieves the item information for a given list of UPC's and storenumbe, then returns the results for consumption by Cloud Trickle Agent

AdDelayDays

API	Description
GET api/AdDelays/getAllWhse	Returns a full list of all Default States
GET api/distribution/getDefaultStates	Get list of all Default States
GET api/distribution/getStores	Get list of All Stores
POST api/AdDelays/AddStoreAdDelay	Created Ad Delay Days for Store Warehouse
POST api/AdDelays/DeleteStoreAdDelay	Deleting the AdDelayDays for Store Warehouse
POST api/AdDelays/UpdateStoreAdDelay	Updating the AdDelayDays for Store Warehouse
POST api/AdDelays/UpdateStateAdDelayDays	This Method is used to update the addDays on condition chek whseNbr and State.

GetExistingFilteredItems

API	Description
POST api/fog/getExistingDSDOrderGuideFiltered	This method is to get filtered results on Existing DSD page depending on parameters selected by user,default is to Item View with no parameters
POST api/fog/getItemFilterSearch	No documentation available.
POST api/fog/getItemNextDateRange	No documentation available.
POST api/GetExistingFilteredItems	No documentation available.
POST api/GetExistingFilteredItems?maxEndDate={maxEndDate}&dateRangeLimit={dateRangeLimit}&isFilterOn={isFilterOn}	The method will filter items by date range
POST api/GetExistingFilteredItems?maxEndDate={maxEndDate}&itemsViewLimit={itemsViewLimit}&isFilterOn={isFilterOn}	The method will filter items by items,not by date range
POST api/GetExistingFilteredItems?itemsViewLimit={itemsViewLimit}	This method will Identify if the store group already have 2 recent date ranges and limit it to the passed parameter 'itemsViewLimit'number. We only want to display 2 recent date ranges for the store group. Stores that were added separately will be displayed as usual.
POST api/GetExistingFilteredItems?vendor={vendor}	Get the active POs details by vendor number from AS400

OrderGuideRequests

API	Description
GET api/orderguiderequest/getStatusList	Fetch all Requested Order status List.
GET api/orderguiderequest/getAllOrderWindowRequests	Fetch all Requested Orders from Last 14 days.
POST api/orderguiderequest/UpdateWhseChangeWithStatus	Update the Requested order with Modified data in database.
GET api/orderguiderequest/GetOrderRequestBysowID?sowID={sowID}	Fetch Requested Order by SowID from table STORE_ORDER_WINDOW_UOG
GET api/orderguiderequest/getWhseAllowHalfTruck?whseNbr={whseNbr}	Fetch Truck information by Warehouse.
GET api/orderguiderequest/getRequestOGWindow	Fetch all Request OG based on status.
POST api/OrderGuideRequests	Fetch existing Order Guide to avoid duplication of Orders.

NewOrderRequests

API	Description
POST api/newOrderGuideRequest/createOrderWindowRequest	Create Order Window Request by inserting data in table STORE_ORDER_REQUEST_WINDOW.
GET api/newOrderGuideRequest/getAllActiveOrderWindowRequest?storeNbr={storeNbr}	Fetch all Active Orders from the table STORE_ORDER_REQUEST_WINDOW
GET api/newOrderGuideRequest/deleteActiveOrderWindowRequest?ID={ID}	Delete Requested Order from the table STORE_ORDER_REQUEST_WINDOW
GET api/newOrderGuideRequest/getDefaultWhForUser?userName={userName}	Fetch all warehouse by UserName.
POST api/newOrderGuideRequest/UpdateStoreRequestChanges	Update Requested Order with modified data in table STORE_ORDER_REQUEST_WINDOW

Notifications

API	Description
GET api/notifications/setcookie	Method to set auth token in cokkie This is needed for calling stream api (using EventSource in JS)
GET api/notifications/stream?storeNbr={storeNbr}	Stream method that is authorized through cookie

WhseMissingPhotoReport

Product Image Management

API	Description
GET api/runWhsemissingPhotoReport?inputDate={inputDate}&reportType={reportType}	Update WEICNTRL table

Distribution

API	Description
POST api/distribution/cancelcurrentpendingdistro?userName={userName}&distID={distID}&isShuttle={isShuttle}	Removes current pending distribution from PENDING_DISTRIBUTION_ID
GET api/distribution/getdistributionreason	Return a list distribution reasons
GET api/distribution/getvalidwhsecount?itemNbr={itemNbr}	This will get a count of whses that an item can be distributed from. It is used to disable distributions for items that have no valid whses.
GET api/distribution/getexistingdistributionstoresformodify?distroID={distroID}	This service, given a DistributionID will return a list of stores/warehouses that are eligible for modify (no qty has been distributed yet)
GET api/distribution/getDistributionAttributesForOrder?distroID={distroID}&orderNbr={orderNbr}	Fetch all distribution attributes for orderNbr.
GET api/distribution/getexistingdistributionreferenceitems?distroID={distroID}	This service will return any reference items used during calculation.
GET api/distribution/getexistingdistributionlinkeditems?distroID={distroID}	This service will return any linked items used during calculation.
GET api/distribution/getexistingdistributiondetails?distroID={distroID}	This service will return all the distibution Item details.
POST api/distribution/getSearchFromItemList	.
POST api/distribution/syncdistrosapresponse	sync distro sap response
POST api/distribution/republishdistribution?isAutoReprocess={isAutoReprocess}&reprocessBufferTime={reprocessBufferTime}&reprocessMaxCount={reprocessMaxCount}	No documentation available.
GET api/distribution/ageditems?Dept={Dept}&ClassNbr[0]={ClassNbr[0]}&ClassNbr[1]={ClassNbr[1]}&AgedMonths={AgedMonths}&SubClassNbr={SubClassNbr}&BuyerNbr={BuyerNbr}	Retrieves Aged Items from the Legacy Database
GET api/distribution/expiryitems?Dept={Dept}&ClassNbr[0]={ClassNbr[0]}&ClassNbr[1]={ClassNbr[1]}&ExpireDays={ExpireDays}&SubClassNbr={SubClassNbr}&BuyerNbr={BuyerNbr}	Retrieves Aged Items from the Legacy Database
GET api/distribution/newitems?Dept={Dept}&ClassNbr[0]={ClassNbr[0]}&ClassNbr[1]={ClassNbr[1]}&SubClassNbr={SubClassNbr}&BuyerNbr={BuyerNbr}	Retrieves New Items (Items that have not sold from the Legacy Database
GET api/distribution/topitems?Dept={Dept}&ClassNbr[0]={ClassNbr[0]}&ClassNbr[1]={ClassNbr[1]}&SubClassNbr={SubClassNbr}&BuyerNbr={BuyerNbr}	Retrieves Top selling items
GET api/distribution/aditems?Dept={Dept}&ClassNbr[0]={ClassNbr[0]}&ClassNbr[1]={ClassNbr[1]}&SubClassNbr={SubClassNbr}&BuyerNbr={BuyerNbr}	Retrieves Ad items
GET api/distribution/scoreitems?Dept={Dept}&ClassNbr[0]={ClassNbr[0]}&ClassNbr[1]={ClassNbr[1]}&SubClassNbr={SubClassNbr}&BuyerNbr={BuyerNbr}	Retrieves Score items
GET api/distribution/onhanditems?Dept={Dept}&ClassNbr[0]={ClassNbr[0]}&ClassNbr[1]={ClassNbr[1]}&OhQtyLowerRange={OhQtyLowerRange}&OhQtyUpperRange={OhQtyUpperRange}&SubClassNbr={SubClassNbr}&BuyerNbr={BuyerNbr}	Retrieves On Hand Items (Items that have a qty > zero in the warehouse
GET api/distribution/shuttleitems?Dept={Dept}&ClassNbr[0]={ClassNbr[0]}&ClassNbr[1]={ClassNbr[1]}&status={status}&SubClassNbr={SubClassNbr}&BuyerNbr={BuyerNbr}	Retrieves Shuttle Items
GET api/distribution/onorderitems?Dept={Dept}&ClassNbr[0]={ClassNbr[0]}&ClassNbr[1]={ClassNbr[1]}&DeliveryDays={DeliveryDays}&SubClassNbr={SubClassNbr}&BuyerNbr={BuyerNbr}	Retrieves On Order Items
GET api/distribution/MoveDistroToAdOrder
POST api/distribution/CreateAutoDistributionCriteria	Create Auto Distribution Criteria.
POST api/distribution/UpdateAutoDistroCriteriaPriority	Update the Distribution Criteria Priority
POST api/distribution/DeleteAutoDistribution	service to soft delete the auto Distribution selected.Log deleted id on log table
GET api/distribution/updateAutoDistributionStatusDate?id={id}&action={action}	Start distribution updates the start date,end date and sets Active to 1. End distribution sets end date to now and active status to 0.
GET api/distribution/getExistingAutoDistros	Service to list AutoDistributions for existing AutoDistributions Page
GET api/distribution/getExistingAutoDistroDetails?id={id}	Service is used to fetch Existing AutoDistribution Details
GET api/distribution/beginAutoDistributionBatch	This will be executed daily, it will look at all of the distribution critieria that have been created, it will then add any items that meet the criteria to the batch table, then it will calculate those items to the selected stores/whse combinations, then create the distributions.
POST api/distribution/previewAutoDistroItems	Reutrns a list of items based on selected parameters
GET api/distribution/ReprocessSingleAutoDistroCriteriaFromBatch?criteriaID={criteriaID}&batchID={batchID}	To Reprocess the Distribution Criteria by BatchId.
POST api/distribution/uploadAutoDistroFile	No documentation available.
GET api/distribution/getBulkOrderCount?storeNbr={storeNbr}&date={date}	Returns a bulk orders Count that have been created.
GET api/distribution/getBulkOrders	Returns a full list of all bulk orders that have been created.
POST api/distribution/upsertBulkOrder	Upserts a records to the database, will go through all three parts of the object to insert each section to it's correlating database object.
POST api/distribution/deleteBulkOrder	Delete (Check if there a store record for this bulk order, if there is, update the warehouse table to all be disabled, else delete the row)
GET api/distribution/getBulkOrderStoreCount?bulkOrderID={bulkOrderID}	Returns bulk orders of Store Count that have been created.
GET api/distribution/itemsearch?searchText={searchText}&take={take}	This is used for Search an Item async.
GET api/distribution/getStoreBulkOrders?storeNbr={storeNbr}&date={date}	This is used for search Item
GET api/distribution/getEligibleBulkOrderItems?storeNbr={storeNbr}&date={date}	Returns a full list of all eligible bulk orders that a store can create within date range.
POST api/distribution/deleteEligibleBulkOrderItem	deletes a store's eligibleBulkOrderItem by setting qty to zero
POST api/distribution/upsertEligibleBulkOrderItem	Upserts db records related to a store's eligibleBulkOrderItem
GET api/distribution/approveBulkOrderRequestQty?bulkOrderID={bulkOrderID}&whseNbr={whseNbr}&storeNbr={storeNbr}&distributionID={distributionID}	Approve Bulk Order Request Status
GET api/distribution/denyBulkOrderRequestQty?bulkOrderID={bulkOrderID}&whseNbr={whseNbr}&storeNbr={storeNbr}&deniedReason={deniedReason}&distributionID={distributionID}	Deny Bulk Order Request Status
GET api/distribution/GetBulkOrderStatusDetails?bulkOrderID={bulkOrderID}	This is similar to GetBulkOrders only it passes in a Bulk Order Id to only return for one bulk order
GET api/distribution/getdistributionusers	Service to get active distribution users for the dropdown on UI
POST api/distribution/getDeleteDistributionPreview	Getting the distributions by parameters selected for user to preview so they can see what to delete
POST api/distribution/deleteDistributionCriteriaPaginated	Delete Distribution Criteria Paginated details
POST api/distribution/deleteSelectedDistributions	DeleteSelectedDistributions
POST api/distribution/deleteDistributionCriteria	The service is used to set qty remainign for selected distributions to 0 in distribution_store table and call batch program to update qty on reserve in SAP
POST api/distribution/deleteDistributionById?distributionId={distributionId}	Deleting the distribution based on DistributionIds
GET api/distribution/getdistributionexceptions	This will call a stored procedure accross linked server and will return all distributions where the db2 qty does not match the as400 holding order.
GET api/distribution/getdistributiondb2journal?distroID={distroID}&storeNbr={storeNbr}	This will get all journal activity on the as400 for an item after a specific distribution has been created (to the day). This may only work in Prod(sfoffice) as expected.
GET api/distribution/getorderswithdistroitem?distroID={distroID}&storeNbr={storeNbr}	This will return all orders that contain this item since the distribution has been created
GET api/distribution/getdistributionsqljournal?distroID={distroID}&storeNbr={storeNbr}	This will get all journal activity that has been recorded in SQL server
POST api/distribution/updatedistributionsqlqty	This will update the SQL distribution_store table and write to the log before and after the update.
POST api/distribution/updatedistributiondb2qty	This will update the db2 holding order.
GET api/distribution/searchDistroMaint?searchString={searchString}	This service is used to return distribution maintance search result.
GET api/distribution/searchDistroMaintStores?distroID={distroID}&whseID={whseID}	This method will check both SQL and DB2 for the current Qty for a distribution
GET api/distribution/clearExpiredDistroQty	This service Clear expired distribution Quantities.
GET api/nightjob/distributionlogtablecleanup	Retrieve a list of records from table that are created longer than 2 days ago Insert it to archive table and clean up from the original table.
POST api/distribution/createdistribution	Create distribution by Insert DISTRIBUTION_ITEM DISTRIBUTION_WAREHOUSE DISTRIBUTION_STORE
POST api/distribution/updatedistribution?_distributionID={_distributionID}	Update distribution
GET api/distribution/createshuttleorder?toWhse={toWhse}&fromWhse={fromWhse}&userId={userId}	Create Shuttle
GET api/distribution/createshuttle?shuttleOrderNbr={shuttleOrderNbr}&itemNbr={itemNbr}&shuttleQty={shuttleQty}	Create Shuttle
GET api/distribution/bridgeshuttle?shuttleOrderNbr={shuttleOrderNbr}	Bridge Shuttle Order
GET api/distribution/cancelshuttleorder?shuttleOrderNbr={shuttleOrderNbr}	Cancel Shuttle Order
GET api/distribution/listDistributionUser	Return List of distrubution Users.
POST api/distribution/upsertDistributionUser	upsert Distribution users.
GET api/distribution/deleteDistributionUser?userID={userID}	Delete Distribution user
GET api/distribution/getDistributionDefault?deptID={deptID}&reasonID={reasonID}	Fetch all Default distribution.
GET api/distribution/listDistributionDefault	Return List of default distribution.
POST api/distribution/upsertDistributionDefault	Upsert default Distribution.
GET api/distribution/listAutoDistroExclusionItem	retrieve Auto Distro Exclusion list on Distribution Admin page. The list includes items that wont be used for Auto distribution
POST api/distribution/insertAutoDistroExclusionItem	Service to insert a list of items to Auto Distribution Exclusion list
POST api/distribution/deleteItemFromAutoDistroExclusionList	Service to delete a single item from Auto Distribution Exclusion list
POST api/distribution/getcalculateddistribution2	Calculates a distro
POST api/distribution/modifyCalculatedDistribution	Modify a distro
GET api/distribution/itemwhseheader?itemNbr={itemNbr}&reasonID={reasonID}	Retreives item headser info and warehouse info
GET api/distribution/pendingdistribution?itemNbr={itemNbr}	Retrieves distributions that have been started by a user and not yet completed/cancelled
GET api/distribution/existingdistribution?itemNbr={itemNbr}	Checks to see if there is a exsiting distribution (including legacy), returns back dynamic response
GET api/distribution/showitemhistory?stores={stores}&itemNbr={itemNbr}&startDate={startDate}&endDate={endDate}	Retrieves item history
POST api/uLookups/getestimatedstoreinventory	Post Request to Get Estimated Store Inventory
GET api/distribution/pricechanges?itemNbr={itemNbr}	Retrieves a list of price changes for an item
GET api/distribution/existingdistributions?classNbr[0]={classNbr[0]}&classNbr[1]={classNbr[1]}&itemNbr={itemNbr}&Dept={Dept}&subClassNbr={subClassNbr}
POST api/distribution/existingdistributionsPaginated
GET api/distribution/getuserdept?userName={userName}	Given a username, retrieves the users department to be used in filteing data
GET api/distribution/getdeptdefaults?Dept={Dept}&reasonId={reasonId}	retreieves a list of department defaults for a given department and reason ID
GET api/distribution/getsearchgroups?searchText={searchText}	Retrieves list of stores and groups based on search text
POST api/distribution/getstoresfromgroups	Returns back a list of stores from a given list of groups and/or stores selected
POST api/distribution/startdistro?userName={userName}&isShuttle={isShuttle}	No documentation available.
PUT api/distribution/putpendingdistro?userName={userName}&whseNbr[0]={whseNbr[0]}&whseNbr[1]={whseNbr[1]}&itemNbr={itemNbr}&reasonId={reasonId}&isShuttle={isShuttle}	Allows user to post data to Pending_Distribution_Id table
GET api/distribution/getpendingdistroforuser?userName={userName}&isShuttle={isShuttle}	Fetch all pending distribution for user
GET api/distribution/getnextpendingdistro?userName={userName}&isShuttle={isShuttle}	Fetch Next pending distribution for user
GET api/distribution/itemfirstshippeddate?itemNbr={itemNbr}	Return First Sales date for item
POST api/distribution/cancelallpendingdistros?userName={userName}&isShuttle={isShuttle}	Removes all pending distributions from PENDING_DISTRIBUTION_ID
DELETE api/Distribution?userName={userName}&itemNbr={itemNbr}	No documentation available.
POST api/Distribution?distroItemNbr={distroItemNbr}&effectiveDate={effectiveDate}&requestID={requestID}
POST api/Distribution?itemNbr={itemNbr}	No documentation available.
POST api/Distribution?storeNbr={storeNbr}	No documentation available.
GET api/Distribution?itemNbr={itemNbr}&distType={distType}&calcWeeks={calcWeeks}	Distrbution calculations.
POST api/Distribution?itemNbr={itemNbr}&whseNbr={whseNbr}	Returns the available quantity
GET api/Distribution?distroID={distroID}&storeNbr={storeNbr}&whseNbr={whseNbr}	This method is used to fetch all list of distribution Maintance quantity.
POST api/Distribution?distributionID={distributionID}	This method is used to update the order
POST api/Distribution?distributionID={distributionID}&changeQty={changeQty}	This method is used to update the distribution quantity in SQL

ParentChildItemMaintenance

API	Description
POST api/fog/insertParentChildItems	Inserting Parent and child items in db2 table SANDRA_CC.ITEMCHDP.
GET api/fog/getParentChildItems	Get all Parent and chlid items
GET api/fog/deleteParentChildItemRecords	No documentation available.
GET api/fog/deleteParentItem?parentItem={parentItem}	Removing Parent and associated Child Items
POST api/fog/updateParentChildItems
POST api/fog/getValidateUploadedParentChildItemslst	Check Validated List from the Uploaded CVS file.
POST api/fog/overrideParentChildItemslst	override Parent Child Items list from the Uploaded CVS file.
POST api/fog/appendParentChildItemslst	Append Parent Child Items list from the Uploaded CVS file.

ItemPhoto

Image Management

API	Description
GET api/productImageManagement/getUpcPhotoByUpc?upc={upc}	get active UPC_PHOTO record or as400 UpcImage record and s3 image link
POST api/productImageManagement/SaveWarehouseImage	saved photo taken at warehoust to s3
GET api/productImageManagement/getPoHeader?poNum={poNum}	Get buyer num and buyer name form stored proc
GET api/productImageManagement/listphotos?status={status}	Retrieve image app photos based on status
POST api/productImageManagement/listMissingPhotos	Listing missing photos
GET api/productImageManagement/reassignUpcPhoto?upcPhotoID={upcPhotoID}&buyerNbr={buyerNbr}&buyerName={buyerName}&usr={usr}&photoUrl={photoUrl}	Reassigns upc_photo to a new buyer number and sends email
GET api/productImageManagement/rejectUpcPhoto?upcPhotoID={upcPhotoID}&usr={usr}&upcCode={upcCode}&rejectedReasonID={rejectedReasonID}&otherReason={otherReason}	sets the status of upc_photo to rejected and removes from s3
GET api/productImageManagement/getUpcPhotoByGuid?id={id}	get active UPC_PHOTO record, buyer info and s3 image link for header
GET api/productImageManagement/getItemsWithQohForUpc?Upc={Upc}	get item info from as400
GET api/productImageManagement/removeItemToUpcLinkWrapper?upc={upc}&itemNbr={itemNbr}	Remove Item to UPC Link Wrapper
GET api/productImageManagement/listBuyers	List Buyers
GET api/productImageManagement/getItem?itemNbr={itemNbr}	Get Item details by Item number
GET api/productImageManagement/getProduct?upc={upc}	Get Product by UPC
GET api/productImageManagement/getNewItemAlertsBuyerApproval?upc={upc}	Get item alerts by Buyer approval
POST api/productImageManagement/submitVerifyProductInfo	Submit VerifyProduct Info
GET api/productImageManagement/updateUpcPhotoItemNbr?upcCode={upcCode}&poNum={poNum}&username={username}&itemNbr={itemNbr}&buyerNbr={buyerNbr}	Update Upc Photo ItemNbr
GET api/productImageManagement/getPoNumByUpc?upc={upc}	Lookup PO by Upc
GET api/productImageManagement/getPoNumByItemNbr?itemNbr={itemNbr}	Lookup PO by ItemNbr
GET api/productImageManagement/getItemsForAPoFromAs400?poNumber={poNumber}	Get Items for a PO from AS400
GET api/productImageManagement/listRejectedReason	List Rejected Reason
GET api/productImageManagement/getPurchaseOrdersForUpcfromAs400?upc={upc}	Lookup PO by Upc
GET api/productImageManagement/getPurchaseOrdersForItemNbrfromAs400?itemNbr={itemNbr}	Lookup PO by Upc
GET api/productImageManagement/cleanUpcCheckDigit?upc={upc}	Remove Upc Check Digit input 14 char string output 14 char string
GET api/ItemPhoto?upc={upc}	Get Items by UPC from AS400
POST api/ItemPhoto?key={key}	Checking File is Exist in S3 bucket
GET api/ItemPhoto?itemList={itemList}	Get Item List

NightJob

API	Description
GET api/nightjob/InitiateNightJob	No documentation available.
GET api/nightjob/expiredistro	Expire Distro
GET api/nightjob/deletependingdistro	Expire Distro
GET api/nightjob/autoapprovepink	Expire Distro
GET api/nightjob/insertDefaultRoleAndFilters	insert default role and filters
GET api/nightjob/updateWeicntrl?inputDate={inputDate}	Update WEICNTRL table
GET api/nightjob/loadItemRosDaysSelling	Load ITEM_ROS_DAYSSELLING as400 table
GET api/nightjob/loadDateCodeSummary	Load DATE_CODE_SUMMARY as400 table
GET api/nightjob/deleteOneTimeUseWindows	Delete One Time Use windows
GET api/nightjob/updateStoreGeo	UpdateStoreGeo
GET api/nightjob/checkDSDAccuracy	Method to run at night and check for created bidsheet accuracy between GoApps DSD table data and AS400 table

NAOG

Used for covering new NAOG changes

API	Description
GET api/NAOG/getNewArrivalOGItems?storeNbr={storeNbr}
POST api/NAOG/SyncNAOGItems	Get new list of items for refreshing the NAOG list in UI
POST api/NAOG/CheckForNAOGItems	Check if any new Items are available as part of auto-refresh check
POST api/NAOG/ItemDetailRefresh	Retrieves the latest QtyAvailable and QtyReserved for item in NAOG when an item description is clicked from the UI
GET api/NAOG/getNewArrivalOGItemsExpiredAndReleased?storeNbr={storeNbr}	Fetch NAOG expired and released items
GET api/NAOG/getDeptTotals?storeNbr={storeNbr}	No documentation available.

uLookups

API	Description
GET api/uLookups/list/warehouse	Warehouse List
GET api/uLookups/list/whseordertypes	Warehouse List Order Type Combinations
GET api/uLookups/getOrderingWwarehouses	get ordering warehouses
GET api/uLookups/getallwarehouses	Get Warehouses By Item Number
GET api/uLookups/warehouses?itemNbr={itemNbr}	Get Warehouses By Item Number
GET api/uLookups/warehousedestination?whse={whse}	Get Warehouses By Item Number
GET api/uLookups/buyers?app={app}	Service to retrieve the buyers information
GET api/uLookups/getbuyerbyname?buyerName={buyerName}	Retrieve the buyer information by buyer name
GET api/uLookups/searchvendors?search={search}&isSearch={isSearch}	Get the vendors details
GET api/uLookups/israndweight?itemNbr={itemNbr}&storeNbr={storeNbr}	Check if the item has random weight or not
GET api/uLookups/departments	Get all departments
GET api/uLookups/detplabel?subclass={subclass}&itemclass={itemclass}	Get department details by class and subclass
GET api/uLookups/itemclass/{Dept}?orderBy={orderBy}	Get class details
GET api/uLookups/itemsubclass?classNbr[0]={classNbr[0]}&classNbr[1]={classNbr[1]}&orderBy={orderBy}	Get sub class details
GET api/uLookups/itemclassbyitemnbr?itemNbr={itemNbr}	Looks up class by item number
GET api/uLookups/listActiveDirectoryUsers?ouGroup={ouGroup}	Warehouse List
GET api/uLookups/item?searchText={searchText}&take={take}&pink={pink}&storeNbr={storeNbr}	Get item details by searchtext, pink flag and stroe number
GET api/uLookups/getitem?itemNbr={itemNbr}	Retrieve item details by item number
GET api/uLookups/searchItem2?searchText={searchText}
GET api/uLookups/listDistinctStatesForStores	Return Store Information based on Store Number provided. Store information returns Store Number, Store Name, and Operator Master Email, Store State.
GET api/uLookups/GetStoreInfo?storeNbr={storeNbr}	Return Store Information based on Store Number provided. Store information returns Store Number, Store Name, and Operator Master Email, Store State.
GET api/uLookups/getStores?ExcludeClosed={ExcludeClosed}&ExcludeUnopened={ExcludeUnopened}	This will return a list of all stores. Parameters will limit which stores are returned.
GET api/uLookups/GetStoreInfoFromEmail?email={email}	Return Store Information based on email from login
GET api/uLookups/GetStoreInfoFromDB2	This will get the store list from db2, this is used on the store directory page (service now)
GET api/uLookups/GetWarehouseInfo?whseNbr={whseNbr}&storeNbr={storeNbr}	No documentation available.
GET api/uLookups/GetOrderTypeInfo?whseNbr={whseNbr}	Return order type Information based on Warehouse Number provided.
GET api/uLookups/itemqtyonhand?itemNbr={itemNbr}	Lookup QtyAvailable by ItemNbr - Sum of Warehouses
GET api/ulookups/getcontributionpercent?itemNbr={itemNbr}&whse={whse}	Gets contribution pct for suggested shuttle qty
GET api/ulookups/getsuggestedshuttleqty?itemNbr={itemNbr}&originWhse={originWhse}&destinationWhse={destinationWhse}&contributionPct={contributionPct}	Gets contribution pct for suggested shuttle qty
GET api/ulookups/casesetopalletconversion?itemNbr={itemNbr}&originWhse={originWhse}	Gets contribution pct for suggested shuttle qty
GET api/uLookups/getitemupc?itemNbr={itemNbr}&storeNbr={storeNbr}	Get UPC from ItemNbr + StoreNbr combination
GET api/uLookups/listStoreOrderFilters?storeNbr={storeNbr}	Return order type Information based on Warehouse Number provided.
GET api/uLookups/uom	Get UOM list from LOOKUP_UOM
GET api/uLookups/getStoreOrderTypes	Get the store order types from lookup
GET api/checkEFLicense	Check entity model license
GET api/uLookups/list/storeFinancialAttributeStoreType	Warehouse List
GET api/uLookups/list/imageIssueReasons	Get image reason details
GET api/uLookups/getStorePortalUserSettings?userEmail={userEmail}	No documentation available.
GET api/uLookups/GetStates	get States
POST api/uLookups?searchText={searchText}&take={take}	Replace part of url string with space and return new url string
POST api/uLookups?searchText={searchText}&isPink={isPink}	Get the items list by search text
POST api/uLookups?storeNbr={storeNbr}	Method to get the pink details by store and item numbers
POST api/uLookups?storeNumber={storeNumber}	Method to check is yellow item or not by item number

VarMinShip

API	Description
GET api/varMinShip/getMinShipDtls	No documentation available.
GET api/varMinShip/getAllDepts	No documentation available.
GET api/varMinShip/delMinShipExceptionDtls?DeptCode={DeptCode}&WhseNbr={WhseNbr}	No documentation available.
POST api/varMinShip/insertOrUpdateException	No documentation available.

CameraUpload

API	Description
POST api/POC/PostCameraImage	No documentation available.
POST api/POC/PostImage	No documentation available.

StoreFinancialInput

API	Description
GET api/iofinancial/getMstrDashboardLink?storeNbr={storeNbr}	Gets Microstrategy Dashboard Link by env
GET api/iofinancial/listSubmitQuestions?storeNbr={storeNbr}	Submit the list of questions by store
GET api/iofinancial/listStoreFinancialValues?storeNbr={storeNbr}	Retrieve list of values for a store previous 3 months (unless an operator has taken over a store within those three months, this it'll be the start date month) financial values.
GET api/iofinancial/listFinancialFields	Retrieve list of values for a store previous 3 months (unless an operator has taken over a store within those three months, this it'll be the start date month) financial values.
POST api/iofinancial/upsertFinancialValues	Retrieve list of values for a store previous 3 months (unless an operator has taken over a store within those three months, this it'll be the start date month) financial values.
POST api/iofinancial/submitFinancialMonthStatus	Submit iofinancial for store.
GET api/iofinancial/listFinancialValuesMSTR?storeNbr={storeNbr}	Retrieve list of values for a store previous 3 months financial data. Data is provided from Microstrategy.
GET api/iofinancial/listStoreIOFinancialDraftMonths?storeNbr={storeNbr}&year={year}&month={month}	Retrieve the list of store draft months based on store, year and month
GET api/iofinancial/checkGrossProfitPassword?storeNbr={storeNbr}&pw={pw}	Validate the store gross profit password
POST api/iofinancial/sendmailtofinance	Service to send an email to finance if a store has a question regarding Store Financial Input
GET api/iofinancial/insertNullStoreStatusData	insert Status Data for store with no records
GET api/iofinancial/sendNotSubmittedEmailReminderToOperatorTcapStore?overrideEmail={overrideEmail}	DEPRCATED: for TCAP stores, To be run on the 1st of very month
GET api/iofinancial/sendNotSubmittedEmailReminderToOperator?overrideEmail={overrideEmail}	To be run on the 16th of very month
GET api/iofinancial/SendOneDayLateReminderToStandardStore?overrideEmail={overrideEmail}	for Standard stores, To be run on the 16st of very month
GET api/iofinancial/SendTestEmail?overrideEmail={overrideEmail}	for tesing email server
GET api/iofinancial/SendOneWeekLateReminderToStandardStore?overrideEmail={overrideEmail}	for Stadard stores, To be run on the 23rd of very month
GET api/iofinancial/SendOneDayLateReminderToTcapStore?overrideEmail={overrideEmail}	for TCAP stores, To be run on the 1st of very month
GET api/iofinancial/SendOneWeekLateReminderToTcapStore?overrideEmail={overrideEmail}	for TCAP stores, To be run on the 8th of very month
POST api/iofinancial/uploadIOFinance	Update/Insert uploadIOFinance file.
POST api/StoreFinancialInput?storeNbr={storeNbr}&month={month}&year={year}&isSubmit={isSubmit}&inputDT={inputDT}	Insert/update the store financial month status (IO_FINANCIAL_STORE_MONTH_STATUS)
POST api/StoreFinancialInput	Method to send financial report of the stores.
GET api/StoreFinancialInput	Get delay or late email details of the store

MinShipAdmin

MinShipAdmin Controller

API	Description
GET api/MinShipAdmin/GetMinShipDepartment	Get departments from DEPARTMENT table and displaying Department exclusion
POST api/MinShipAdmin/SaveMinShipDepartments	Saving Department exclusions in Department table
GET api/MinShipAdmin/getItemsBySearch?searchText={searchText}	retrieving all Items as per searched criteria
POST api/MinShipAdmin/addNewItemExclusion	Adding item exclusion in MINMAX_ITEM table.
GET api/MinShipAdmin/GetMinShipItemExclusions	Get all Item Exclusions from MINMAX_ITEM table.
GET api/MinShipAdmin/DeleteItemExclusion?ID={ID}	Delete an Item Exclusion in MINMAX_ITEM table as per given exclusion Id
POST api/MinShipAdmin/insClassSubClass	Insert Class SubClass MinMax values.
POST api/MinShipAdmin/updateClassSubClass	Insert Class SubClass MinMax values in MINMAX_CLASS_SUBCLASS table.
GET api/MinShipAdmin/getMinShipClsSubCls	Get list of Class SubClass MinMax values.
GET api/MinShipAdmin/delClsSubclsItem?ID={ID}	Delete Class SubClass MinMax values in MINMAX_CLASS_SUBCLASS table.
GET api/MinShipAdmin/getAllItems?itemNumbers={itemNumbers}	Get all existing items by given item numbers
POST api/MinShipAdmin/uploadMinMaxItems	Bulk insert/update of the uploaded items
GET api/MinShipAdmin/getWarehousesNaogCubeLimit?whseNbr={whseNbr}	Get NAOG Cube Limit for all warehouses
POST api/MinShipAdmin/updateWarehousesNaogCubeLimit	Save NAOG reserve limit
GET api/MinShipAdmin	Get Item Desc by ItemNbr.

ReceivingAndJournals

API	Description
GET api/bbicReports/GetExpMaintList?StoreNbr={StoreNbr}
GET api/bbicReports/GetRecentBatches?StartNumber={StartNumber}&Count={Count}&StoreNbr={StoreNbr}
GET api/bbicReports/GetReceivingItemsExtStrict?DocNum={DocNum}&Date={Date}&Type={Type}&StoreNbr={StoreNbr}
GET api/bbicReports/GetReceivingItemsByReportType?DocNum={DocNum}&Date={Date}&Type={Type}&TypeReport={TypeReport}&StoreNbr={StoreNbr}&isIssueReport={isIssueReport}&IssueTypeReport={IssueTypeReport}
POST api/bbicReports/GetReceivingItemsExtStrictReport?DocNum={DocNum}&Date={Date}&Type={Type}&TypeReport={TypeReport}&StoreNbr={StoreNbr}&isIssueReport={isIssueReport}&IssueTypeReport={IssueTypeReport}
GET api/bbicReports/GetPriceChangeDocsReport?StoreNbr={StoreNbr}&ShowOnlyAvailable={ShowOnlyAvailable}
GET api/bbicReports/GetThrowAwayDocs?QtyBack={QtyBack}&StoreNbr={StoreNbr}
GET api/bbicReports/GetThrowAways?DocNum={DocNum}&StartNumber={StartNumber}&Count={Count}&Sent={Sent}&StoreNbr={StoreNbr}
GET api/bbicReports/GetMarkDownDocs?QtyBack={QtyBack}&StoreNbr={StoreNbr}
GET api/bbicReports/GetMarkDowns?DocNum={DocNum}&StartNumber={StartNumber}&Count={Count}&Sent={Sent}&StoreNbr={StoreNbr}
GET api/bbicReports/GetPOVendors?StoreNbr={StoreNbr}
GET api/bbicReports/GetOpenPODocs?VendorNum={VendorNum}&StoreNbr={StoreNbr}
GET api/bbicReports/HasSentPOs?VendorNum={VendorNum}&StoreNbr={StoreNbr}
GET api/bbicReports/GetPODocs?DateBack={DateBack}&vendorNum={vendorNum}&StoreNbr={StoreNbr}
GET api/bbicReports/GetThrowAwayStatus?StoreNbr={StoreNbr}
GET api/bbicReports/GetMarkDownStatus?StoreNbr={StoreNbr}&dateEffective={dateEffective}
GET api/bbicReports/SubmitPriceChanges?DocNum={DocNum}&StoreNbr={StoreNbr}
GET api/bbicReports/SendThrowAways?EffDate={EffDate}&StoreNbr={StoreNbr}&SendMail={SendMail}
GET api/bbicReports/SubmitMarkDowns?EffDate={EffDate}&StoreNbr={StoreNbr}
GET api/bbicReports/DeletePOInvoice?InvoiceNum={InvoiceNum}&StoreNbr={StoreNbr}
POST api/bbicReports/PutDSDItems?StoreNbr={StoreNbr}
POST api/bbicReports/PriceChangeReport?DocNum={DocNum}&StoreNbr={StoreNbr}
POST api/bbicReports/ViewThrowAwayReport?DocNum={DocNum}&StartNumber={StartNumber}&Count={Count}&Sent={Sent}&StoreNbr={StoreNbr}
POST api/bbicReports/ViewMarkDownReport?DocNum={DocNum}&StartNumber={StartNumber}&Count={Count}&Sent={Sent}&StoreNbr={StoreNbr}
POST api/bbicReports/GetPOReportItemsPDF?DocNum={DocNum}&VendorNum={VendorNum}&DelDate={DelDate}&InvoiceNum={InvoiceNum}&StoreNbr={StoreNbr}
POST api/bbicReports/GetSentPOReportItemsPDF?PONum={PONum}&VendorNum={VendorNum}&StoreNbr={StoreNbr}
GET api/bbicReports/JournalProgramTypes?StoreNbr={StoreNbr}
POST api/bbicReports/JournalHistoryLong
GET api/bbicReports/ShelfAudits?StoreNbr={StoreNbr}
GET api/bbicReports/ShelfAuditItems?AuditName={AuditName}&StoreNbr={StoreNbr}
POST api/bbicAuthentication/ValidateUser	No documentation available.
GET api/bbicReports/CheckUserId?UserID={UserID}&storeNbr={storeNbr}	No documentation available.
GET api/bbicReports/GetAllUserRoles	No documentation available.
GET api/bbicReports/GetAllUsersForStore?StoreNbr={StoreNbr}	No documentation available.
GET api/bbicReports/GetUserDetails?UserID={UserID}&StoreNbr={StoreNbr}	No documentation available.
GET api/bbicReports/RemoveUser?UserID={UserID}&StoreNbr={StoreNbr}	No documentation available.
POST api/bbicReports/UpdateUser	No documentation available.
GET api/bbicReports/GetLocMaintList?StoreNbr={StoreNbr}	No documentation available.
GET api/bbicReports/DeleteLocation?Id={Id}&LogId={LogId}&StoreNbr={StoreNbr}	No documentation available.
POST api/bbicReports/UpdateLocationStatus	No documentation available.
POST api/bbicReports/CreateLocation?LocationName={LocationName}&StoreNbr={StoreNbr}	No documentation available.
GET api/ReceivingAndJournals?strpath={strpath}	No documentation available.

Reports

API	Description
GET api/reports/getStoreExpirationReportItems?storeNbr={storeNbr}
POST api/reports/upsertExpiryDateChange
GET api/reports/getExpiryItemMultipleUpc?itemNbr={itemNbr}&storeNbr={storeNbr}	Get all the available UPC for the item
GET api/reports/getExpiryExclusionItemList	Get Exclusion Item List for Expiry report. These are items that will not be included in Expiry Action List for store.
POST api/reports/upsertExpiryExclusionItem	Upsert new Item to Exclusion Item List-updates the database. This item will not be included in Expiry Action List
POST api/reports/deleteExpiryExclusionItem	Delete item from Exclusion Item list. Deleted Item will be displayed again in Expiry Action List

Tools

API	Description
GET api/qatools/resetWowAlerts?storeNbr={storeNbr}	ResetWowAlerts
GET api/qaTools/sendTestEmail?mail={mail}	No documentation available.
GET api/qaTools/getUsernameList?searchText={searchText}	Get Users List
POST api/qaTools/impersonateUser

CacheManagement

API	Description
POST api/cacheManagement/clearAll	clear all the keys in the cache

TransferDetail

API	Description
GET api/WWO/GetTransferDetails?StoreNbr={StoreNbr}&InvNbr={InvNbr}	Retrieve Transfer Details.

ManageOrderWindows

API	Description
GET api/rto/PreOrderWH?StoreNbr={StoreNbr}	Get preorder warehouse details by store
GET api/rto/OldOrder?StoreNbr={StoreNbr}	Get the old order item details by store
GET api/rto/OldInvoice?StoreNbr={StoreNbr}	Get old invoice details by store
GET api/rto/getstoreorderwindow?sowId={sowId}	This service returns a list of Store Order Windows for display on the Manage Store Order Windows App
POST api/rto/liststoreorderwindows	This service returns a list of Store Order Windows for display on the Manage Store Order Windows App
GET api/rto/getallordertypes	Get All Order Types for UOG
POST api/rto/getStoreOrderWindowAssociatedWarehouse	Returns Associated Warehouses from a whseNbr
GET api/rto/GetAllWarehouseList	Get all available ware houses
GET api/rto/getordertypebystore?storeNum={storeNum}	Returns all order types, whses, order type descriptions for a store
GET api/rto/getwhsebystoretype?storeType={storeType}	Returns all warehouses available for store type
GET api/rto/deletestoreorderwindow?sowId={sowId}&updatedBy={updatedBy}	Delete Store Order Window from Manage Order Windows
POST api/rto/updatestoreorderwindow	Update record in Store Order Window Table
POST api/rto/insertstoreorderwindow	Update record in Store Order Window Table
POST api/rto/uploadOrderWindowsFile	Service to process the uploaded the order window csv file
GET api/rto/getSubmittedOrderBySowID?sowId={sowId}&storeNbr={storeNbr}	This service returns a list of Store Order Windows for display on the Manage Store Order Windows App

OSAllowance

API	Description
GET api/OSAllowance/getOSAllowanceReport?WhseNbr={WhseNbr}&EffectiveDate={EffectiveDate}	Retrieve the list of OS allowance percentage for selected whse and list everything less than effective date selected. Distinct on department to display only 1 latest record
POST api/osallowance/submitPercentChanges	Save changes for percent update using the department selected, percent,whseNbr,log User name updated by and selected effective date.

OrderGuideBlinding

API	Description
GET api/rto/getDeptbyClassNbr?ClassNbr={ClassNbr}	Fetch all departments from AS400 by ClassNbr.
GET api/rto/GetListOrderGuideBlinding?isActive={isActive}	Fetch all Blinding Items.
POST api/rto/insertOrUpdateOrderBlinding	Insert Or Update the record in table STORE_ORDER_GUIDE_BLINDING_ITEMS.
GET api/rto/deleteOrderGuideBlindingByID?ID={ID}	Delete Blinding exception from table STORE_ORDER_GUIDE_BLINDING_ITEMS by ID
GET api/rto/getAllItems?searchText={searchText}	Fetch all Blinding Item by search element
POST api/rto/insertBulkOrderBlinding	Bulk Insert of Blinding Item in database table STORE_ORDER_GUIDE_BLINDING_ITEMS
POST api/rto/getValidateUploadedlst	Check Validated List from the Uploaded CVS file.
GET api/rto/getsearchgroups?searchText={searchText}	Retrieves list of stores and groups based on search text
GET api/OrderGuideBlinding	Get Item Desc by ItemNbr.
GET api/OrderGuideBlinding?ExcludeClosed={ExcludeClosed}&ExcludeUnopened={ExcludeUnopened}	Fetch all Stores which are not closed and opened.

PreorderDetail

API	Description
GET api/WWO/GetPreorderDetail?StoreNbr={StoreNbr}&WH={WH}	Retrieve all PreOrder Details

Error

API	Description
GET api/error/listErrors?dateForLookup={dateForLookup}	Service to retrieve the error list
GET api/Error?path={path}	Catch 404 HttpStatusCode and present 404 response, In addition, log to Elmah
POST api/Error?path={path}	Catch 404 HttpStatusCode and present 404 response, In addition, log to Elmah
PUT api/Error?path={path}	Catch 404 HttpStatusCode and present 404 response, In addition, log to Elmah
DELETE api/Error?path={path}	Catch 404 HttpStatusCode and present 404 response, In addition, log to Elmah
OPTIONS api/Error?path={path}	Catch 404 HttpStatusCode and present 404 response, In addition, log to Elmah
GET api/{path}	Catch 404 HttpStatusCode and present 404 response, In addition, log to Elmah
POST api/{path}	Catch 404 HttpStatusCode and present 404 response, In addition, log to Elmah
PUT api/{path}	Catch 404 HttpStatusCode and present 404 response, In addition, log to Elmah
DELETE api/{path}	Catch 404 HttpStatusCode and present 404 response, In addition, log to Elmah
OPTIONS api/{path}	Catch 404 HttpStatusCode and present 404 response, In addition, log to Elmah

DistributionUpload

API	Description
POST api/distribution/uploadDistroFile	No documentation available.

BbicHandheld

API	Description
GET api/fog/listPODocsHH?storeNbr={storeNbr}&vendorNbr={vendorNbr}&dateBack={dateBack}	list PO Docs for the HH
GET api/fog/updateDsdStoreOrderDetail?upc={upc}&itemNbr={itemNbr}&orderNbr={orderNbr}&qtyRec={qtyRec}&storeNbr={storeNbr}&userID={userID}	updateDsdStoreOrderDetail
GET api/fog/getRunningUnits?storeNbr={storeNbr}&vendorNbr={vendorNbr}&orderNbr={orderNbr}&invoiceNbr={invoiceNbr}	getRunningUnits
GET api/fog/getRunningTotal?storeNbr={storeNbr}&vendorNbr={vendorNbr}&orderNbr={orderNbr}&invoiceNbr={invoiceNbr}	getRunningTotal
GET api/fog/listOpenDsdStoreOrderHeaders?storeNbr={storeNbr}&vendorNbr={vendorNbr}	list Dsd Store Order Headers
GET api/fog/getSingleDsdItem?storeNbr={storeNbr}&orderNbr={orderNbr}&upc={upc}&poNbr={poNbr}&delDate={delDate}&invoiceNbr={invoiceNbr}	get Single Dsd Item
GET api/fog/listPOReportItems?orderNbr={orderNbr}&vendorNbr={vendorNbr}&delDate={delDate}&invoiceNbr={invoiceNbr}&storeNbr={storeNbr}
GET api/fog/getDsdStoreOrderHeader?storeNbr={storeNbr}&vendorNbr={vendorNbr}&delDate={delDate}&invoiceNbr={invoiceNbr}	get Dsd Store Order Header - creates new record if does not exist returns record
POST api/fog/submitDsdPoInvoice	send selected invoice to submit PO
POST api/fog/deleteDsdPoInvoice	passing in Invoice nbr and store nbr to set record as deleted in DSD_STORE_ORDER_HEADER table
GET api/fog/getDsdHandheldReceivingVendors?storeNbr={storeNbr}	get Dsd Handheld vendors with items having valid dates

Email

Email Management

API	Description
POST api/Email?UPC={UPC}&buyerNbr={buyerNbr}&upcPhotoID={upcPhotoID}&imgPath={imgPath}	This method will take a buyer number and send an email to them and thier assistents that there is a pending image needing thier approval.

InsertItemsToDB2

API	Description
POST api/InsertItemsToDB2?vendorNbr={vendorNbr}	No documentation available.
POST api/InsertItemsToDB2?batchId={batchId}	No documentation available.