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!