is it possible to make use of the 'where clause' on a table, by using the API still?
Yes, that is part of why this solution worked for me. I was able to do a where clause for each table, I used it to set the headerID which was different for each set of data.