The Problem:

When an API call is made to read or update a record that does not exist, a 401 is returned with the following message in the body:

DENIED!!! - Record: 99999 either does not exist or you do not have access to it.

Either scenario described in the error message would better fit for a 403 (forbidden) or a 404 (resource not found) instead of a 401 (unauthorized).

The reason this is a problem is because now if a record does not exist and a 401 is returned, it makes it difficult to programmatically determine if the record simply does not exist, or if the credentials to access it are not valid or have expired (a genuine 401).

I've gotten around this so far by reading the error message string and checking for words or phrases that let me know what happened - but this is brittle and can be non-deterministic.

Should that error message change some of my logic would break, but I need a way to tell if the record simply doesn't exist, or if my token expired and I need to exchange my credentials for a new one before retrying.

Proposed solution:

Return a 404 or 403 depending on the result of the request, and only return a 401 if credentials are invalid.

Thanks!

Long time developer but I'm new to this API and trying to figure out the easiest way to do this:

I need to get a list of records that have a value greater than 100 for our field "Show Q #'.

Then for each of those records I want to download the image that is associated with that record.

I assume I need to do the following:
1. Get OAUTH so I have the access token.
2. I already know the view number so I would call:
GET /openapi/views/{viewId}/find

The problem is I don't know what the "q" parameter should be. I can find ALL the records using one of the other GET View operations but I haven't figured out how to use this filtering command. It doesn't seem to want to filter on our field.

How do I filter based on our field?

What's the best SDK to use for this purpose? I was thinking of Javascript.

Can someone provide a simple example of how to download the images (field is Image1) for a list of filtered records of a view?

Thanks,

John

We would like to know how we can either:

1) ONLY find records in a specific view that exactly match our query string, and/or
2) Find records by looking for our query string within a given FIELD within the specified view.

With respect to #1 above we're running into some issues. For example, when searching for "John Doe - 123-456-7890" we ONLY want to find records that have our exact query string in a specific field within that view. But the TrackVia API is returning every record that has even one piece of our query string -- for instance, it's returning multiple records where "John Doe" appears and/or the phone number only "123-456-7890". This makes it difficult to lookup a specific, unique record without that record's Record ID.

With respect to #2, if there's a way to query a specific field/column WITHIN the view -- that might bring us closer to what we need. That way, at least we would be limiting the broadly matched queries within a specific field we can target, instead of scanning the entire table.

Can you please advise how we can accomplish these objectives? Thank you!