Homeassistant

- 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/

- Add SetSynchronizationPoint fallback to onvif ([GrumpyMeow] - [86400]) ([onvif docs])
- Fix SharkIQ token expiration ([funkybunch] - [89357]) ([sharkiq docs])
- Reolink prevent ONVIF push being lost due to ConnectionResetError ([starkillerOG] - [91070]) ([reolink docs])
- Add missing mock in sharkiq tests ([epenet] - [91325]) ([sharkiq docs])
- Tado set_water_heater_timer should use water_heater domain ([rich-kettlewell] - [91364]) ([tado docs])
- Fix listener running in foreground for System Bridge integration ([timmo001] - [91391]) ([system_bridge docs])
- Bump onvif-zeep-async to 1.2.5 ([bdraco] - [91399]) ([onvif docs])
- Fix attribute reporting config failures in ZHA ([puddly] - [91403]) ([zha docs])
- Save Thread dataset store when changing preferred dataset ([emontnemery] - [91411]) ([thread docs])
- Bump env_canada to v0.5.33 ([michaeldavie] - [91468]) ([environment_canada docs])
- Fix creating onvif pull point subscriptions when InitialTerminationTime is required ([bdraco] - [91470]) ([onvif docs]) (dependency)
- Bump onvif-zeep-async to 1.2.11 ([bdraco] - [91472]) ([onvif docs]) (dependency)
- Handle a few more transient onvif errors ([bdraco] - [91473]) ([onvif docs])
- Reolink ONVIF move read to primary callback ([starkillerOG] - [91478]) ([reolink docs])
- Fix onvif failing to reload ([bdraco] - [91482]) ([onvif docs])
- Resolve issue with switchbot blind tilt devices getting stuck in opening/closing state ([BTMorton] - [91495]) ([switchbot docs]) (dependency)
- Fix state mapping in fibaro climate ([rappenze] - [91505]) ([fibaro docs])
- Bump unifiprotect to 4.8.1 ([AngellusMortis] - [91522]) ([unifiprotect docs]) (dependency)

