Query Contacts

https://developers.wrike.com/api/v4/contacts/#query-contacts

On Wrike's developer site, it lists a custom field filter, I have never been able to get this to work or identify a path forward.

The goal is to query profiles.email or primaryEmail, to look up a Wrike Contact ID by Email.

I have seen numerous posts saying the only way to filter a contact like this is to GET all contacts and filter after pulling everyone.

The issue is that we have over a quarter of a million contact ids, its way to much data to filter in this fashion.

But at the same time Wrike's API Documentation makes it seem like its possible?

It asks about finding the customFieldId, so how do I look up the customFieldId for profiles.email or primaryEmail? its almost like its not supposed to be there?

Find more posts tagged with

Comments

Gretchen Linder

I had this issue with the user custom fields. You can include the user custom field's ID and value by adding this parameter to the contacts statement: ?fields=[customFields]. The complete statement looks like this: https://www.wrike.com/api/v4/contacts?fields=[customFields].

You can get the user custom field's title by adding this parameter to the customfields statement: ?applicableEntityTypes=["WorkItem", "User"]. I tried isolating the "User" fields only, but was unsuccessful. the complete statement looks like this: https://www.wrike.com/api/v4/customfields?applicableEntityTypes=["WorkItem", "User"]. I used this statement to grab the ID for the field I'm using in reporting.

The email and primary email columns are not included as available parameters in the developer's info, and both failed when I tried to use them.

Hope this offers a little help.

-g.

EnterpriseIT ServiceAccounts

It's unbelievable that the Wrike REST API doesn't allow partial name/email searches in the API like they do in the Web application...

Basudha Sakshyarika

Thank you for the post, @Mike Luedtke. I see you have already discussed this query with our support team. Let me know if you need further assistance. 🤝

Thank you, @Gretchen Linder. I really appreciate you jumping in to help. 😊

@EnterpriseIT ServiceAccounts, I will forward your feedback to our engineering team. If you have any specific questions that you would like to discuss with our support team, please feel free to let us know. 👍🏽

Mike Luedtke

I have discussed it, but there has not been any traction on implementing a enhancement or fix.

I was hoping that it was possible given I saw the customFields filter but from what Gretchen Linder said its not something that enables us to look up a wrike contact id via their email address.

I have seen it on other parts of the forum where Wrike's official guidance is to grab all of the contacts then parse it on your own.

but I can't even tell you how many contacts my organization has due to the size, I know when I attempt to get and parse this data the file is so big it crashes most developer tools, I do know the JSON is over 5 million lines.

My solution is to every few months dump the 5,00,000+ lines of json and create a look up table in a different SaaS, I have to do this manually because this tool does not even permit handling REST Payloads that size, even Postman will crash under the sheer weight of the get all contacts most of the time and this is after I have to override maximum size and timeout.

This still causes issues 5% of the time because of turnover and new hires between the first and last dump of the data.

I am optimistic that this can be fixed and an enhancement can be made, but given this has been brought up for years on the forum it feels unlikely to ever be completed.

Basudha Sakshyarika

Hello @Mike Luedtke! 🙋🏻‍♀️ Thank you for sharing the details. Your feedback is already with our product team, and they are still assessing it. We will let you know if there's any update regarding it. Thank you 👍🏽