Power Automate - Can we update a Gift record?
Can we use Power Automate to update a record on the Gift - say I wanted to change the “Gift Code”, is that possible?
Comments
-
@Ryan Carr
Gift code can be changed with api.However, posted gift will mostly not be changeable. You can check the documentation on editing gift sky api.
2 -
@Alex Wong I am brand new to this, but trying to call the Gift (Edit) API, is there elements I am missing from this screenshot below? Again, just trying to change the Gift Code field to “Processed".
0 -
@Ryan Carr
You are missing authorization headers using the normal HTTP action.You can read more about this here
https://developer.blackbaud.com/skyapi/docs/authorization
It's quite a bit to read. You can search the community on authorization token and how to do automation without user login using refresh token. There are a few post on this.
1 -
@Alex Wong
I thought we couldn't use PATCH yet, there is still an issue with Microsoft per Heather at the last group meeting. I was looking to change some Assigned Solicitor types.I'm just seeing if you can use it for some things.
-Carol
0 -
@Carol Grant
There are 2 HTTP actions: One from Microsoft, and One from Blackbaud (under Blackbaud NXT Add-ins connector)The differences are:
- the Microsoft one is “generic” can be used for any API calling, while the Blackbaud NXT one can only call SKY API
- BB one takes care of authentication and authorization token at the time you connect the connection when editing flow, while Microsoft one you have to supply the subscription and authorization bearer token manually
- due to this, you have to use something like PostMan to get an initial authorization token (60 minutes expiration) and refresh token (365 days expiration), store this somewhere, and have a process to use refresh token to refresh the authorization token for use when you need to use it (or periodically every 59 minutes before authorization token expire, so you always have good authorization to use)
- BB one have the BUG that cannot hande PATCH, but Microsoft one can handle all no problem
0 -
@Alex Wong- thanks, I'll see if I want to pursue that.
0 -
@Alex Wong Thank you for your help! I did get the Microsoft HTTP request working with a token generated via Postman. I am having an issue implementing the repeat token though, do you have to reference that differently?
0 -
1
-
@Alex Wong I've gotten your HTTP request to work, but I my end goal is to do a PATCH request and update a field on the gift record. I know PATCH method isn't supported in the “Send an HTTP Request” - can I call a PATCH request after this HTTP request using the token it returns? I seem to be missing something here!
0 -
@Ryan Carr
if you got the refreshing of token to work, then great. remember the purpuse of refreshing token is so that you have a working/not expired authorziation bearer token to use for calling SKY API using HTTP action (the Microsoft one, not Blackbaud one that doesn't work with PATCH). So now you can use the token that you got back from the refresh token action and provide that as the header of the HTTP PATCH to edit gift.0
Categories
- All Categories
- 6 Blackbaud Community Help
- High Education Program Advisory Group (HE PAG)
- BBCRM PAG Discussions
- Luminate CRM DC Users Group
- DC Luminate CRM Users Group
- Luminate PAG
- 186 bbcon®
- 1.4K Blackbaud Altru®
- 389 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 14 donorCentrics®
- 355 Blackbaud eTapestry®
- 2.4K Blackbaud Financial Edge NXT®
- 616 Blackbaud Grantmaking™
- 542 Blackbaud Education Management Solutions for Higher Education
- 33 Blackbaud Impact Edge™
- 3.1K Blackbaud Education Management Solutions for K-12 Schools
- 909 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 207 JustGiving® from Blackbaud®
- 6.2K Blackbaud Raiser's Edge NXT®
- 3.5K SKY Developer
- 236 ResearchPoint™
- 116 Blackbaud Tuition Management™
- 375 YourCause® from Blackbaud®
- 160 Organizational Best Practices
- 232 The Tap (Just for Fun)
- 31 Blackbaud Community Challenges
- Blackbaud Consultant’s Community
- 19 PowerUp Challenges
- 3 Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 3 Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 71 Blackbaud Community All-Stars Discussions
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 743 Community News
- 2.8K Jobs Board
- Community Help Blogs
- 52 Blackbaud SKY® Reporting Announcements
- Blackbaud Consultant’s Community
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- Blackbaud Francophone Group
- Blackbaud Community™ Discussions
- Blackbaud Francophone Group