Is it possible to return the name of a project’s related customer when querying the project via the API?  I believe the relationship is between project, customerlink and customer.  However, I can’t see how to relate customerlink to project as I get the following error:

Query:

https://api.clarizen.com/v2.0/services/data/query?q=SELECT name, sysid, customerlink.customer.name FROM project WHERE id = '<PROJECT ID HERE>'

And got this result:

    "errorCode": "InvalidField",
    "message": "Entity 'Project' does not contain the field 'customerlink'",

When I try to query the customerlink with the same project ID using:

SELECT customer.name, entity.name FROM customerlink WHERE entity = '<PROJECT ID HERE>'

Then I get the name from the customer table and the name from the project table.  I just don’t seem to be able to get the customer name by querying the project table

I’ve had this problem with other entities, specifically when trying to link tasks with files/attachments.

If anyone has any insights they could share it would be appreciated, particularly if this is even possible.

Many thanks

H