Error Action 'Apply_to_each_3' failed

Options
Marilyn Montoya
Marilyn Montoya
Sixth Anniversary Name Dropper Facilitator 1 Blackbaud Certified
in SKY Developer General Discussions

Hello, I have a flow for my acknowledgment letters that was working fine for months but recently started failing because of the below error. The error seems to indicate it's not passing a valid ID to call the relationships for a Tribute gift but I'm really not sure how to fix this error as I see nothing wrong in the constituent record. Can anyone advise? Thanks in advance.

{

"statusCode": 400,

"headers": {

"Cache-Control": "no-cache",

"Pragma": "no-cache",

"Strict-Transport-Security": "max-age=31536000;includeSubDomains",

"Request-Context": "appId=cid-v1:0c37065f-4d7c-47cf-af06-96cd9a75949d",

"Content-Security-Policy": "frame-ancestors 'self' https://host.nxt.blackbaud.com",

"section-io-id": "3fd9126e74502f951497dd0523ea4cd2",

"x-ms-function-status": "OK",

"Date": "Thu, 18 Jan 2024 23:04:26 GMT",

"Content-Length": "366",

"Content-Type": "application/json; charset=utf-8",

"Expires": "-1"

},

"body": [

{

"message": "The provided Id value 'relationships' is either not a valid integer, or it is not greater than or equal to '1'.",

"error_name": "ConstituentSecurityDataAccessRE7InvalidIntegerIdValue",

"error_code": 1,

"raw_message": "The provided Id value '{0}' is either not a valid integer, or it is not greater than or equal to '{1}'.",

"error_args": [

"relationships",

"1"

]

}

]

}

Tagged:

Comments

  • Austen Brown
    Austen Brown Community All-Star
    Ninth Anniversary Kudos 5 Name Dropper Participant

    @Marilyn Montoya - Can you share a screenshot of where in the flow this error is appearing? Make sure to include a few of the actions that proceed the one that is erroring out.

  • Marilyn Montoya
    Marilyn Montoya
    Sixth Anniversary Name Dropper Facilitator 1 Blackbaud Certified

    @Austen Brown yes, please see below.

    This is the screenshot of where the error occurs.

    233ae01da59b886a47fdb39e12fe6a6a-huge-im

    And this is the screenshot of the Action before the one above. Oddly the constituent ID that is listed in the “Get a constituent” Action is not a constituent in the gift list that is being pulled into this flow nor is it a tribute acknowledgee. In the “List gift tribute acknowledgee” Action there is a "gift_tribute_id" but I'm not sure what this refers to or how to look this up in RE. Any help or insight is greatly appreciated.

    592d5be1c66b847b5374ba2c2bae8c35-huge-im


  • Austen Brown
    Austen Brown Community All-Star
    Ninth Anniversary Kudos 5 Name Dropper Participant

    @Marilyn Montoya - “gift_tribute_id” = The system record ID of the gift tribute.

    Can you share a screenshot of the action that is failing, in edit mode? Rather than the result of the run?

  • Heather McLean
    Heather McLean
    Eighth Anniversary Kudos 3 Name Dropper Participant

    @Marilyn Montoya - when IDs aren't lining up sometimes I'm connecting to two different RENXT databases in the same flow. Have you checked to make sure all your connections are pointing to the same one?

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Marilyn Montoya
    the screenshot you shared that has the error is showing that you are calling this API endpoint:
    https://api.sky.blackbaud.com/constituent/v1/constituents/relationships/{relationship_id}

    which is to get a relationship record where you already know the relationship by its ID (this is NOT constituent record id). I don't know what your intent is on this call, but it does not look like you even provided a relationship_id to the API call neither. (
    /constituent/v1/constituents/relationships/) which is why it is failing

  • Marilyn Montoya
    Marilyn Montoya
    Sixth Anniversary Name Dropper Facilitator 1 Blackbaud Certified

    @Austen Brown Yes, let me know if the below will suffice. Thanks!

    f378512066f017e88c89f005cc75e6c9-huge-sc
  • Marilyn Montoya
    Marilyn Montoya
    Sixth Anniversary Name Dropper Facilitator 1 Blackbaud Certified

    @Alex Wong after looking for a pattern my sense is that the error is occurring when the tribute acknowledgee is the same as the Tribute honoree. So when a gift is made in honor of Jane Smith, the acknowledgee to send the Tribute notification is Jane Smith. Do you know what changes need to be made to the flow to support this? Thanks.

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Marilyn Montoya
    it shouldn't matter.

    But what does matter is what you provided as the ID to call the various API.

    in your List gift tribute acknowledges action, you should be providing the Gift tribute ID (it appears you provided the gift system ID), which can only be obtained from List gift tributes action where you provide the gift system id to it, and it returns an array (list) of gift tributes, from there you will use the tribute_id to get acknowledgees for this specific tribute (as there can be more than 1 tribute on a single gift).

Categories