Skip to main content

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

 

 

Hi ​@Hereward Holmes 
 

While you're waiting on insights from other community members, I recommend checking out the following articles to get a deeper understanding:

AdaptiveWork Functions - ObjectReference

AdaptiveWork Relations - Customers

These resources provide helpful details on how object references and customer relationships are managed in AdaptiveWork, which might shed some light on your current issue.

Hope this helps!


Reply