How to use the new Send HTTP Request action

2»

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!

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    @Hallie Guiseppe
    Regarding your start_date issue, here's what you can use:

    1c8fdad157aabbb2c9a4987a88e69244-huge-im

    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:

    https://learn.microsoft.com/en-us/windows-hardware/manufacture/desktop/default-time-zones?view=windows-11

    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

    16797661256229466774fb6f4d70e409-huge-im
  • Hallie Guiseppe
    Hallie Guiseppe Community All-Star
    Sixth Anniversary Kudos 5 Name Dropper Participant

    @Ben Regier & @Alex Wong

    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

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    @Hallie Guiseppe
    in the connector action, are you sure you using the correct action:

    263615d9562ae35ca1e84faec244f9d6-huge-im

    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.

    2445a5299ae33bb9d7fbbabbd7a98ced-huge-im
  • Hallie Guiseppe
    Hallie Guiseppe Community All-Star
    Sixth Anniversary Kudos 5 Name Dropper Participant

    @Alex Wong

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

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    @Hallie Guiseppe
    Yes, it is important to know how to use the HTTP Addin, so congratulation!

  • Tyler Johnson
    edited August 21

    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.

    Screenshot 2025-08-21 121502.png Screenshot 2025-08-21 121821.png
  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    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

    image.png

    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.

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

  • Tyler Johnson
    edited August 21

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

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    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.

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

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    search "query" in template showcase, there are a few you can use.