Power Automate - Can we update a Gift record?

Ryan Carr

Can we use Power Automate to update a record on the Gift - say I wanted to change the “Gift Code”, is that possible?

Alex Wong

@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.

Ryan Carr

@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".

Alex Wong

@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.

Carol Grant

@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

Alex Wong

@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

Carol Grant

@Alex Wong- thanks, I'll see if I want to pursue that.

Ryan Carr

@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?

Alex Wong

@Ryan Carr

this is my HTTP call to refresh the token

Ryan Carr

@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!

Alex Wong

@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.