I want to use Guestaccount information from SQL API because the reports from Insight are only send by email as pdf.
We want to do the billing automatically for our guestaccounts. We want to creat a process which directly connects to the sql api.
I got access to the sql api via pgAdmin. But I don't find the table which contains the data i need.
Where do i find the guest account data like
username, sponsorname start date and expiry date?
Is there any documentation about the sql api?
Thanks a lot.