Our NFL Fantsy Football League has been running since 2013 and used MyFantasyLeague to run it, however my husband did not like the draft system so I built a custom draft application in Excel. As my Salesforce career grew, I took on a project to build it in Salesforce and this is my latest version of the application.

It uses MyFantasyLeague APIs to retrieve the NFL teams, all the players and the fantasy franchises and load them in to records. Then after the draft is finished you can then upload the results back into MyFantasyLeague.

There are two community pages that are used to host the draft.

The home page of the community is a publically available site that anybody can view - meaning that as well as sharing the draft board in the room, anyone who joins remotely can easily view the draft as it happens on any device.

The commissioner page is only available if you are logged into the community as a user and allows the commissioner to run the draft by selecting the players - or undoing picks if required - and uoploading the draft when finished.

Assign whomever needs it the Commissioner permission set, which should give accesss to everything required to set up and run the league.

• Api Key This can be found by logging into your MFL league, opening the HELP menu and opening the DEVELOPER'S API page
• Generic URL (can be preset) This will always be https://api.myfantasyleague.com
• Instance URL This can be found by visiting your league on MFL and copying the main part of the URL, it will be something like https://www47.myfantasyleague.com
• League Id Your league id can be found by visiting the homepage of your league, the id is after the final slash, nit including the # or anything after it, if there is one
• MFL User Id This is found by using the login API. This will be deprecated and will dynamically get the MFL_User_Id by calling the login api in the code and setting it
• Year Manually set this to the year of the current league

First, create a Connected App, then populate the custom settings as below: [//]: # (//TODO: Explain how to xreate the connected app)

• Username Your Salesforce username
• Password Your Salesforce password, followed by your security token
• Client Id The client id from the connected app created above
• Client Secret The client secret from the connected app created above
• Url This should always be set to: https://login.salesforce.com/services/oauth2/token
• Grant Type This should always be set to: password

Digital Experiences -> Settings Enable Digital Experiences and Save Sites -> New -> Build Your Own(Aura) -> Get Started [//]: # (Note: cometd for events won't work in LWR and would require a custom loadscript. //TODO: Consider custom script for future improvemnet/development) Name -> choose a name for your site URL (optional) -> enter any additional url for your site This takes a few minutes Builder -> Select/Create a page to show the draft board -> Components -> Drag the custom component to the main content section Select/Create a page to show the commissioner console -> Components -> Drag the custom component to the main content section

Allow CSP Trusted Sites

Publish Site

Give access to:

• Apex Classes
  • CometdController
  • ManageDraft MFLManageOwners
• Custom Objects (All Fields)
  • NFL Teams
  • Picks
  • Players
  • Team Owners

Create sharing rules to give access to all records for:

• NFL Teams
• Players
• Team Owners

Coming soon...