Where does the rear hatch wiring on a 2013 Sportage lead to after entering the roof? Forward under the headliner or down the rear pillar beside the cargo trim?

No they are slightly different a pillars

If your motor is audible and your fuses and connectors are okay, you may have to take a close look at the plastic gear parts up in the roof. The nylon parts do wear out since they are in the roof and more exposed to different temperatures. If any of that mechanism fails then your sunroof will stop working even if the motor is still good. It is a bit of a PITA to get to it since you will have to remove the headliner to get at the mechanism and then identify the worn part and replace it CAUTION: The sunroof system is timed from the factory so that the motor shuts off automatically when the sunroof window reaches a certain position. Extreme care must be taken when removing the motor, timing may be thrown off causing possible damage to the sunroof system. Anytime the motor is removed from the sunroof assembly the sunroof glass panel must be in the FULLY CLOSED POSITION or the unit will be out of timing. The drive motor cannot be reset to the park position after being removed.
CAUTION: The sunroof motor should only be powered through the vehicle battery and sunroof wire harness. Applying power to the sunroof motor leads will cause failure of the control module.
Move glass panel to the fully closed position.
Move glass panel to the fully closed position.
Remove the A-pillar trim. (Refer to 23 - BODY/INTERIOR/A-PILLAR TRIM - REMOVAL)
Remove the B-pillar upper trim. (Refer to 23 - BODY/INTERIOR/B-PILLAR UPPER TRIM - REMOVAL)
Remove the C-pillar trim. (Refer to 23 - BODY/INTERIOR/C-PILLAR TRIM - REMOVAL)
Remove the D-pillar trim. (Refer to 23 - BODY/INTERIOR/D-PILLAR TRIM - REMOVAL)
Remove the sunvisors. (Refer to 23 - BODY/INTERIOR/SUN VISOR - REMOVAL)
Remove the overhead console. (Refer to 8 - ELECTRICAL/OVERHEAD CONSOLE - REMOVAL)
Disconnect the control switch wire connector.
Remove headliner as necessary to gain access to sunroof drive motor. Refer to Headliner Removal and Installation for proper procedures.
Disconnect the drive motor wire harness connectors (Sunroof Drive Motor and Express Module).
Remove drive motor fasteners and remove motor from the sunroof housing

They go down inside front A pillar an inside rear D pillar . To get at them you need to take trim off an the headliner down .
Sunroof Housing Rear Drain Hose Replacement (Impala)
Remove the headliner. Refer to Headlining Trim Panel Replacement in Interior Trim. Remove the rear quarter lower trim panel. Refer to Rear Quarter Lower Trim Panel Replacement in Interior Trim. Disconnect the rear sunroof drain hose from the sunroof module rear spigot. Remove the tape from the rear sunroof drain hose tube.
Disconnect the rear sunroof drain hose from the rear sunroof drain hose tube. Remove the rear sunroof drain hose tube from the upper retainer clip. Remove the rear sunroof drain hose from the rear pillar
The front is simalier .

1) Front End Sensor - Right--Located under the front hood in the engine compartment (2) I/P Air Bag--Located at the top right under the instrument panel (3) Roof Rail Air Bag - Right--Located under the headliner, extending from the passenger front windshield pillar to the passenger rear windshield pillar (4) Side Impact Sensor (SIS) - RF--Located under the right front door trim near the lower rear of the door frame (5) Sensing and Diagnostic Module (SDM)--Located underneath the vehicle carpet under the center console (6) Seat Belt Pretensioner - RF--Located under the trim near the bottom of the center pillar (7) Side Impact Sensor (SIS) - RR--Located under the right rear door trim near the lower rear of the door frame (8) Roof Rail Module - Right--Located behind the garnish molding on the upper rear pillar (9) Roof Rail Module - Left--Located behind garnish molding on the upper rear pillar (10) Side Impact Sensor (SIS) - LR--Located under the left rear door trim near the lower rear of the door frame (11) Seat Belt Pretensioner - LF--Located under the trim near the bottom of the center pillar (12) Side Impact Sensor (SIS) - LF--Located under the left front door trim near the lower rear of the door frame (13) Roof Rail Air Bag - Left--Located under the headliner, extending from the driver front windshield pillar to the driver rear windshield pillar (14) Steering Wheel Air Bag--Located on the steering wheel (15) Vehicle Battery--Located at the front left of the engine compartment. (16) Front End Sensor - Left--Located under the front hood in the engine compartment

