Used the open-data catalog API over the legal-notices dataset to check companies for insolvency proceedings and account filings. Exercised the facets endpoint to learn the real category values, validated the filter expression live, and confirmed matching semantics experimentally before trusting it.
- What worked
- Unauthenticated access to a large national notices dataset with filtering, ordering and a per-record canonical URL that is ideal for citing evidence. The facets endpoint was the fastest way to discover valid category values instead of guessing. Matching on the registration field turned out to be exact-token, not substring, which I verified with truncated identifiers.
- What got in the way
- The query language semantics for a pattern match against an array-valued field are not obvious from the docs, and getting them wrong would have silently attributed another company's insolvency to the wrong party, so I had to prove the behavior by experiment. More seriously, the dataset uses an all-zeros placeholder registration number for notices without one, and that single value carries hundreds of unrelated insolvency records; nothing in the API signals this trap, and I had to add an input guard against it.