How to use the new Send HTTP Request action
Comments
-
@Hallie Guiseppe
Have you tried using the Blackbaud Raisers Edge NXT Events connectors? That might be an easier way to get the data you're looking for.If that method doesn't work for you for some reason, Alex's suggestions are good!
1 -
@Hallie Guiseppe
Regarding your start_date issue, here's what you can use:
The expression for start_date_from is: split(addDays(convertFromUtc(utcNow(), 'Eastern Standard Time'), 7), 'T')[0]
The expression for start_date_to is: split(addDays(convertFromUtc(utcNow(), 'Eastern Standard Time'), 14), 'T')[0]
breaking it down:
convertFromUtc takes the current date/time (utcNow()) and convert it to my timezone (EST). (this is important if your report is “date sensitive" to the 1 day difference when utc time is “pass the ”date" of your timezone. You can find other timezone name to use here:
addDays adds number of days to today's date in your timezone, in this case, start_date_from is 7 days from today and start_date_to is 14 days from today.
split will split the date/time string by the separator of ‘T’ as start_date_from and start_date_to only wants yyyy-mm-dd part of a date/time string. then the [0] means you want the first section before the ‘T’
----- There are a few ways you can get the date part only of a date/time string after you are done with all the conversion and add days, split is one of them, or you can use substring to get first 10 characters of the date/time string as it is the date portion, or you can use formatDateTime to only get the date portion. Here's the link to the expression reference so you know how to work each expression:https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference
0 -
You guys rock! ? It is working!
Ben, I originally tried to start with the event connectors, and I found I needed to provide an event id which I didn't know how to obtain dynamically which lead me to listing out the events and trying to filter by date then picking up the id to get the info I want to email weekly.
Question. How is the filter finding “start date” when the key is listed as "startdatefrom" & "startdateto"? Is the from/to a kind of formula expression?
Alex, thank you so much for the schema code update. It looks like all you did was remove the “required” section. All the rest looks the same. I recall you mentioning on a user group something about the integer/number type but I couldn't find anything wrong with those.
Thank you for the split expressions. MS's helper recommended a similar expression that didn't work, but it was taking it to [3] instead of [0] for some reason. The links you provided will be super helpful when I need help again.
Thank you! Thank you! Thank you!
Hallie
1 -
@Hallie Guiseppe
in the connector action, are you sure you using the correct action:
The List events one should be the same as the HTTP Addin endpoint one. That one does not require you to have event id.
There's no formula, Start date from and Start date to is just the “range” of date on your event's start date field.
1 -
Hmmm. ? I think you are correct. I didn't see that when I was searching the connectors. Likely because I searched how it is listed in the endpoint reference “get event list” rather than “list events.” I suppose I learned a few lessons. 1. search different versions of the connector title. and 2. how to use the http request connector. ?
1 -
@Hallie Guiseppe
Yes, it is important to know how to use the HTTP Addin, so congratulation!1 -
Hi Everyone, @Ben Regier
I found this old thread, but I'm stuck and need help. I'm trying to pull an Advanced List from Core into Sharepoint (This user created a thread with her nice design.
However, I'm stuck on the HTTP relative path part. I've searched this community for other threads and nothing has helped. I then search the internet and found one video that helped me gain more clarity, but what they suggested is not working either.
My error is with the Relative path.
0 -
The screenshot you sent is the Blackbaud Send HTTP request action, but the relative path you are using is SharePoint path, so you mixed it up.
You cannot use Blackbaud's Send HTTP request action to "act" on sharepoint folder/file.
If you are trying to use the Academics student enrollment list API, the relative path is /school/v1/academics/enrollments/{user_id}.
The FULL URL of the api MUST begin with https://api.sky.blackbaud.com
I don't know what you plan to do, but it is UNLIKELY that you will need to use Send HTTP (SharePoint version of Send http) to do something in SharePoint. Let's start with what are you trying to achieve.
1 -
Thank you so much Alex! @Alex Wong I knew it was something like that and I was going crazy.
My boss has this idea of taking Advanced Lists from Core, pulling them into a Sharepoint folder, and then wants to connect those lists to Exchange Distribution Groups. That way the Distribution Email Groups will automatically update each night. Could that work?
0 -
Or Could I take a query from RENXT with the emails, shoot it over to a Sharepoint folder, and then link up with Exchange? Either side (EM or RE) would work for us….
0 -
I do not use EM, so I can't answer what can be done to pull info.
You can definitely run RE Query if those emails you want is in RE NXT.
As for being able to automate adding/removing members in a distribution list using Power Automate, I think it can be done, but haven't done this myself.
1 -
Got it, thanks! I'm new to all this, only started using Power Automate last year, so could you point me in the right direction for how to start/create a flow that pull from a query into Sharepoint?
0 -
search "query" in template showcase, there are a few you can use.
0
Categories
- All Categories
- 6 Blackbaud Community Help
- 206 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 357 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 561 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.6K SKY Developer
- 242 ResearchPoint™
- 118 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 778 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)






