Since it doesn't seem to be possible to pull data directly from a report, I am trying to use the API to get all the tasks that fit certain conditions, and one of those conditions is that a custom field, called Date Booked, is not null. However, when I put "project:DE:Date Booked_Mod=notnull" into the URL, I get this error message:
{"error":{"message":"Invalid Parameter: Search Parameter value \"project:DE:Date Booked\"","title":null,"msgKey":"exception.attask","attributes":[""],"code":0}}
Is what I'm doing possible, and if so, what am I doing wrong? Either way, please let me know.
Thank you.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
There isn't enough information here to do any kind of troubleshooting.
What is the API call you're trying to use? From your description, you're trying to pull tasks by filtering for a project field.
Why can't you pull the data from a standard report?
Views
Replies
Total Likes
I think it might just be a syntax issue? Instead try
&DE:project:YourFieldName_Mod=notnull
That didn't work for me either.
Views
Replies
Total Likes
As Randy mentioned, you might get a bit further if you post the call. Are you getting the same/similar error message or has something else changed?
Views
Replies
Total Likes
The URL looks like this, but I have deleted the API key for security reasons:
I believe the problem is that project(DE:[any custom field]) cannot be reached from a task-level API call. That's what I'm trying to find out.
Views
Replies
Total Likes
I was researching API in community the other day and realized this was never answered. So, just circling back on this one to confirm that the syntax for the project custom field was correct for me. The following would have worked.
&DE:project:your field name_Mod=notnull
If you went with a straight search on that one thing, my guess is it would work for you as well. https://citlabels.my.workfront.com/attask/api/v16.0/task/search?apiKey=apiKey&method=GET&DE:project:...
In other words, is it possible one of the other search strings is affecting your result? I did observe your other field name had slashes in the field name (booklet/label number). We have a policy of avoiding special characters in field names for exactly this reason (unpredictable results in an API call), so I'm not as familiar with that your options are here. The quickest fix would have been to rename your WF fields to remove all the slashes and then try and pass this call again.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies