Homeassistant

- Pin `pyasn1` and `pysnmplib` since `pyasn1` 0.5.0 has breaking changes and `pysnmp-pyasn1` and `pyasn1` are both using the `pyasn1` namespace (bdraco - 92254)
- Handle onvif errors when detail is returned as bytes (bdraco - 92259)
- Add VoIP error tone (synesthesiam - 92260)
- Fix Google Mail Sensor key error (tkdrob - 92262)
- Fix MQTT certificate files setup (jbouwh - 92266)
- Fix call deflection update in Fritz!Tools (mib1185 - 92267)
- Auto repair incorrect collation on MySQL schema (bdraco - 92270)
- Handle AttributeError from wrong port in ONVIF config flow (bdraco - 92272)

- Move BMW Target SoC to number platform (rikroe - 91081)
- Revert "Add silent option for DynamicShutter (ogp:Shutter) in Overkiz" (iMicknl - 91354)
- Turn AVM FRITZ!Box Tools call deflection switches into coordinator entities (mib1185 - 91913)
- Fix solaredge-local protobuf exception (rajeevan - 92090)
- Fix Insteon scenes with disabled entities (teharris1 - 92137)
- Bump `sonos-websocket` to 0.1.0 (jjlawren - 92209)
- Bump env_canada to 0.5.34 (michaeldavie - 92216)
- Add more detail to invalid rrule calendar error message (allenporter - 92222)
- Fix history YAML deprecation (frenck - 92238)
- Fix unknown/unavailable source sensor in Filter entities (frenck - 92241)
- Bump plugwise to v0.31.1 (bouwew - 92249)
- Bump pyunifiprotect to 4.8.3 (bdraco - 92251)

- Bump roborock to 0.8.1 for beta fixes (Lash-L - 92131)
- Fix options flow Workday (gjohansson-ST - 92140)
- Fix ZHA startup failure with the Konke button (puddly - 92144)
- Ensure purge can cleanup old format detached states in the database (bdraco - 92145)
- Fix ignored apple tvs being scanned over and over (bdraco - 92150)
- Bump Roborock to 0.8.3 (Lash-L - 92151)
- Properly resolve `media_source` URLs for Sonos announcements (jjlawren - 92154)
- Keep expose setting in sync for assist (emontnemery - 92158)
- Bump pyvizio to 0.1.61 (raman325 - 92161)
- Upgrade lakeside to 0.13 (nkgilley - 92173)
- Fix ZHA device triggers (dmulcahey - 92186)
- Fix mqtt subscribe debouncer initial delay too long when birth message is disabled (jbouwh - 92188)
- Update frontend to 20230428.0 (piitaya - 92190)
- Add missing PRESET_MODE feature to BAF fans (jfroy - 92200)
- Fix missing preset_mode feature in bond fans (bdraco - 92202)

- Set pipeline_id from pipeline select (jesserockz - 92085)
- ESPHome voice assistant: Version 2 - Stream raw tts audio back to device for playback (jesserockz - 92052)
- Bump intents to 2023.4.26 (synesthesiam - 92070)
- Add a channel changing API to ZHA (puddly - 92076)
- Remove name attribute from transmission services manifest (avee87 - 92083)
- Update YARL to 1.9.2 (frenck - 92086)
- Fix reconfigure by SSDP or Zeroconf discovery in Synology DSM (mib1185 - 92088)
- Fix capitalization names Assist entities (balloob - 92098)
- Use pipeline ID in event (balloob - 92100)
- Fix vizio integration_type (raman325 - 92103)
- Avoid exposing unsupported entities to Google Assistant (emontnemery - 92105)
- Avoid exposing unsupported entities to Alexa (emontnemery - 92107)
- Fix frontier_silicon not retrying setup and missing strings (wlcrs - 92111)
- Add WS command cloud/alexa/entities/get (emontnemery - 92121)
- Update frontend to 20230427.0 (piitaya - 92123)
- Bump sqlalchemy to 2.0.11 to fix a critical regression with postgresql (bdraco - 92126)
- Add add-on discovery URL and title to Wyoming integration (frenck - 92129)

Beta release notes: https://rc.home-assistant.io/latest-release-notes/

- Add a guard against selecting all entities in `state_changes_during_period` ([bdraco] - [91585]) ([recorder docs])
- Fix tasks with no due date from not triggering `on` calendar state. ([boralyl] - [91196]) ([todoist docs])
- Fix Insteon thermostat issue ([teharris1] - [91568]) ([insteon docs])
- Handle UnsupportedError in HomeWizard ([DCSBL] - [91608]) ([homewizard docs])
- Bump renault-api to 0.1.13 ([epenet] - [91609]) ([renault docs])
- Handle long format context UUIDs during migration ([bdraco] - [91657]) ([recorder docs])
- Bump aioshelly to 5.3.2 ([thecode] - [91679]) ([shelly docs])
- Fallback to generating a new ULID on migraiton if context is missing or invalid ([bdraco] - [91704]) ([recorder docs])
- Bump python-songpal dependency ([rytilahti] - [91708]) ([songpal docs])
- Do not wait for mqtt at startup mqtt_statestream ([jbouwh] - [91721]) ([mqtt_statestream docs])
- Bump pylitterbot to 2023.4.0 ([natekspencer] - [91759]) ([litterrobot docs])
- Bump pysml to 0.0.10 ([StephanU] - [91773]) ([edl21 docs])
- Relax the constraint that events must have a consistent timezone for start/end ([allenporter] - [91788]) ([google docs]) ([calendar docs])
- Disallow uploading files to bypass the media dirs ([balloob] - [91817]) ([media_source docs])

[90855]: https://github.com/home-assistant/core/pull/90855
[90956]: https://github.com/home-assistant/core/pull/90956
[91111]: https://github.com/home-assistant/core/pull/91111
[91196]: https://github.com/home-assistant/core/pull/91196
[91316]: https://github.com/home-assistant/core/pull/91316
[91356]: https://github.com/home-assistant/core/pull/91356
[91544]: https://github.com/home-assistant/core/pull/91544
[91568]: https://github.com/home-assistant/core/pull/91568
[91585]: https://github.com/home-assistant/core/pull/91585
[91608]: https://github.com/home-assistant/core/pull/91608
[91609]: https://github.com/home-assistant/core/pull/91609
[91657]: https://github.com/home-assistant/core/pull/91657
[91679]: https://github.com/home-assistant/core/pull/91679
[91704]: https://github.com/home-assistant/core/pull/91704
[91708]: https://github.com/home-assistant/core/pull/91708
[91721]: https://github.com/home-assistant/core/pull/91721
[91759]: https://github.com/home-assistant/core/pull/91759
[91773]: https://github.com/home-assistant/core/pull/91773
[91788]: https://github.com/home-assistant/core/pull/91788
[91817]: https://github.com/home-assistant/core/pull/91817
[DCSBL]: https://github.com/DCSBL
[StephanU]: https://github.com/StephanU
[allenporter]: https://github.com/allenporter
[balloob]: https://github.com/balloob
[bdraco]: https://github.com/bdraco
[boralyl]: https://github.com/boralyl
[epenet]: https://github.com/epenet
[frenck]: https://github.com/frenck
[jbouwh]: https://github.com/jbouwh
[natekspencer]: https://github.com/natekspencer
[rytilahti]: https://github.com/rytilahti
[teharris1]: https://github.com/teharris1
[thecode]: https://github.com/thecode
[actiontec docs]: https://www.home-assistant.io/integrations/actiontec/
[advantage_air docs]: https://www.home-assistant.io/integrations/advantage_air/
[airly docs]: https://www.home-assistant.io/integrations/airly/
[calendar docs]: https://www.home-assistant.io/integrations/calendar/
[edl21 docs]: https://www.home-assistant.io/integrations/edl21/
[frontend docs]: https://www.home-assistant.io/integrations/frontend/
[google docs]: https://www.home-assistant.io/integrations/google/
[homewizard docs]: https://www.home-assistant.io/integrations/homewizard/
[insteon docs]: https://www.home-assistant.io/integrations/insteon/
[lifx docs]: https://www.home-assistant.io/integrations/lifx/
[litterrobot docs]: https://www.home-assistant.io/integrations/litterrobot/
[media_source docs]: https://www.home-assistant.io/integrations/media_source/
[mqtt_statestream docs]: https://www.home-assistant.io/integrations/mqtt_statestream/
[recorder docs]: https://www.home-assistant.io/integrations/recorder/
[renault docs]: https://www.home-assistant.io/integrations/renault/
[shelly docs]: https://www.home-assistant.io/integrations/shelly/
[songpal docs]: https://www.home-assistant.io/integrations/songpal/
[todoist docs]: https://www.home-assistant.io/integrations/todoist/