Query reference fields through GET API

[nidhi_hassan]

I'm trying to use Postman to query a table. One of the fields is a reference to another table. And I want to filter the resultset for a value in that table. How do I set the Qurey parameter to get the desired result?

I'm trying this query below. But not getting any results.

/api/now/table/{tableName}?sysparm_fields=u_company={sys_id}

[AshishKM]

Hi @nidhi_hassan , 

Please share the tableName and column name ( reference to another table ). 

Also, you can share the current result, with details , which part you are applying filter.

If "u_company" is the reference column in the table "you are applying the REST API" then add more sysparm_fields which are part of this "tableName".

-Thanks,

AshishKM