# Trigger "QRZ.COM entry exists" for callsign pse?

**URL:** https://forum.hamalert.org/t/trigger-qrz-com-entry-exists-for-callsign-pse/526
**Category:** Feature Requests
**Tags:** done
**Created:** [January 20, 2024, 2:07pm UTC](https://forum.hamalert.org/t/trigger-qrz-com-entry-exists-for-callsign-pse/526 "2024-01-20T14:07:13Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![DK3DUA](https://forum.hamalert.org/letter_avatar_proxy/v4/letter/d/c77e96/32.png) [@DK3DUA](https://forum.hamalert.org/u/DK3DUA)
#### Post date: [January 20, 2024, 2:07pm UTC](https://forum.hamalert.org/t/trigger-qrz-com-entry-exists-for-callsign-pse/526/1 "2024-01-20T14:07:13Z")

</div>

Hello,

RBN often creates incorrect spots for new DXCC/slots, callsigns that don’t real exist.  
One indication if a call is real might be if any [QRZ.COM](http://QRZ.COM) entry exists.

BTW, I just did a QRZ database search for \* and got

Page 1 of 56969, of 2278730 matches for: \*

😉

73 es HNY  
Tom  
DK3DUA

---

<div class="post-metadata">

### Author: ![HB9DQM](https://forum.hamalert.org/user_avatar/forum.hamalert.org/hb9dqm/32/5_2.png) [@HB9DQM](https://forum.hamalert.org/u/HB9DQM)
#### Post date: [January 21, 2024, 3:23pm UTC](https://forum.hamalert.org/t/trigger-qrz-com-entry-exists-for-callsign-pse/526/2 "2024-01-21T15:23:05Z")

</div>

Sounds like a good idea; this would be similar to what we already have for eQSL.cc and LoTW in the “QSL methods” condition.

I have just contacted [QRZ.COM](http://QRZ.COM) to ask if a list of registered callsigns would be available for downloading once a day by HamAlert.

---

<div class="post-metadata">

### Author: ![DK3DUA](https://forum.hamalert.org/letter_avatar_proxy/v4/letter/d/c77e96/32.png) [@DK3DUA](https://forum.hamalert.org/u/DK3DUA)
#### Post date: [January 21, 2024, 6:58pm UTC](https://forum.hamalert.org/t/trigger-qrz-com-entry-exists-for-callsign-pse/526/3 "2024-01-21T18:58:49Z")

</div>

Hope you get a positive answer from [QRZ.COM](http://QRZ.COM), but I’m afraid that the only method is what I mentioned, query database for call ‘\*’.  
Run through all result pages and parse the html text.  
Perhaps not really practicable either.  
Maybe some filters can also be set in the RBN clusters for greater reliability of the spots.

---

<div class="post-metadata">

### Author: ![HB9DQM](https://forum.hamalert.org/user_avatar/forum.hamalert.org/hb9dqm/32/5_2.png) [@HB9DQM](https://forum.hamalert.org/u/HB9DQM)
#### Post date: [February 2, 2024, 5:55pm UTC](https://forum.hamalert.org/t/trigger-qrz-com-entry-exists-for-callsign-pse/526/4 "2024-02-02T17:55:14Z")

</div>

I have received a reply from [QRZ.COM](http://QRZ.COM). Unfortunately a bulk download of all registered callsigns is not available. They told me that I could query the XML API, but given that HamAlert processes millions of spots per day with tens of thousands of unique callsigns (at least), and each XML API call is for a single callsign only, I’m pretty sure HamAlert would get banned from the API almost immediately, even when caching the results for a while.

---

<div class="post-metadata">

### Author: ![DK3DUA](https://forum.hamalert.org/letter_avatar_proxy/v4/letter/d/c77e96/32.png) [@DK3DUA](https://forum.hamalert.org/u/DK3DUA)
#### Post date: [February 2, 2024, 6:14pm UTC](https://forum.hamalert.org/t/trigger-qrz-com-entry-exists-for-callsign-pse/526/5 "2024-02-02T18:14:21Z")

</div>

> [@DK3DUA](#):
>
> query database for call ‘\*’.  
> Run through all result pages and parse the html text.

It is possible to get all QRZ COM registered calls, all in one run, without API.  
There is , at the top left, a search bar. Search for \* and wait until result appears.  
It needs an automated script to make this query and then load all result pages and  
extract data.

I get:  
Page 1 of 57027, of 2281077 matches for: \*

---

<div class="post-metadata">

### Author: ![HB9DQM](https://forum.hamalert.org/user_avatar/forum.hamalert.org/hb9dqm/32/5_2.png) [@HB9DQM](https://forum.hamalert.org/u/HB9DQM)
#### Post date: [February 2, 2024, 6:41pm UTC](https://forum.hamalert.org/t/trigger-qrz-com-entry-exists-for-callsign-pse/526/6 "2024-02-02T18:41:29Z")

</div>

Hmm, not sure if they would like us to load 57000 pages every couple of days… If it was my server, I would ban/rate limit such requests 😉

---

<div class="post-metadata">

### Author: ![DK3DUA](https://forum.hamalert.org/letter_avatar_proxy/v4/letter/d/c77e96/32.png) [@DK3DUA](https://forum.hamalert.org/u/DK3DUA)
#### Post date: [February 2, 2024, 7:09pm UTC](https://forum.hamalert.org/t/trigger-qrz-com-entry-exists-for-callsign-pse/526/7 "2024-02-02T19:09:18Z")

</div>

Yes, that is to be assumed, the query is also only possible for registered users.

The background to the whole thing was the low reliability of the rbn spots. It may be possible to solve this differently by evaluating these spots for reliability. Perhaps something like a GROUP BY count, i.e. a spot is only reliable if a certain number of spotters have recognized it in exactly the same way.
