Hey Robert,
Regarding the second part of your question, you can filter with the API on multiple fields with AND / OR clauses and operators, same as you do with regular SQL filters. You can try it out in the API docs by entering your query string in the filter field e.g., age > 5 AND state = “MA”