Where can I get a lightning connector you don’t have it listed in part

Have you tried a different cable? I've noticed that sometimes the pins on the cable get slightly corroded which can cause charging/ data issues. If you've already tried a new cable then the issue is most likely the connector inside the iPad (if you've tried a different USB port too). There's a a few stores on EBAY that sell tons of Apple parts for relatively inexpensive. I've had this same issue on my iPhone, and just cleaned the lightning connector (unplugged, of course) with some isopropanol and a semi-rough brush. (Not the USB side, but the actual lightning connector side). If you just need the cable, you can get those almost anywhere, like Walgreens for example. Of course you'll get a better selection at a place like FRYs electronics if you have one near you. Most electronics stores (like Best Buy) will have the cable.