Matching Gift Donor Details through PowerBI Connector (or any other SKY API endpoint)?

Matt Clemmens

Hey guys and gals - I've been running in circles trying to find a way to determine which constituent made the gift that triggered a Matching Gift in RE via either the PBI connector or any other SKY API endpoint. I can see the details cleanly in looking at the donor record in RE/RENXT, but finding the back-end link between the triggering gift and the MG entry are killing me. I have separate PBI pulls that grab Gifts and Soft Credits, and these work perfectly and can be combined in PBI with no issues - and I can pull the list of Matching Gift entries that tie back to the MG Org record - but I can't find any way to grab the constituent ID of the donor who made a gift that triggered a matching gift (or matching gift pledge). Has anyone encountered (or even better, solved!) this issue? In digging through the SKY documentation, I'm not finding any endpoints that touch this MG piece either - but I'm hoping I am missing something!

Alex Wong

@Matt Clemmens
Use Get Gift on the MG Pledge, the linked_gifts property will give you the original gift that triggered the MG Pledge.

Matt Clemmens

Amazing - thank you @Alex Wong!