Power Automate and Education Management Advanced List issue

Denise Stasio · August 20

I am using Power Automate to get data from one of our Education Management Advanced Lists. When I do a manual export of this list on our school website under Core/Manage Lists, the list contains 15471 items. In Power Automate, I should be getting the same items when I use a loop with "Send an HTTP request" and the correct SKY List Single format . After much digging, I've found that all items but 3 are coming into the flow correctly. When I look through the JSON data, I see that the missing data is at about item numbers: 8001, 15001 and 15002. I know these are close to the beginning or ending of each pass through a loop, but this problem is not happening for each of the 16 loops. Any ideas on what might be causing this issue and what I can do to fix it? Here is part of my flow that pertains to the issue:

Thank you!
Denise Stasio
St. Agnes Academy
Houston, Texas

Bryce Howard · August 21

Sounds like it might be a page-boundary pagination problem.

Your loop is paging in chunks of 1000. The API’s sort order is causing a few rows to “move” between the requests during your loop

To paginate through SKY API collections, use the limit and offset parameters to define your pages, and rely on the next_link

Denise Stasio · August 28

I agree that the API sort order is causing the problem. However, there is not limit and offset parameters for the Get List Single like you have in Constituent.

https://developer.sky.blackbaud.com/api#api=school&operation=V1ListsAdvancedByList_idGet

I am using the page parameter which is working. I tried adding page_size in the "Query parameters" below but that did not work. Also, I don't see how that is going to help as the data will still move around.

Any help with this is much appreciated!

Power Automate and Education Management Advanced List issue

Answers

Categories