# .csv vs. json discrepancy?

**URL:** <https://www.patreondevelopers.com/t/csv-vs-json-discrepancy/6385>\
**Category:** Friendly Help\
**Created:** [October 30, 2022, 4:12pm UTC](https://www.patreondevelopers.com/t/csv-vs-json-discrepancy/6385 "2022-10-30T16:12:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nicolascrab](https://avatars.discourse-cdn.com/v4/letter/n/cdc98d/32.png) [@nicolascrab](https://www.patreondevelopers.com/u/nicolascrab)\
**Post date:** [October 30, 2022, 4:12pm UTC](https://www.patreondevelopers.com/t/csv-vs-json-discrepancy/6385/1 "2022-10-30T16:12:21Z")

</div>

Hi,

I am very new to APIs so bear with me pls if I use the wrong terminology. Any advice is appreciated!

1. I have exported the Pledge Data in a .csv format. As of today, it has 895 individual patrons, they are all active patrons.

2. I have exported a json using the [“Paging through a list of pledges”](https://docs.patreon.com/#paging-through-a-list-of-pledges) method in the API documentation.

```auto
https://www.patreon.com/api/oauth2/api/campaigns/<campaign_id>/pledges?access_token=<access_token>

```

The json file’s “data” object has 979 records. Out of that 979 records, 800 has a “declined\_since” null value (meaning that they are active patrons) while 179 of them have a declined\_since value.

I’m guessing this means using the API method 2), I get a list of 800 active patrons (and 179 inactive ones), while using method 1), the exported .csv, I see 895 active patrons. Where is this discrepancy coming from? What am I doing wrong?

Thanks,  
Nicolas

---

<div class="post-metadata">

**Author:** ![codebard](https://yyz2.discourse-cdn.com/flex036/user_avatar/www.patreondevelopers.com/codebard/32/14_2.png) [@codebard](https://www.patreondevelopers.com/u/codebard)\
**Post date:** [November 1, 2022, 6:36am UTC](https://www.patreondevelopers.com/t/csv-vs-json-discrepancy/6385/2 "2022-11-01T06:36:33Z")

</div>

API would return you all your patrons. You have to filter the active ones and non active ones at your own app.

---

<div class="post-metadata">

**Author:** ![nicolascrab](https://avatars.discourse-cdn.com/v4/letter/n/cdc98d/32.png) [@nicolascrab](https://www.patreondevelopers.com/u/nicolascrab)\
**Post date:** [November 1, 2022, 9:14am UTC](https://www.patreondevelopers.com/t/csv-vs-json-discrepancy/6385/3 "2022-11-01T09:14:46Z")

</div>

Thanks for the reply!

I see what you mean, I did filter for the active ones but I still see fewer patrons. Here’s how the numbers look like (since it’s the 1st of the month, it’s different than in my original post):

**My patreon site shows:**

- 825 patrons

**API list of pledges method pulls:**

- 982 records
- 804 of the records have “declined\_since” value set at null (= there are 804 active patrons)

So where is the 825 - 804 = 21 remaining patrons from the API list? I can’t figure out what I’m doing wrong.

---

<div class="post-metadata">

**Author:** ![codebard](https://yyz2.discourse-cdn.com/flex036/user_avatar/www.patreondevelopers.com/codebard/32/14_2.png) [@codebard](https://www.patreondevelopers.com/u/codebard)\
**Post date:** [November 1, 2022, 11:55pm UTC](https://www.patreondevelopers.com/t/csv-vs-json-discrepancy/6385/4 "2022-11-01T23:55:05Z")

</div>

A patron having been declined does not mean that they immediately lose access to your campaign for the period that the patron has already paid for.

Additionally, there is a 2-3 day grace period in which declined patrons are considered valid until all the retries are done.

---

<div class="post-metadata">

**Author:** ![nicolascrab](https://avatars.discourse-cdn.com/v4/letter/n/cdc98d/32.png) [@nicolascrab](https://www.patreondevelopers.com/u/nicolascrab)\
**Post date:** [November 3, 2022, 3:02pm UTC](https://www.patreondevelopers.com/t/csv-vs-json-discrepancy/6385/5 "2022-11-03T15:02:39Z")

</div>

Okay, so I guess it was my definition of an “active patron” that caused the difference in numbers. Thanks!