Transaction Code Value not working

Scott Parmely
Scott Parmely
Name Dropper First Anniversary Facilitator 1
in Blackbaud Financial Edge NXT® APIs

Hi All,

I'm trying to filter my Transaction distribution (List) GET call by transaction code value and it is not working. Any ideas on what I'm missing? Thanks! For your help! I've tried updating the value to id, name (i.e. Expense Allocation) and value (i.e. Project Direct).

Here's the call:

Comments

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

    @Scott Parmely
    This works for me (see below), any error message? or just nothing returned? the transaction_code_1_value should be the actual string of the value, not the id

    GET https://api.sky.blackbaud.com/generalledger/v1/transactiondistributions?transaction_code_1_value=DIN18GA

    6b90c7a2801f22de62b8513799456376-huge-im
  • Scott Parmely
    Scott Parmely
    Name Dropper First Anniversary Facilitator 1

    @Alex Wong

    Thanks Alex. It just returns no content.

    GET https://api.sky.blackbaud.com/generalledger/v1/transactiondistributions?transaction_code_1_value=Project Direct

    Response Body

    {"count":0,"value":[]}

    And I clearly have transactions with that value. Any ideas?

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

    @Scott Parmely
    the URL looks good, so i don't know why you get no data, have you try a different transaction code 1 and see? how do you verify that FE definitely has transaction with that transaction code 1 entry?

  • Scott Parmely
    Scott Parmely
    Name Dropper First Anniversary Facilitator 1

    @Alex Wong

    Thanks - yes I've tried a variety of transaction codes and we certainly have them. It works when I bring all transactions in and then filter after the call for those codes. Was just hoping to filter during the GET call. Recommend i reach out to support?

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

    @Scott Parmely
    are you using the developer.blackbaud.com “try me” console? it seems like you are saying that when you make the same call without the transaction code 1 specified, you get the full list of transactions, then there's no reason why you can't filter using query parameter, since it does work for me. Can you screenshot a section of the returned data from the “full call” with the transaction code 1 you mentioned? (of cuz blocking out any identifiable info about your org).

    You can reach out to support and they will likely ask the same question, so better you already tried and let them know that. However, I don't think there's a blackbaud issue per say, as it works for me. Another question is, are you an employee/admin of the FE instance you are calling API from? or are you a contractor doing some for the org in a “partner” way. I have heard situation before where partner having issue that customer doesn't

Categories