The API has started returning duplicate leads.

Andrew shared this problem 14 months ago
Known

We've been making queries like this daily since 2018-06-28:

GET /api2/leads/?apiKey=$apiKey&limit=100&modified_date=8%2F10%2F2018+-+8%2F11%2F2018&rowsort=5&rowdir=ASC
On 2018-08-14, they started returning hundreds of duplicate results, e.g.:

$ http get 'https://www.inflatableoffice.com/api2/leads/' \
  apiKey=="$apiKey" \
  limit=='1000' \
  modified_date=='8/15/2018 - 8/16/2018' \
  rowsort=='5' \
  rowdir=='ASC' \
| jq --raw-output '.items[] | .id' \
| sort | uniq --count | sort --numeric --reverse \
| awk '{printf "%3s copies of lead %s\n", $1, $2}'
126 copies of lead 3257125
100 copies of lead 3451919
 53 copies of lead 3288021
 45 copies of lead 3091177
 41 copies of lead 3525783
 36 copies of lead 3085567
 35 copies of lead 3221163
 31 copies of lead 2988883
 27 copies of lead 3013939
 25 copies of lead 2988881
 24 copies of lead 3526235
 22 copies of lead 3275517
 21 copies of lead 3074163
 19 copies of lead 2718541
 18 copies of lead 3479113
 17 copies of lead 3584653
 17 copies of lead 3476765
 17 copies of lead 3397741
 16 copies of lead 3460079
 15 copies of lead 3587319
 15 copies of lead 2235579
 14 copies of lead 2694943
 13 copies of lead 3398455
 12 copies of lead 3263087
 12 copies of lead 2789949
 11 copies of lead 3091003
 11 copies of lead 2746169
 10 copies of lead 3452241
 10 copies of lead 3263245
  9 copies of lead 3469199
  9 copies of lead 3086589
  9 copies of lead 3057237
  7 copies of lead 3430249
  7 copies of lead 3258171
  7 copies of lead 3237921
  7 copies of lead 3171913
  7 copies of lead 2800909
  7 copies of lead 2678025
  7 copies of lead 2549149
  6 copies of lead 3467725
  6 copies of lead 3430367
  6 copies of lead 3410455
  6 copies of lead 3319453
  6 copies of lead 3057023
  6 copies of lead 3023599
  5 copies of lead 3577255
  5 copies of lead 3397797
  5 copies of lead 3392715
  5 copies of lead 3243899
  5 copies of lead 2061019
  4 copies of lead 3263629
  4 copies of lead 3086523
  3 copies of lead 3591495
  3 copies of lead 3589455
  3 copies of lead 3300001
  3 copies of lead 3064127
  3 copies of lead 3015775
  3 copies of lead 2913439
  3 copies of lead 2730975
  3 copies of lead 2730969
  2 copies of lead 3459659
  2 copies of lead 3410443
  2 copies of lead 3284181
  2 copies of lead 3281033
  2 copies of lead 3254181
  2 copies of lead 2739257
  1 copies of lead 3575009
  1 copies of lead 3528033
  1 copies of lead 3437747
  1 copies of lead 3400391
  1 copies of lead 3074281
What changed? Is there a different way we should be querying for leads that have been modified after a given time?

Best Answer
photo

Sorry for the issues with this! I have found and repaired the issue causing this.

Comments (2)

photo
1

Sorry for the issues with this! I have found and repaired the issue causing this.

photo
1

Thanks!

photo