Inconsistent query results

Valerie Marshall
Valerie Marshall
Sixth Anniversary Kudos 1 Name Dropper Facilitator 1
in Blackbaud Grantmaking™ APIs

I have written a Power Automate flow that retrieves records from Blackbaud Grantmaking using SKY API references and writes them to an Excel table. I make no changes to the flow, yet I get inconsistent results. Sometimes it works exactly as it should. But regularly, it duplicates some records and leaves out others. Oddly, it always reports the same number of records. I have a theory related to caching, but I have no idea if that's a problem or how to eliminate it. Any ideas? Thank youi.

Tagged:

Answers

  • Valerie Marshall
    Valerie Marshall
    Sixth Anniversary Kudos 1 Name Dropper Facilitator 1

    Update: I seem to have pseudo-solved my problem, at the expense of time. My flow uses the POST Search for Payments API (https://developer.sky.blackbaud.com/api#api=grantmaking&operation=SearchPayment) to loop through several hundred payment records. I was using the per_page parameter to retrieve the max 100 records at a time. I reduced the per_page parameter to 1, and got far fewer duplicates, less often. But still some occasionally. I added a delay 1 second between each loop, and I haven't gotten any duplicates in about 30 runs. My flow takes much longer to run, but right now accuracy is more important than time.

  • Valerie Marshall
    Valerie Marshall
    Sixth Anniversary Kudos 1 Name Dropper Facilitator 1

    Sadly, that worked until it didn't. It ran 30x without displaying any duplicates. Then 3 failures in a row. There seems to be 1 record duplicated and 1 row left out. Not the same rows every time.

Categories