API

• POST /QUERY
  • QUERY_NAME
  • QUERY_PARAMS

List of Queries

• BASIC_QUERIES
  • LIST_GUILDS
    • Description
      • List Guilds ID's with Names and Description
  • LIST_USERS
    • Description
      • List User ID's with Names
    • Requires
      • GUILD_ID
  • LIST_USERS_WITH_ROLES
    • Description
      • List User ID's with Names and Roles
    • Requires
      • GUILD_ID
  • LIST_CHANNELS
    • Description
      • List Channels with Names and Description
    • Requires
      • GUILD_ID
• NUM_MESSAGES_....
  • NUM_MESSAGES_IN_GUILD
    • Requires
      • GUILD_ID
  • NUM_MESSAGES_PER_USER
    • Requires
      • GUILD_ID
  • NUM_MESSAGES_PER_CHANNEL
    • Requires
      • GUILD_ID
  • NUM_MESSAGES_FROM_USER_PER_CHANNEL
    • Description
      • Number of Messages user posted in each Channel
    • Requires
      • GUILD_ID
      • USER_ID
• LIST_CHANNELS...
  • LIST_CHANNELS_USER_POSTED_IN
    • Description:
      • Channels User Posed In
    • Requires
      • GUILD_ID
      • USER_ID
  • LIST_CHANNELS_BY_OLDEST_MESSAGE
    • Description
      • Requires
        • GUILD_ID
• LONGEST_MESSAGES_PER....
  • LONGEST_MESSAGES_PER_GUILD
    • Actually means total Total Message Count
  • LONGEST_MESSAGES_PER_USER
  • LONGEST_MESSAGES_PER_CHANNEL
    • Requires
      • GUILD_ID
  • LONGEST_MESSAGES_PER_USER_IN_CHANNEL
    • Requires
      • GUILD_ID
      • CHANNEL_ID
      • USER_ID
• GET_ORDERED_MESSAGES.....
  • GET_ORDERED_MESSAGES_FROM_GUILD
    • Requires
      • GUILD_ID
      • CHANNEL_ID
      • PAGE_NUM : INTEGER
    • Optional
      • BEFORE : DATETIME
      • After : DATETIME
      • ORDER : "ASC" or "DSC"
  • GET_MESSAGE_COUNT_FROM_CHANNEL
    • Requires
      • GUILD_ID
      • CHANNEL_ID
  • GET_ORDERED_MESSAGES_FROM_CHANNEL
    • Requires
      • GUILD_ID
      • CHANNEL_ID
      • PAGE_NUM : INTEGER
    • Optional
      • BEFORE : DATETIME
      • After : DATETIME
      • ORDER : "ASC" or "DSC"
  • GET_ORDERED_MESSAGES_FROM_USER
    • Requires
      • GUILD_ID
      • USER_ID
      • PAGE_NUM : INTEGER
    • Optional
      • BEFORE : DATETIME
      • After : DATETIME
      • ORDER : "ASC" or "DSC"
  • GET_ORDERED_MESSAGES_FROM_USER_IN_CHANNEL
    • Requires
      • GUILD_ID
      • USER_ID
      • PAGE_NUM : INTEGER
    • Optional
      • BEFORE : DATETIME
      • After : DATETIME
      • ORDER : "ASC" or "DSC"
  • Guild, User, Channel, User in Channel
• AVERAGE_MESSAGE_LENGTH....
  • AVERAGE_MESSAGE_LENGTH_PER_GUILD
  • AVERAGE_MESSAGE_LENGTH_FOR_USER
  • AVERAGE_MESSAGE_LENGTH_PER_USER
  • AVERAGE_MESSAGE_LENGTH_PER_CHANNEL
  • AVERAGE_MESSAGE_LENGTH_PER_USER_IN_CHANNEL
• SUM_OF_REACTIONS_....
  • SUM_OF_REACTIONS_PER_GUILD
  • SUM_OF_REACTIONS_TO_USER
  • SUM_OF_REACTIONS_TO_EACH_USER
  • SUM_OF_REACTIONS_PER_CHANNEL
  • SUM_OF_REACTIONS_TO_USER_IN_CHANNEL #TODO
• MOST_REACTED_TO_MESSAGES_SINGLE_EMOJI.... #TODO
  • MOST_REACTED_TO_MESSAGES_SINGLE_EMOJI_PER_GUILD
  • MOST_REACTED_TO_MESSAGES_SINGLE_EMOJI_FOR_USER
  • MOST_REACTED_TO_MESSAGES_SINGLE_EMOJI_PER_USER
  • MOST_REACTED_TO_MESSAGES_SINGLE_EMOJI_PER_CHANNEL
  • MOST_REACTED_TO_MESSAGES_SINGLE_EMOJI_PER_USER_IN_CHANNEL
• MOST_REACTED_TO_MESSAGES_SUM_EMOJI... #TODO
  • MOST_REACTED_TO_MESSAGES_SUM_EMOJI_PER_GUILD
  • MOST_REACTED_TO_MESSAGES_SUM_EMOJI_FOR_USER
  • MOST_REACTED_TO_MESSAGES_SUM_EMOJI_PER_USER
  • MOST_REACTED_TO_MESSAGES_SUM_EMOJI_PER_USER_IN_CHANNEL
• POPULARITY_OF_EMOJI_... #TODO
  • Guild, User, Channel, User in Channel
• NUMBER_OF_MESSAGES_PER_DAY.... #TODO
  • Guild, User, Channel, User in Channel
• Number of Messages based on Hour of Day #TODO
  • Guild, User, Channel, User in Channel
• AVERAGE_NUMBER_OF_MESSAGES_ON_WEEKDAYS #TODO
  • • Guild, User, Channel, User in Channel
• AVERAGE_NUMBER_OF_MESSAGES_ON_WEEKENDS #TODO
  • Guild, User, Channel, User in Channel
• Median message length per #TODO
  • Guild, User, Channel, User in Channel

• TODO Roles queries

Backlinks

• Questions for Discord Data