Unable to get Media Duration. Always Returns 0.

I’m having problems getting the duration of media sources. No matter what I do the ‘Get Duration’ node always returns 0.
I’m playing random clips from a playlist and essentially adding fade in/out effects with MI Interpolation. I need the clip duration in order to add the fade out effects at the correct time.
I’ve searched all over and the only related thread I could find was unresolved from years ago.

My current workaround is adding all the sources’ lengths to a data table manually, which is obviously not ideal. Especially since I plan to have dozens.
Would really appreciate some insight here.