search

NYCPlanning / deprecated-labs-zap-api

Deprecated version of the ZAP API, see https://github.com/NYCPlanning/labs-zap-api
Other
5 stars 3 forks source link

Duplicate assignments provided in API response #239

Closed allthesignals closed 4 years ago

allthesignals commented 4 years ago

There are duplicate assignments being provided in the API response.

This was spot checked by there being many multiple duplicate assignment IDs.

We should see if something is going wrong with one of the joins.

hannahkates commented 4 years ago

This seems to occur when an LUP user is assigned to one project with the same role multiple times in CRM. I'm working on a SQL fix for the API that deduplicates the response when that happens.