InvoiceDetails object returns error 500

[asirota]

When trying to use InvoiceDetails on any report, the following is returned.

Wild Apricot API returned an error: Exception: Request failed for https://api.wildapricot.org returned code 500. Truncated server response: {"Message":"An internal error has occured. Please contact Wild Apricot support.\r\n Request ID:23acf3f4-ccb0-40f0-be16-90ec073dbdb2."} (use muteHttpExceptions option to examine full response)

This is a complex report object that iterates through all available invoice IDs and returns details on each ID to Looker Data Studio.

[asirota]

I've identified why the error is being hit at least. It seems our first call to get the list of invoice IDas per the criteria is sending a query parameter called $skip set to 0. This was working before but now sends an error 500.

The API call we are sending to get a list of invoice IDs is

/accounts/:accountId/invoices?unpaidOnly=false&includeVoided=true&idsOnly=true&StartDate=2023-01-01&EndDate=2023-12-31&$top=100&$skip=0

If the list of identifiers is larger than $top value then we have to paeg and set skip to the next set of IDs, but we always start with 0 and that appears to now throw a 500 error.

[asirota]

I opened a support ticket to see if the API behaviour has changed under ticket ID 1464514