Soft Credit Just Giving gifts when passing gifts from a data warehouse into webview batching

Shaun Germany
Shaun Germany
Sixth Anniversary Kudos 1 Name Dropper Participant
in SKY Developer General Discussions

Hi,

We're looking at calling the Just Giving API to return gifts that we then prepare in a data warehouse then pass into batches for review by fundraising.

We will want to be able to have these gifts soft credited to the fundraising page owners.

Has anyone done this with success?

Shaun

Best Answer

  • Bryce Howard
    Bryce Howard
    Fourth Anniversary First Reply Kudos 1 Name Dropper
    edited April 24 Answer ✓

    The api at dataapi.justgiving.com gives you every donation in a date range with fundraiser fields already joined - that's what you want for a warehouse. It's a paid add-on though. Without it, you use api.justgiving.com which is not at all ideal. Using api.justgiving.com, you enumerate pages via GET /v1/charity/{charityId}/pages, then poll GET /v1/fundraising/pages/{pageShortName}/donations per page. This will give you only a display name. This makes donor matching much worse. Assuming your warehouse is setup and populated, and gifts are not in RE

    For the soft credit, you need the fundraising page owner's RE constituent ID. I think easiest approach: store the JustGiving FundraiserUserId as a custom field on the RE record, then look up by custom field. If that isn't possible you could search for them using constituents/search on email, fall back to duplicatesearch on name + address as a pre-create check, then POST /constituent/v1/constituents if genuinely new and store FundraiserUserId. Same two-stage lookup applies separately to the donor (who becomes constituent_id / hard credit on the gift).

    Once you get the correct record in RE matched to a FundraiserUserId , create a batch with POST /gift/v1/giftbatches, and add gifts with POST /gift/v1/giftbatches/{batch_id}/gifts. The soft credit is declared inline on each batch gift via the soft_credits array.

Answers

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Facilitator 5 Kudos 5 bbcon 2025 Attendee Badge

    I do no think there is API to retrieve list of gifts from JG.

    An option is to register RENXT webhook API for gift created (this is when a webview batch is approved, containing JG gifts if you have JG integration to RENXT), then look for gift with "comment/reference field" prefixed with JustGiving, those would be your justgiving gift. However, since "PATCH/edit" gift does not have ability to add soft credit right now (sometime this year I think we will have update on this, maybe), you will need to recreate the gift and add softcredit that way, then delete the original gift that was created from the approving of the webview gift batch.

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Facilitator 5 Kudos 5 bbcon 2025 Attendee Badge

    @Bryce Howard thanks for this, i had no idea there is another set of API that you need to pay for… that's terrible

  • Bryce Howard
    Bryce Howard
    Fourth Anniversary First Reply Kudos 1 Name Dropper

    Yeah, it seems purposefully segregated from the helpful responses.

  • Shaun Germany
    Shaun Germany
    Sixth Anniversary Kudos 1 Name Dropper Participant

    Hi both.

    Yes, we already have the gift data from Just Giving, our data engineer has the process for this so I can't confirm its 100% what Bryce has described.

    Shaun

  • Shaun Germany
    Shaun Germany
    Sixth Anniversary Kudos 1 Name Dropper Participant

    What I've been doing initially is manually matching to records for fundraising pages/owners (just to get a better picture of whats needed). This means I have the User IDs for the Fundraising Pages, and the fundraising page Ids in the records as custom field as (but not in the donor records yet).

    Going by Bryce's description I was heading in the right direction. Although I've been primarily and most effectively matching with name+email address. But we should be able to add name+postal address as a secondary option. It looks like it should work and will side step some of the significant issues we've experienced with the built in Just Giving Integration route.

    Thank you both.

Categories