Forum Discussion

BeauPowell's avatar
BeauPowell
Qrew Member
3 years ago

QuickBase API Query - filter results based on User Emails

Hi all - First time posting here. Thanks in advance! I am working with the QuickBase API using a tool called Data Fetcher (which is an integration in AirTable). I am struggling to find a way to fil...
APIs and custom code
SeanConnaughto1's avatar
SeanConnaughto1
Qrew Cadet
3 years ago
Hi Beau,

If you have the email address you want to filter with using field ID 35, you can use the HAS query:

{
"from": "TABLEIDHERE",
"where": "({36.IR.'today'}OR{36.IR.'yesterday'}) AND ({35.HAS.'rudolphemail@email.com'}OR{35.HAS.'jackemail@email.com'})",
"select": [
3,
3148,
3143,
3133,
36,
35,
401,
3149,
3147,
3130
],
"sortBy": [
{
"order": "DESC",
"fieldId": 36
}
],
"options": {
"top": 0,
"skip": 0,
"compareWithAppLocalTime": false
}
}

I hope that works! Let me know if not.

Here is a snippet of the documentation on the HAS Query:

HAS

Contains a specific set of users. Used with list-user fields only.

For each user you are trying to find, you must enter the user's ID, user name, or email address. You can also enter placeholder names. Be sure to surround placeholder names with double quotes.

The query parameter must be surrounded by single quotes.

Separate users in the list using a semi-colon.

For example:

<query>{'6'.HAS.'-8675309; -9873297'}</query>


------------------------------
Sean Connaughton
------------------------------
  • BeauPowell's avatar
    BeauPowell
    Qrew Member
    3 years ago
    Hi Sean,

    Thanks for the response! I did try this though and the query doesn't return any results. When I use the query I posted in my original post, I get a response of 6 results. The response does include all of the user properties as (35 value ID, 35 value email, 35 value name). I took one of the emails included in the response and modified my query using the HAS operator instead, and I get no results!

    Beau

    ------------------------------
    Beau Powell
    ------------------------------