I'm trying to create better membership retention reporting using the Wild Apricot api, as there doesn't seem to be a report showing what percentage of members renew or lapse (which surprises me).

I'm thinking that the invoices api is where I should start, and I'd like to see order details so that I can see what level of membership was chosen, renewed or lapsed, but I'm not seeing how to get order details for a set of invoices. Is that possible? If not, is there a workaround?

Ideally, I'd like to have a query in excel that would update using the api and I can do that for basic invoice data, but I'm not getting the details I'm looking for.