How to fetch all patronage-data via the API with PHP

Tim_Rodenbroker · January 19, 2021, 12:35pm

Hi folks!

I need to fetch all Patreon patronage-data as JSON, just like the patronage.csv that can be donwloaded in the backend. As far as i can see, the API supports requests for single patrons, but is there also a way to get all patrons from one single request?

Thank you in advance!

Best,

Tim

codebard · January 19, 2021, 5:41pm

https://docs.patreon.com/#get-api-oauth2-v2-campaigns-campaign_id-members

You can try using the includes mentioned in the details for members call to see whether it will return the info you need.

Tim_Rodenbroker · January 19, 2021, 7:57pm

Great, will check this out. Thank you !!!

Maksym_Mikolajczyk · January 21, 2021, 2:55pm

Hi! For me it returns only like 20 records, while I have many more in the CSV export. Any idea why?

codebard · January 25, 2021, 6:55pm

You would probably need to do pagination.

https://docs.patreon.com/#requesting-specific-data

Using page[size] instead of count.

Dr.H · February 10, 2021, 10:32am

Can you share that snippet here… I am a noob and would like to do the same. But I am sort of lost in where to put the authentication etc.

Thanks so much

Maksym_Mikolajczyk · February 10, 2021, 1:45pm

I just copied a function from this one:

github.com

Patreon/patreon-wordpress/blob/master/classes/patreon_api_v2.php

<?php


if( !defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly
}

// This file will include the v2 versin of Patreon_API class until v2 transition is complete

class Patreon_API {

	public $access_token;

	public function __construct( $access_token ) {
		$this->access_token = $access_token;
	}
	
	public function fetch_user() {

		// We construct the old return from the new returns by combining /me and pledge details

This file has been truncated. show original

and made an “$api_return = $this->__get_json(…)” with the API endpoint from the docs.
I don’t have it now, cause I removed it when it couldn’t produce reasonable results