Transaction Code Value not working

Scott Parmely

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:

Alex Wong

@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

Scott Parmely

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

Alex Wong

@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

@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

@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