Best Buy Schedule and VID Integration

Best Buy Schedule

BDS currently has access to one Best Buy API:

https://sts-ext-cld.bestbuy.com/gw/vendor-workforce/external/programs - API used to create scheduled shifts

API Schedule Data

Windows app - running on the schedule below to pull schedule data from IC and transmit it to Best Buy using their API.

1. Programs need to be setup in the Best Buy Program screen and call form associated
2. Looks at the Program list. Currently looks for Demo and Sales tactics only.
3. Looks for the call forms per program
4. Creates a list of Scheduled appointments for each of the call forms
5. Formats the appointments in json format supplied by Best Buy
6. Sends the json to Best Buy via api

Schedule

Run 1

See below processes run first to get VIDs since the VIDs are needed in this process to send data to Best Buy.

11:00 AM PST - run the to windows app to API the scheduled data to Best Buy

Run 2

See below processes run first to get VIDs since the VIDs are needed in this process to send data to Best Buy.
9:00 PM PST - run the to windows app to API the scheduled data to Best Buy

Best Buy VID

VIDs or Visitor Identification

VIDs are unique usernames given to each BDS employee used to login to their Best Buy apps and transmit data.

Best Buy did not supply a API to pull the VIDs for each BDS employee setup with one.
BDS needs the VID associated with each of their employee's in IC to send schedule (shift) information to Best Buy using their API.
BDS created a business process automation to serve as a temporary fix to manually downloading the VID file from a Best Buy website and updating the data in IC.

Schedule of the Processing Running:

Run 1

10:00 AM PST - run the report, run the power automate
10:30 AM PST - run the SSIS Job import/update vids
11:00 AM PST - run the to windows app to API the scheduled data to Best Buy

Run 2
8:00 PM PST - run the report, run the power automate
8:30 PM PST - run the SSIS Job import/update vids
9:00 PM PST - run the to windows app to API the scheduled data to Best Buy

The Best Buy integration consists of three processes:

Update VIDs
Several business process automations to move VIDs from Best Buys website to the IC database.
1. Selenium script runs on a Windows VM
  1. The script in a C# executable is running on a VM on the schedule listed above.
  2. The script logs into the Best Buy website under a security admin user account - https://access.bestbuy.com
  3. Clicks on the Generate Report link
  4. Chooses the Full User Export report choice and Submits it.
    The report is emailed to icfeedback@bdsmktg.com.
2. Microsoft Power Automate process
  1. The icFeedback Email box is monitored by the Microsoft Power Automate process
  2. The Power Automate process named Save VID List to SharePoint is triggered by an Email with User Export in the subject line from the Best Buy email address VendorIdentitySupport@bestbuy.com.
  3. The process renames the Excel attachment to BestBuyUserList.csv and moves the file to the Data Services SharePoint folder on the IT team.
3. SQL SSIS package
  1. The package picks up the BestBuyUserList.csv file from SharePoint folder
  2. Then Adds/Updates VIDs for Active users on the BestBuyUserList.csv in the Person Profile field Best Buy VID in IC.