Query API - 2 Summary Fields

Bob Raymond

Created a query with 2 gift amount summary fields - same criteria, except different gift date ranges. When run the query in NXT, the fields show different data (correct). When post the query via the API, the result is the summary fields have the same data. Tried to delete/re enter in query - same issue. Checked query JSON, looks ok. Anybody seen this issue?

Jordan Wells

That sounds like a discrepancy between how NXT evaluates the query and how the API processes the summary fields. Since the JSON looks correct and the query works as expected in NXT, check whether the API endpoint fully supports separate date criteria for multiple summary fields. Testing each summary field in a separate query could also help isolate whether it’s an API limitation or a query configuration issue.