Membership links to Gift

Kevin Hardy

Hi -

I'm trying to figure out how I can use some SKY API Endpoints to read all of the Gift information that is linked to a Membership.

I'm thinking I'm going to use the Membership Endpoint
https://api.sky.blackbaud.com/membership/v1/memberships/membershipdetails/{membership_id}
and the Gift Endpoint
https://api.sky.blackbaud.com/gift/v1/gifts/{gift_id}

But I'm not sure how I can “pull all memberships and the receipt (note: different than the dues) information for that membership gift”

Is there a way to see the link between the Gift and the Membership entry? Any ideas?

Alex Wong

@Kevin Hardy
SKY API support of membership and gifts isn't there yet.

Your best bet is to use Query API to get Membership and its linked gift info.

Kevin Hardy

EDIT:
Nevermind - I just realized I had to set the include_read_url to “OnceCompleted” in the Query execution job status endpoint. Got it. Leaving this here in case someone else made the same mistake!


@Alex Wong Thanks. I'm a bit new to that API.

Using the Query API I can execute a query based on ID, but i seem to be stuck. How do I see the results of the query? I see that it returns the query job ID and it's status, and there's another endpoint I can poll to get the job status, but how do I can get the results when the job is completed?

Help… I feel like I'm missing something very obvious here… Is there a “get results from job id” endpoint?

Alex Wong

@Kevin Hardy
the endpoint to get status is the endpoint that will provide the URL that allows you to download result when it is ready.

there are 2 templates you can see how it all works: