Reply
Member
Posts: 1
Registered: ‎11-28-2011

Using API to figure out recurring

Hey folks,

 

Heres the situation:

 

We have a recurring subscription service, it bills people a set amount every 3 months.

I'd like to know if we can use the API to download the data, and sort out exactly what clients are recurring, and what clients are new, so we know how many new clients we're bringing in and how much we're making on the recurring charges.

 

If the API can do this, is there any suggested developer companies out there that can program such a system for us ?

 

Thanks.

 

Posts: 1,609
Topics: 15
Kudos: 201
Solutions: 121
Registered: ‎06-23-2011

Re: Using API to figure out recurring

You can use the Transaction Details API to get a list of transactions and then look up the details for each one, but unless you've tagged the transactions in some way that sets the recurring transactions apart from the initial transactions, you may have a hard time distinguishing them after the fact. What you really need to do is have your database store at least basic data, like for instance subscription ID's, start dates, and how many charges have been run for each one (that last value could be incremented from your Silent Post page - see the setting in the control panel) so you can later run the statistics you need.

 

You could, however, go to your control panel, click on active subscriptions and then on View All, and scan through them and get a pretty good idea of how things are going.