Transforming Data - pledge installments

Rachel Bock

I am relatively new to PowerBI. I have a table that has multiple installments across a row (Cons System Id, Gift System ID, Installment 1 ID, Date, Amount, Balance, Installment 2 ID, Date, Amount, Balance. Installment 3 ID, Date, Amount, Balance etc. (all the way up to 12 installments).

I am trying to get an installment table that has the following columns and lists all of the installments on separate rows.

Cons System ID, Gift System ID, Installment ID, Installment Date, Installment Amount, Installment Balance

Would anyone be able to point me in the right direction? Thank you so much.

Alex Wong

@Rachel Bock
Gift v2 has get installment and get payment (payment and writeoff are consider “payment”) details.

https://developer.sky.blackbaud.com/api#api=gft-gifts&operation=GetInstallments

Unfortunately you can only get installment and payment per pledge, so you need to make multiple calls. If a pledge has multiple installment, the return JSON will be an array of installments, properly recorded, will be each installment per row.