Using RAM DataAccess to retrieve foundation loads

Hello, I am trying to write an excel macro using RAM DA to generate data similar to that of the report that can be generated in RAM Foundation module 'Load Case Forces' report. My initial idea was to get column forces at bottom of each column by filtering out column segments not at base, and all is working except the only load cases that I can access are gravity and wind load cases, and I cant seem to figure out how to show the seismic load cases (I have RAM Frame analyzed with multiple of each wind and seismic cases, only the wind cases are showing up in excel though). The total number of load cases using getnumanalyzedframeloadcases is higher than what the getcolforcesforlcase is able to access. Any tips? Would it be better to retrieve this data via nodal reactions or a different command? Thanks.