Long story short: A-A cables are fundamentally broken and should not exist. Don't use them. An A plug always goes into a device sourcing power, and a B plug always goes into a device sinking power. A-A means connecting a source to a source, which leads to Bad Things. USB-C is a bit different. The cable is the same on both ends, so it features a special wire the two devices use to communicate who's going to be the sink and who's going to be the source. An A-female-to-C-male adapter has a thingy inside it which tells the attached C device that the adapter cable is a sink, on the other hand an A-male-to-C-male adapter has a thingy which tells the C device that the adapter cable is a source. USB also has "Host" and "Device" roles. Basically, the Host takes a leading role in the data connection, the Device only responds to requests from the Host. With classic USB, the Source is always also the Host, and the Sink is always also the Device. USB-C makes the same assumptions, but there is the possibility to swap either power or data role. One final bit is that USB-C has "dual-role ports", which can act as both a Source/Host and Sink/Device. They'll check what gets attacked, and take the other role. So why does all this matter? You probably have a charger or something with a female USB-A port, which you are connecting to an iPad with a female USB-C port. If you use a male-A-to-male-C cable, everything works fine: the charger is fixed to the Source role and assumes you're connecting a Sink - because that's the only possibility. The A-C cable acts as a Sink on the A connector (no other option, after all), and on the C connector has a little marker indicating it's a Source. The iPad senses that a Source is connected, so it starts acting like a Sink - and the iPad is happily charging. It can even talk data, if the charger is actually something fancy which can act like a Host. When you plug in the A-A cable, the charger is still in its fixed Source role, and the charger-side has its fixed Sink role. All fine. The iPad-side is also an A plug - which means it's also in a Sink role. That's bad, really bad! You now attach the female-A-to-male-C cable. The female-A part is fixed in Source role - so there are now two Sources connected to the A-A cable. The male-C part has a little marker indicating to the iPad that a Sink has been attached - so the iPad reconfigures the port into Source mode, starts supplying power, and tries to behave like a data Host... More on reddit.com

Buy a USB-A to USB-C cable. Adaptors are not standard compliant and might cause issues. For example, with two USB-A male to USB-C female adapters and a USB-C to USB-C cable you can create a USB-A to USB-A cable which might cause damage to devices you connect with it. More on reddit.com

USB A female to USB C male is pretty hard to get wrong. They are defined in the USB-C specification. Random Amazon example: https://www.amazon.com/Thunderbolt-Compatible-Chromebook-Pixelbook-Microsoft/dp/B07KR45LJW/ However, the one you linked is USB A male to USB C female. Adapters like this are not defined in the USB specifications, and for a good reason: one could stick two of those onto a C-C cable, and create an A-A cable! Imagine what could happen when someone sticks the ends of that monstrosity into two different USB chargers... Luckily, it is not entirely impossible. Basically, you want to get one with integrated safety electronics. This older post is a nice starting point: https://www.reddit.com/r/UsbCHardware/comments/m7rcu5/comment/grducjr/?utm_source=reddit&utm_medium=web2x&context=3 Personally, I would never buy one which has not been vetted by u/LaughingMan11 . It might work for your application and it'll probably be fine in most cases, but are you really willing to risk your car over paying a few cents more for a proper adapter? More on reddit.com

So the USB letters A, B, C only refer to the physical port. Adapters will inter convert with no problems. However, USB cables can transmit data and power using a wide range of protocols e.g. USB-2, displayport, thunderbolt. Electrically, there's no reason why an adapter wouldn't work, but it depends whether it can support the protocols and bandwidth required. In short, if your USB-A devices are simply for USB-1/2/3 data then they are compatible. Other types of data is more complex. More on reddit.com