I'll let others chime in as well, but we've seen many customers go to integrated antenna APs wherever they can. Reason for that is that mounting is much easier, just one unit to mount, and no issues with bad antenna cables or connectors. The AP-518 is not an outdoor AP, it's hardened indoor (IP55 rating) and can be mounted outdoors if it's under a roof or so. There should be no direct rain coming in. Also, the antenna connectors are RP-SMA, typically used indoor, so that's why you need different antennas and from the 6 connectors, 4 are for the 4x4 5GHz radio and 2 are for the 2x2 2.4GHz radio; so you need two antennas for dual band. RP-SMA is a bit less robust than N-Type connectors, especially when you need to water-proof the connections. And yes, you should use all connectors, connectors that you can't use would need a 'RF-terminator' to avoid damage to the radio; and also need to be weather-proofed in outdoor/dusty/harsh conditions.
Then one other option that you could explore is the AP-679 which has a built-in directional antenna that an be switched between 30x30 degrees and 30x90 degrees, which can be really useful for warehouses (or stadium, or other). When used outdoor, the AP-679 cannot use 6GHz in EU.
It may be good to discuss this with your HPE Networking partner, local HPE Networking sales, or get involved with a WiFi specialist that has done many of these deployments (however it sounds a bit like that is you...).
------------------------------
Herman Robers
------------------------
If you have urgent issues, always contact your HPE Aruba Networking partner, distributor, or Aruba TAC Support. Check
https://www.arubanetworks.com/support-services/contact-support/ for how to contact HPE Aruba Networking TAC. Any opinions expressed here are solely my own and not necessarily that of Hewlett Packard Enterprise or HPE Aruba Networking.
In case your problem is solved, please invest the time to post a follow-up with the information on how you solved it. Others can benefit from that.
------------------------------