fuegobudkush - draftkings

/**
* Returns draftking event information.
*
* @return {array} information.
* @customfunction
*/
function DRAFKING_MLB() {
  const url = `https://sportsbook.draftkings.com//sites/US-SB/api/v5/eventgroups/84240/categories/1031/subcategories/9884?format=json`
  const request = UrlFetchApp.fetch(url)
  const data = JSON.parse(request.getContentText())

  const offers = []
  const events = []

  data.eventGroup.events.forEach(event => {
    const eventInfo = {
      eventId: event.eventId,
      name: event.name,
      startDate: event.startDate,
      team1: event.teamName1,
      team2: event.teamName2,
      status: event.eventStatus.state
    }
    events.push(eventInfo)
  })

  const category = data.eventGroup.offerCategories.find(cat => cat.offerCategoryId == 1031)
  const subcategorie = category.offerSubcategoryDescriptors.find(sub => sub.subcategoryId == 9884)

  subcategorie.offerSubcategory.offers.forEach(mainOffer => {
    mainOffer.forEach(offer => {
      offer.outcomes.forEach(outcome => {
        const info = {
          ...events.find(e => e.eventId == offer.eventId),
          isSuspended: offer.isSuspended,
          isOpen: offer.isOpen,
          participant: outcome.participant,
          label: outcome.label,
          oddsAmerican: outcome.oddsAmerican,
          oddsDecimal: outcome.oddsDecimal,
          oddsDecimalDisplay: outcome.oddsDecimalDisplay,
          oddsFractional: outcome.oddsFractional
        }
        offers.push(info)
      })
    })
  })

  const toSheetsArray = offers.map(offer => Object.values(offer))
  toSheetsArray.unshift(Object.keys(offers[0]))

  return toSheetsArray

}