Important: This sunroof system is timed from the factory in order to allow the actuator to shut off automatically when the sunroof window reaches a certain position. Use extreme care when removing the actuator from the sunroof module. This may cause the timing to be thrown off. This may damage to the sunroof. Anytime the actuator needs to be removed from the module, ensure that the sunroof window is in the fully closed position.
Remove the sunroof window. Refer to Sunroof Glass Panel Replacement .
Slide the sunshade fully rearward. Move the sunroof window to the vent position. Remove the sunroof screws (two on each side). Remove the sunroof window from the module.
Place the sunroof module in the fully closed position. Remove the headliner. Refer to Headlining Trim Panel Replacement in Interior trim.
Tools Required ?€¢
J 38778 Door Trim Pad and Garnish Clip Remover

?€¢
J 2772-C Headliner Installer

1. Remove the sunshades. Refer to Sunshade Replacement .
2. Remove the overhead console, if equipped. Refer to Roof Console Replacement .
3. Remove the sunshade retainers. Refer to Sunshade Anchor Replacement .
4. Remove the power sunroof switch, if equipped. Refer to Sunroof Switch Replacement in Roof.
5. Remove the sunroof trim lace, if equipped. Refer to Sunroof Seal/Molding Replacement in Roof.
6. Remove the dome light, if equipped.
7. Remove the coat hooks. Refer to Coat Hook Replacement .
8. Remove the assist handles. Assist Strap Replacement
9. Remove the rail lamp. Refer to Roof Side Rail Lamp Replacement in Lighting.
10. Remove the windshield side garnish molding. Refer to Windshield Pillar Garnish Molding Replacement .
11. Remove the upper quarter trim panels. Refer to Rear Quarter Upper Trim Panel Replacement .
12. Remove the center pillar upper trim panel. Refer to Center Pillar Upper Trim Panel Replacement .
13. Pull down on the door opening weatherstrip seal on both the front and the rear doors.
14. Remove the 2 rear retainers (2) using J 38778 Door Trim Pad and Garnish Clip Remover. Disconnect the headliner electric harness at the right side of the rear window shelf. Rotate the right front seatback to a horizontal position. Remove the headliner from the vehicle through the right front door.
    

Disconnect the electrical connector from the actuator.
Important: Before removing the actuator, ensure that the pins J 41718 are tight and holding the cable.
Thread the J 41718 into the front sunroof window screw hole in order to retain the cable adjustment. Remove the sunroof actuator screws. Remove the sunroof actuator from the module. Did you look for a video on youtube ?

you have to first remove all the Plastic trim pieces around the head liner that hold it in place including grab handles or clothes hangers then it will come down easily, i recommend having an extra set of hands when you take it down so as not to damage it, then simply slide it out through the rear hatch. it is actually very easy to do.

I found this on an Odyssey forum. It is long, but that panel is not a short process. After you have fixed the wire, you might have to "rehome" the doors. Google this and you should find instructions.

