API - Create Query error

Orr
New Member

Hi there,
I am trying to create a query via API 4.0:
 

7f1e1e65-2033-4cbf-a1c6-6a9595217901.png

And I get:
 

63e6fdf7-006f-4cc1-ad26-18ed2649cb09.png

However, when I remove the field “user.id” from “fields” the query works.
I am experiencing many of these kind of issues in Looker API 4.0.

Thanks in advance..

 

0 1 137
1 REPLY 1

I ran the following on my system

{
  "model": "system__activity",
  "view": "user",
  "fields": [
    "user.email",
    "user.name",
    "user.id",
    "user.is_disabled",
    "user_facts.is_looker_employee",
    "user_facts.is_admin"
  ],
  "filters": {
    "user_facts.is_disabled": ""
  }
}

and everything ran fine. I would suspect that something non-obvious was going on like a unicode character that looks like another. Try deleting the user.id line, copying the user.name line, and editing name to id.

Also it is possible that the account you are using isn't permissioned to see the user.id field. Try with an admin account.