[86400]: https://github.com/home-assistant/core/pull/86400
[89357]: https://github.com/home-assistant/core/pull/89357
[90855]: https://github.com/home-assistant/core/pull/90855
[90956]: https://github.com/home-assistant/core/pull/90956
[91070]: https://github.com/home-assistant/core/pull/91070
[91111]: https://github.com/home-assistant/core/pull/91111
[91316]: https://github.com/home-assistant/core/pull/91316
[91325]: https://github.com/home-assistant/core/pull/91325
[91356]: https://github.com/home-assistant/core/pull/91356
[91364]: https://github.com/home-assistant/core/pull/91364
[91391]: https://github.com/home-assistant/core/pull/91391
[91399]: https://github.com/home-assistant/core/pull/91399
[91403]: https://github.com/home-assistant/core/pull/91403
[91411]: https://github.com/home-assistant/core/pull/91411
[91468]: https://github.com/home-assistant/core/pull/91468
[91470]: https://github.com/home-assistant/core/pull/91470
[91472]: https://github.com/home-assistant/core/pull/91472
[91473]: https://github.com/home-assistant/core/pull/91473
[91478]: https://github.com/home-assistant/core/pull/91478
[91482]: https://github.com/home-assistant/core/pull/91482
[91495]: https://github.com/home-assistant/core/pull/91495
[91505]: https://github.com/home-assistant/core/pull/91505
[91522]: https://github.com/home-assistant/core/pull/91522
[AngellusMortis]: https://github.com/AngellusMortis
[BTMorton]: https://github.com/BTMorton
[GrumpyMeow]: https://github.com/GrumpyMeow
[balloob]: https://github.com/balloob
[bdraco]: https://github.com/bdraco
[emontnemery]: https://github.com/emontnemery
[epenet]: https://github.com/epenet
[frenck]: https://github.com/frenck
[funkybunch]: https://github.com/funkybunch
[michaeldavie]: https://github.com/michaeldavie
[puddly]: https://github.com/puddly
[rappenze]: https://github.com/rappenze
[rich-kettlewell]: https://github.com/rich-kettlewell
[starkillerOG]: https://github.com/starkillerOG
[timmo001]: https://github.com/timmo001
[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/
[environment_canada docs]: https://www.home-assistant.io/integrations/environment_canada/
[fibaro docs]: https://www.home-assistant.io/integrations/fibaro/
[frontend docs]: https://www.home-assistant.io/integrations/frontend/
[homewizard docs]: https://www.home-assistant.io/integrations/homewizard/
[lifx docs]: https://www.home-assistant.io/integrations/lifx/
[onvif docs]: https://www.home-assistant.io/integrations/onvif/
[reolink docs]: https://www.home-assistant.io/integrations/reolink/
[sharkiq docs]: https://www.home-assistant.io/integrations/sharkiq/
[switchbot docs]: https://www.home-assistant.io/integrations/switchbot/
[system_bridge docs]: https://www.home-assistant.io/integrations/system_bridge/
[tado docs]: https://www.home-assistant.io/integrations/tado/
[thread docs]: https://www.home-assistant.io/integrations/thread/
[unifiprotect docs]: https://www.home-assistant.io/integrations/unifiprotect/
[zha docs]: https://www.home-assistant.io/integrations/zha/

- Bump python-homewizard-energy to 2.0.1 ([DCSBL] - [91097]) ([homewizard docs]) (dependency)
- Bump aiolifx to 0.8.10 ([bdraco] - [91324]) ([lifx docs]) (dependency)
- Update frontend to 20230411.1 ([bramkragten] - [91344]) ([frontend docs])

[90855]: https://github.com/home-assistant/core/pull/90855
[90956]: https://github.com/home-assistant/core/pull/90956
[91097]: https://github.com/home-assistant/core/pull/91097
[91111]: https://github.com/home-assistant/core/pull/91111
[91316]: https://github.com/home-assistant/core/pull/91316
[91324]: https://github.com/home-assistant/core/pull/91324
[91344]: https://github.com/home-assistant/core/pull/91344
[DCSBL]: https://github.com/DCSBL
[balloob]: https://github.com/balloob
[bdraco]: https://github.com/bdraco
[bramkragten]: https://github.com/bramkragten
[frenck]: https://github.com/frenck
[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/
[frontend docs]: https://www.home-assistant.io/integrations/frontend/
[homewizard docs]: https://www.home-assistant.io/integrations/homewizard/
[lifx docs]: https://www.home-assistant.io/integrations/lifx/

- Fix configuring Flo instances ([amattas] - [90990]) ([flo docs])
- Fall back to polling if webhook cannot be registered on Nuki ([pree] - [91013]) ([nuki docs])
- Track availability of source sensor in utility meter ([dgomes] - [91035]) ([utility_meter docs])
- Bump aiopyarr to 23.4.0 ([tkdrob] - [91110]) ([sonarr docs]) ([radarr docs]) ([lidarr docs])
- Bump env_canada to 0.5.32 ([michaeldavie] - [91126]) ([environment_canada docs])
- Relax calendar event validation to allow existing zero duration events ([allenporter] - [91129]) ([google docs]) ([calendar docs]) ([caldav docs])
- Bump ulid-transform to 0.6.3 ([bdraco] - [91133])
- Fix false positive in SQL sensor full table scan check ([bdraco] - [91134]) ([sql docs])
- Reolink config flow fix custom port when USE_HTTPS not selected ([starkillerOG] - [91137]) ([reolink docs])
- Fix all day event coercion logic ([allenporter] - [91169]) ([calendar docs]) ([local_calendar docs])
- Reduce startup time for System Bridge integration ([timmo001] - [91171]) ([system_bridge docs])
- Cleanup ZHA from Zigpy deprecated property removal ([dmulcahey] - [91180]) ([zha docs])
- Bump `pytile` to 2023.04.0 ([bachya] - [91191]) ([tile docs])
- Flush conversation name cache when an entity is renamed ([emontnemery] - [91214]) ([conversation docs])
- Update frontend to 20230411.0 ([bramkragten] - [91219]) ([frontend docs])
- Fix switch_as_x name ([emontnemery] - [91232]) ([switch_as_x docs])
- Update Inovelli Blue Series switch support in ZHA ([codyhackw] - [91254]) ([zha docs])
- Bump ZHA dependencies ([puddly] - [91291]) ([zha docs])
- Restore use of local timezone for MariaDB/MySQL in SQL integration ([bdraco] - [91313]) ([recorder docs]) ([sql docs])
- Google Assistant SDK: Fix broadcast command for Portuguese ([tronikos] - [91293]) ([google_assistant_sdk docs])
- Remove codecov from Python test requirements ([frenck] - [91295])

[91293]: https://github.com/home-assistant/core/pull/91293
[91295]: https://github.com/home-assistant/core/pull/91295
[frenck]: https://github.com/frenck
[tronikos]: https://github.com/tronikos
[google_assistant_sdk docs]: https://www.home-assistant.io/integrations/google_assistant_sdk/
[90855]: https://github.com/home-assistant/core/pull/90855
[90956]: https://github.com/home-assistant/core/pull/90956
[90990]: https://github.com/home-assistant/core/pull/90990
[91013]: https://github.com/home-assistant/core/pull/91013
[91035]: https://github.com/home-assistant/core/pull/91035
[91110]: https://github.com/home-assistant/core/pull/91110
[91111]: https://github.com/home-assistant/core/pull/91111
[91126]: https://github.com/home-assistant/core/pull/91126
[91129]: https://github.com/home-assistant/core/pull/91129
[91133]: https://github.com/home-assistant/core/pull/91133
[91134]: https://github.com/home-assistant/core/pull/91134
[91137]: https://github.com/home-assistant/core/pull/91137
[91169]: https://github.com/home-assistant/core/pull/91169
[91171]: https://github.com/home-assistant/core/pull/91171
[91180]: https://github.com/home-assistant/core/pull/91180
[91191]: https://github.com/home-assistant/core/pull/91191
[91214]: https://github.com/home-assistant/core/pull/91214
[91219]: https://github.com/home-assistant/core/pull/91219
[91232]: https://github.com/home-assistant/core/pull/91232
[91254]: https://github.com/home-assistant/core/pull/91254
[91291]: https://github.com/home-assistant/core/pull/91291
[91313]: https://github.com/home-assistant/core/pull/91313
[allenporter]: https://github.com/allenporter
[amattas]: https://github.com/amattas
[bachya]: https://github.com/bachya
[balloob]: https://github.com/balloob
[bdraco]: https://github.com/bdraco
[bramkragten]: https://github.com/bramkragten
[codyhackw]: https://github.com/codyhackw
[dgomes]: https://github.com/dgomes
[dmulcahey]: https://github.com/dmulcahey
[emontnemery]: https://github.com/emontnemery
[frenck]: https://github.com/frenck
[michaeldavie]: https://github.com/michaeldavie
[pree]: https://github.com/pree
[puddly]: https://github.com/puddly
[starkillerOG]: https://github.com/starkillerOG
[timmo001]: https://github.com/timmo001
[tkdrob]: https://github.com/tkdrob
[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/
[caldav docs]: https://www.home-assistant.io/integrations/caldav/
[calendar docs]: https://www.home-assistant.io/integrations/calendar/
[conversation docs]: https://www.home-assistant.io/integrations/conversation/
[environment_canada docs]: https://www.home-assistant.io/integrations/environment_canada/
[flo docs]: https://www.home-assistant.io/integrations/flo/
[frontend docs]: https://www.home-assistant.io/integrations/frontend/
[google docs]: https://www.home-assistant.io/integrations/google/
[lidarr docs]: https://www.home-assistant.io/integrations/lidarr/
[local_calendar docs]: https://www.home-assistant.io/integrations/local_calendar/
[nuki docs]: https://www.home-assistant.io/integrations/nuki/
[radarr docs]: https://www.home-assistant.io/integrations/radarr/
[recorder docs]: https://www.home-assistant.io/integrations/recorder/
[reolink docs]: https://www.home-assistant.io/integrations/reolink/
[sonarr docs]: https://www.home-assistant.io/integrations/sonarr/
[sql docs]: https://www.home-assistant.io/integrations/sql/
[switch_as_x docs]: https://www.home-assistant.io/integrations/switch_as_x/
[system_bridge docs]: https://www.home-assistant.io/integrations/system_bridge/
[tile docs]: https://www.home-assistant.io/integrations/tile/
[utility_meter docs]: https://www.home-assistant.io/integrations/utility_meter/
[zha docs]: https://www.home-assistant.io/integrations/zha/