1. I just finished replacing the passenger 3rd row seatbelt in my 2006 Odyssey, which required removal and replacement of the trim panel. Instructions were enclosed with the new seatbelt ordered from Honda, but I had to scan thru the whole document because the needed info was not in the section about 3rd row seatbelt replacement.
   
   Trim panel removal is not terribly difficult, but is rather fussy and slow work. Basically the panels are held in place by little plastic pins that snap into holes in the underlying metal bodywork. In addition, the rear panel is held at the bottom by the sliding door threshold panel and the rear hatch threshold panel, and at the top by the pillar trim panels flanking the rear window. (These are called Pillars C and D, repectively).
   
   You may as well start by unbolting the 2nd row seatbelt at the floor and on Pillar C. Down at the floor, pull back the rubbery cover and unscrew the bolt using a 14mm wrench. Up above, on the pillar, remove the plastic cover at the sealbelt shoulder height adjustment mechanism. This cover has hooks molded into either side, so gently use a screwdriver to pry them loose and pop off the cover, then unscrew the bolt with your 14mm wrench.
   
   Next, remove the sliding door threshold panel by prying it up with a screwdriver or prybar and getting your fingers under it until you hear and feel the pins pop loose one by one. You will develop a feel for how much force to apply. Use your fingers as much as possible, because you risk marring the plastic edges with steel tools. The threshold panel is hooked into the other trim panels at either end, so work it to disengage.
   
   Fold the rear seat down flat and remove the plastic cover over the seat pivot. Pry the forward side up first and then rotate it rearwards over the pivot, and then disengage and remove it fully.
   
   At the rear hatch, unscrew the two cargo net knobs on the passenger side. The plastic knobs will probably come off like nuts, leaving a steel stud behind, or the stud may remain attached to the knob; either way is okay.
   
   Pry loose and remove the little plate on the rear trim panel "window sill" where the seat belt enters. BTW, keep all these little loose parts together as you go.
   
   On Pillar D (rearmost pillar) there is a small square cover that says something about air bags. Pry this loose at the top, as it is hinged at the bottom. You may need something thinner than a screwdriver (try a pocket knife). Once this is open, remove the Phillips head screw inside.
   
   Pillar C (forward) also has a square "air bag" cover plate, but it works differently. Just pry it straight out, but not all the way out. Just let it dangle.
   
   At this point all the major hindrances to removing the passenger side rear trim panel have been dealt with. Starting back at the rear hatch, pry the panel loose and pull it away from the wall, using fingers as much as possible. Listen for the plastic pins to pop loose as you go. There are two at the rear, four across the "window sill" and two toward the front. There is another pin in the center of the panel, but it will pop loose eventually as you pull the panel away from the wall.
   
   NOTE: The lower trim panel and the pillar trim panels are hooked together, so you have to work those joints to separate them. NOTE: DO NOT TRY TO PULL THE PILLAR TRIM PANELS LOOSE AT THE TOP. First loosen them at the bottom, and then rotate and work them gently free of the headliner. Similarly, the main trim panel should be loosened at either end and along the top before rotating the panel in, sort of pivoting at its base. It is hooked under the rear hatch threshold, so you'll have to work it free by pushing down and rotating.
   
   Long before this point, I was wondering if I could get at the seatbelt retractor spool behind the trim panel without completely removing the trim panel. However, there was a hard plastic a/c duct in the way, so I had to completely remove the trim panel to get at the duct. It turned out there wasn't much holding the duct in place and I was able to loosen it enough to get the old seat belt spool out and the new one bolted in.
   
   Reinstall everything in reverse order. One tip I can offer concerns the little square plate on the Pillar C trim panel, the one I said to leave dangling. This gizmo is actually a long plastic stud. When I finally managed to pull the Pillar C trim panel loose from the main trim panel, this stud fell out. It is molded in tan plastic (my van has tan interior) but it had a separate black piece on the end. I thought I would never get this stud/plate back in place during reinstallation. Here's the trick: take the little black piece loose from the stud, and install it first by itself by pushing it into the hole, making sure the cross-shaped hole is aligned correctly to match the tan stud. The small black piece is analogous to a nut, and the tan stud is like a bolt. Put the "nut" in first, then poke the "bolt" in on top of it. Otherwise, the stud forces the "nut" to expand BEFORE IT CAN ENTER THE HOLE in the metal bodywork, and no amount of pushing or pounding will force it in.
2. -->
3. 

