SQL API Endpoints

These endpoints retrieve historical aggregated data via SQL queries.

👻 Pokémon HeatMap Data

• Endpoint: /api/sql/get_pokemon_heatmap_data

• Description:

  • Retrieves heatmap data for Pokémons using month-based time parameters.

• Query Parameters:

  • Changes:

    • start_time and end_time Expect YYYYMM format.

  • Additions:

    • pokemon_id

    • form

    • iv_bucket (0, 25, 50, 75, 90, 100 or all)

    • limit (returns results limited by this number - important for the visual API)

  • Allows you to query for individual pokemon_id, form, iv_bucket and limit.

• Examples:

✨ Shiny Rate Data

• Endpoint: /api/sql/get_shiny_rate_data

• Description:

  • Retrieves Pokémon shiny rate statistics based per account.

• Query Parameters:

  • Equal Time Filter YYYYMM format.

  • Additions:

    • pokemon_id

    • form

    • username

    • shiny (0 = False, 1 = True)

    • limit

  • Allows you to query for individual pokemon_id, form, username, shiny and limit.

• Examples:

👹 Raid SQL Data

• Endpoint: /api/sql/get_raid_data

• Description:

  • Retrieves raid-related data including filters for gym ID, raid Pokémon, raid level, and more.

• Query Parameters:

  • Equal Time Filter YYYYMM format.

  • Additions:

    • gym_id

    • raid_pokemon

    • raid_form

    • raid_level

    • raid_team

    • raid_costume

    • raid_is_exclusive

    • raid_ex_raid_eligible

  • Allows you to query for individual gym_id and raid parameters.

• Examples:

🕴️Invasion SQL Data

• Endpoint: /api/sql/get_invasion_data

• Description: Provides historical invasion data with filters for pokestop ID, display type, character, grunt, and confirmed status.

• Query Parameters:

  • Equal Time Filter YYYYMM format.

  • Additions:

    • pokestop_id

    • display_type

    • character

    • grunt

    • confirmed

    • limit

  • Allows you to query for individual pokestop_id, and invasion parameters.

• Examples:

🔎 Quest SQL Data

• Endpoint: /api/sql/get_quest_data

• Description: Retrieves quest data using a range of filters such as pokestop ID, AR quest type, reward types, and more.

• Query Parameters:

  • Equal Time Filter YYYYMM format.

  • Additions:

    • pokestop_id

    • ar_type

    • normal_type

    • reward_ar_type

    • reward_normal_type

    • reward_ar_item_id

    • reward_normal_item_id

    • reward_ar_poke_id

    • reward_normal_poke_id

    • limit

  • Allows you to query for individual quest parameters.

• Examples: