Constituent Code API and Power BI Connector

Lawrence Kinkopf

Hi all - I currently have the Power BI custom connector setup to our RE/FE NXT data.

I am trying to isolate or identify the primary constituent code of our constituents. Using the Constituent Code List API reference https://developer.sky.blackbaud.com/api#api=56b76470069a0509c8f1c5b3&operation=ListConstituentCodesAllConstituents, it appears there is a sequence field. However, I do not see it as a column in my Power Query.

Is that what is used to identify the primary constituent code? I can't find a way to edit the source URL with the custom connector to Power BI.

Potential work around - if the first constituent code listed is the primary, could I sort by Constituent ID/Constituent Code ID in Power Query, and then remove duplicate rows? I feel like I am making a mountain from a mole hill… ?

Alex Wong

@Lawrence Kinkopf
power bi custom connector does not always expose all the fields that is in the SKY API endpoint, so if you find yourselves not seeing the field, then you will have to edit the custom connector yourselves if you know how to, or use another method to get data directly from the SKY API endpoint.

No, using the constituent code id isn't helpful. as that ID is just incrementing number, a LATER added code can be primary if it is “moved” to the top