If you drop down the headliner I think the drain hose runs to the rear and comes out in the trunk ? But can be blown out with compressed air from sun roof .

Open your sun roof all the way. look in the two front corners you will see little holes, water runs under your sun roof all the time, it is guided toward these holes, what you can't see is under the headliner there are tubes connected to these holes. the tubes wind their way down the 'A' pillar and out the bottom of the car. if you carefuly pour a cup of water into these holes you will notice it 'peeing' out somewhere behind the front tire. NOW your problem is in the back. at the back of the sun roof opening there are also two small holes, sometimes very hard to find but they will be there.the rear tubes take different paths on differnt vehicles but the end result is the same. (they all drain out the bottom somewhere). take a cup of water and pour it down each side and note if it is draining properly. if one side is not, it could be a cracked hose, or the hose has come off, or it has become blocked. if all four holes are draining properly it's most likely not your sunroof.
hope this helps

this is not an easy repair w/o damaging the headliner. There is nothing up there except maybe a roof brace. Check the luggae rack again by trying to move all the peices. One must be loose.
there are 27 steps!
If equipped, remove the overhead console.

1. Remove the screw and disconnect the electrical connectors
2. If equipped, remove the electronic compass sensor.
3. If equipped, disconnect the auto dimming interior mirror connector.
4. Remove the interior/map reading lamp. For additional information, refer to Section 417-02 .
   • Upon installation, make sure the notch in the headliner aligns with the tab on the interior/map reading lamp bracket.
5. Disconnect the roof opening panel electrical connector and the wire connector pin-type retainer.
6. Remove the gimp around the roof opening panel.
1. Remove the sun visors. For additional information, refer to Sun Visor in this section.
1. Position aside the door opening weatherstrips
7. NOTE: Installing the LH side sun visor clip will support front of headliner while working on headliner.
   Install the LH side sun visor retainer clip.
   • Loosely install the screw.

Disconnect the electrical connector and the wiring pin-type retainers on the A-pillar.

1. Release the upper B-pillar trim panel clips and position aside the upper B-pillar trim panel.

Release the C-pillar trim panel clips and position aside the C-pillar trim panel

1. Remove the rear upper headliner trim panel.
2. Remove the D-pillar trim panel.

Vehicles with rear climate control

1. Remove the rear auxiliary A/C controls.
   • Disconnect the electrical connectors
2. Position aside the LH rear quarter trim panel.
3. Disconnect the electrical connectors.
4. Remove the pin-type retainers and the upper air duct.
   • Push down on the air duct, tilt the top outward and pull upward to remove the air duct
5. Remove the lower air duct.
6. Disconnect the electrical connector located at the C-pillar.
   • Release the wiring harness pin-type retainers.
7. : To prevent damage to the coat hanger retainer, use a 3/16-inch flat-blade screwdriver for this step. Remove the third row coat hooks.
   • Open the access cover.
   • Insert a screwdriver into the coat hook slot and turn the screwdriver 90 degrees so that it engages in the plastic component slot. This will spread the steal attachment clip wings to allow the plastic component to disengage. The steal clip will stay engaged in the sheet metal.
8. Remove the rear headliner pin-type retainer.
9. NOTE: An assistance is required to help support the center of the headliner for the remaining steps.
   
   1. CAUTION: To prevent damage to the coat hanger retainer, use a 3/16-inch flat-blade screwdriver for this step.
      Remove the second row coat hooks.
      • Open the access cover.
      • Insert a screwdriver into the coat hook slot and turn the screwdriver 90 degrees so that it engages in the plastic component slot. This will spread the steal attachment clip wings to allow the plastic component to disengage. The steal clip will stay engaged in the sheet metal.
   2. Remove the LH side sun visor retainer clip.
      • Open the access cover and remove the screw.
   3. NOTE: Rear seats must be folded down and front seats reclined back for this step.
      Tilt the RH side of the headliner upward and remove the headliner from the rear of the vehicle.

good luck