On 18/06/2021 08:36, Hank Nussbacher wrote:

As I delve deeper I am more confused. I went to:

https://www.ripe.net/manage-ips-and-asns/db/support/querying-the-ripe-database#4--query-multiple-databases-with-the-global-resource-service

and wanted to search not just RIPE but all RIRs.

So I started with a simple search like:

https://apps.db.ripe.net/db-web-ui/query?bflag=true&dflag=false&rflag=true&searchtext=marlink&source=RIPE&types=organisation

1 hit. Very nice. Easy peasy.

So I now try all RIRs:
https://apps.db.ripe.net/db-web-ui/query?bflag=true&dflag=false&rflag=true&searchtext=marlink&source=GRS&types=organisation

No hits. Shouldn't I have had at least 1 hit from RIPE for this search?

Regards,

Hank

On 18/06/2021 00:38, Edward Shryane wrote:

This helps as a start. I had played with standard search:
http://rest.db.ripe.net/search?type-filter=inetnum&query-string=TEST
but as per the documentation in github:
https://github.com/RIPE-NCC/whois/wiki/WHOIS-REST-API-search
with:
type-filter Optional. If specified the results will be filtered by object-type, multiple type-filters can be specified.

doesn't seem to work since I am getting object-types other than inetnum (such as role or person). Unless I am doing something wrong. Can you clue me in to the proper syntax? Will type-filter=inetnum work on fulltextsearch as well?

Incidentally, the first and second examples on that RIPE github page:
http://rest.db.ripe.net/search?inverse-attribute=org&type-filter=inetnum&source=ripe&query-string=ORG-NCC1-RIPE
results in:
ERROR:101: no entries found No entries found in source %s.
Seems like source=ripe is causing issues.

Thanks,
Hank

Hi Hank,

The webpage is restricted to a maximum of 10 pages with 10 matches on each page, but if you don't mind reading XML or JSON you can make the call directly:

XML: https://apps.db.ripe.net/db-web-ui/api/rest/fulltextsearch/select?facet=true&hl=true&q=(TEST)&start=0&rows=800
JSON: https://apps.db.ripe.net/db-web-ui/api/rest/fulltextsearch/select.json?facet=true&hl=true&q=(TEST)&start=0&rows=100

In this example I'm searching for "TEST". Add a "rows" query parameter to limit matches, and ".json" to the end of the path to specify a JSON response.

The upcoming Whois 1.101 release exposes this API directly via https://rest.db.ripe.net/ and we will document it fully.

Also we plan to improve the query page in the coming months, we will look at integrating full text search and allowing more results.

Regards
Ed Shryane
RIPE NCC

On 17 Jun 2021, at 18:45, Hank Nussbacher via db-wg <db-wg@ripe.net> wrote:

I am using https://apps.db.ripe.net/db-web-ui/fulltextsearch to do a full text search to return just the inetnum record but if I get 800 hits I get only 10 entries per screen.

How can I see all 800 hits at once?

Thanks for any clue provided.

Regards,
Hank