Loading Profile...
Is it possible to export transaction data for our accountant?
I have heard there is a way to export transaction information via the API from another user but I cannot find any information on this. Please could you advise.
I’m happy
2
people have this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
Create a customer community for your own organization
Plans starting at $19/month
-
Inappropriate?Can you give me some more detail on what kind of transaction data you mean, and/or what you need it for? We have a lot of different data available via the API, so I'm just trying to figure out if we already provide what you need or if you'll need something that we're not providing yet.
I’m interested
-
Inappropriate?I agree with this. I don't need it from the API (although that would be nice), but even just exposing a CSV export link in the Spreedly interface would be excellent. Specifically what I need is a way to download transaction history within a time frame or all time. This will make doing my taxes a lot easier. :)
I’m hopeful
-
Inappropriate?We soft-launched an API for pulling transaction data, and would love your feedback on it:
https://spreedly.com/manual/integrati...
It's going to give you a fire-hose that will certainly need some massaging depending on what you want to do with the data, and we're particularly interested to know if all the data you're looking for is there.
I’m excited
-
Inappropriate?That's great, it's exactly what I'm needing. However, I can't quite make sense of how it works. I called it with no since_id parameter, and it seems to have returned a random assortment of transactions from May to today, not all of them, and not the 50 most recent.
Also, from the documentation, it's unclear what since_id will do. Are transaction id's unique to my site? So if I subtract 50 and iterate, will I then get all the transactions for my site? Or if transaction id is global to Spreedly, how would I loop back and get all my previous transactions?
Perhaps a more useful parameter would be to specify a date range.
The data that the API call provides looks great though, that's exactly the information I'm wanting to retrieve.
Thanks,
Luke -
Inappropriate?Luke, here's how it works:
If you pass no since_id, Spreedly gives you back the 50 most recent transactions. These will correspond to what you see on the Transactions page in Spreedly (though I think it shows less than 50 at a time).
Generally, however, you'll want to use since_id. Id's are not unique per-site, but pagination is easy: just start by passing since_id=0, and you'll get the 50 oldest of your sites transactions. To get the next fifty, just grab the newest transaction the last call gave you and pass its id as the since_id. That will give you the next 50, and you can keep going until you pass a since_id and get back less than 50 results, indicating you have them all. In the future, to update your transaction data, just pass the newest transaction id you've pulled as since_id, and paginate as before.
Does that help explain?
EMPLOYEE
