TrackVia should really improve their API

As of the writing of this article, they don’t provide a means of looking up:

  • Records by Field within a View
  • Records by exact match query string

The search functionality they do provide (GET /openapi/views/{viewId}/find) is difficult at best, because this (inconsistently) returns partial matches and close variants.

For example, if you search for a record containing the exact string “Steven Fies – 123-456-7890” (keeping in mind you can’t search by field/column) — TrackVia’s API may also return things like “Steve Fies – 567-890-1234” and “John Doe – 123-456-7890”.

Not to mention, those partial matches and variants may reside in other fields (columns) that you don’t intend to target or query.

Without getting into a huge explanation, here’s an easy JavaScript solution that I coded today:

You will probably need to adjust the code to work with your specific application, but hopefully this will save you some time at least.

Share This Article:

Liked this article? Sign up for more.

Steve believes your greatest creation happens when you combine art and science. Join his 10K+ followers on social media and email today.

100% Privacy. No spam. Unsubscribe anytime.

Related Posts

2 thoughts on “Find records in TrackVia API without the Record ID

  • Hey, I like your blog and you have written this particular topic very competently. A few questions for you… What programming languages should I for web development? What would say are the five essential skills every web developer should have? What is the difference between web development and web design? Thanks!

    • Emmet, not sure if this is a real comment or not (my apologies if so, but it just doesn’t seem entirely on topic)… nonetheless, here are my answers to your questions: 1) You should probably begin with a “light” stack of HTML, CSS, JS, PHP, and SQL. 2) I’ll give you three: creativity, patience, and good communication skills. 3) Design is the creative/visual aspect (layouts, colors, look and feel) whereas development is the coding and engineering behind the scenes that makes it all happen. Same concept as architectural design and engineering, or bridge design and engineering, for example.

Leave a Reply