Queries on Workfront API to get project data. | Community
Skip to main content
S
SivatejaReddy_NVS
November 6, 2023
Question

Queries on Workfront API to get project data.

  • November 6, 2023
  • 1 reply
  • 2424 views

Query 1:

By default, the below API is returning only a few fields/attributes of the specific project:

https://{mydomain}.my.workfront.com/attask/api/v17.0/project/***********?sessionID=*************

 

Is there an option to get all the fields/attributes of the given project?

 

Query 2:

How to get all comments/stausUpdates of the project?

By default is it returning only one/first comment with the below API:

 

https://{mydomain}.my.workfront.com/attask/api/v17.0/project/**************?sessionID=*************&fields=statusUpdate

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

lgaertner
lgaertner
November 6, 2023

Hello,

 

First of all, you need to be careful posting such links, as you only anonymized the link text, but not the link itself.
So it still contains your session key.

 

Query 1:

You have to add fields=* to your query like this:
https://urldefense.com/v3/__https:/novartisgbs.my.workfront.com/attask/api/v17.0/project/<projectID>?sessionID=<sessionID>&fields=* 

I you have custom fields you should also add parameterValues.

 

https://urldefense.com/v3/__https:/novartisgbs.my.workfront.com/attask/api/v17.0/project/<projectID>?sessionID=<sessionID>&fields=*,parameterValues

 

 

Query 2: 

 

To get all comments / statusUpdates doing  a search should help:

 

https://urldefense.com/v3/__https:/novartisgbs.my.workfront.com/attask/api/v17.0/project/search?ID=<projectID>&sessionID=<sessionID>&fields=statusUpdate 

 

Regards

Lars

S
SivatejaReddy_NVSAuthor
November 6, 2023

Hi 

 

Thanks for the quick reply and tip regarding the token, I've invalidated the token and also edited the post to remove any references.

 

Coming to my queries, the first one is resolved. I'm able to get all the fields using * 

 

But the second one regarding the comments, it's still not clear to me.

The link you've given just taking back me to my post.

Using "fields=statusUpdate" returns only the first comment but not all.

 

Can give me a sample to get all the fields?

 

S
SivatejaReddy_NVSAuthor
November 6, 2023

Hi,

 

the second should look like this:

https:/novartisgbs.my.workfront.com/attask/api/v17.0/proj/search?id=<projectID>&fields=statusUpdate,updates&sessionID=<sessionID>

 

Regards

Lars


Hi,

 

Still, no luck, tried with "fields:statusUpdate,updates", but still getting only one comment, the only change I observed with updates in the field is it is returning "System Activity".

 

Let me explain:

For one of the projects, there is a comment and there are two replies to that comment, please see below:

However the API is responding with only the first comment, but not the replies.

Terms & ConditionsAccessibility statement

Loading footer...