Non-working API call

Robert Benjamin-Laing
Robert Benjamin-Laing
Name Dropper Facilitator 1
in SKY Developer General Discussions

Hi,

Parts of my flow aren't working. My issue is with the “Send an HTTP request “ action. Im using the ”Get Query job status ”action URI as the relative path - but that seems not to be working. Tried using the relative path from blackbaud - /query/queries/(I changed this to the query ID) - but that didnt work either.

28afb8f4e1cea31bdafccf3ba5c67eb3-huge-im

01661670c38eb9e144d78ef856f7bdbc-huge-im

1327448085d689611f36e90ffd699329-huge-im

Got the following error:

37c4a04268dc1893d9b5bf304cb01572-huge-im

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Robert BenjaminLaing
    if you are trying to download the data after a job has been executed, you do not use the blackbaud send http request, instead just the normal “HTTP” action from power automate

  • Robert Benjamin-Laing
    Robert Benjamin-Laing
    Name Dropper Facilitator 1

    @Alex Wong

    Would this be the correct JSON to get only the Constituent ID ? Im getting a "bad request "error. My colleague's request has changed a bit so I now just need the constituent ID from a query I've already created in Raiser's Edge NXT. Where it says description in the select from query ID description I put my query ID which as you most likely know is dispalyed in the URL if you press copy link and the paste it in the URL.Thanks for all the help so far!

    b9ad936bac153dce9e5dc2a492cff850-huge-im

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Robert BenjaminLaing
    no, this is not correct JSON for Ad hoc query.

    this is what a JSON for querying looks like

    {
    "query": {
    "select_fields": [
    {
    "query_field_id": 4539,
    "user_alias": "cid"
    }
    ],
    "sort_fields": [],
    "gift_processing_options": {
    "soft_credit_option": "Donor",
    "matching_gift_credit_option": "MatchingGiftCompany",
    "use_gross_amount_for_covenants": false
    },
    "advanced_processing_options": {
    "use_alternate_sql_code_table_fields": false,
    "use_alternate_sql_multiple_attributes": false
    },
    "type_id": 20,
    "format": "Dynamic",
    "suppress_duplicates": false,
    "constituent_filters": {
    "include_inactive": true,
    "include_deceased": true,
    "include_no_valid_addresses": true
    }
    },
    "ux_mode": "Asynchronous",
    "formatting_mode": "None",
    "output_format": "JSON"
    }

Categories