Need Help Extracting Entire List of Projects from Workfront API | Community
Skip to main content
P
prashantdhoke23
Level 2
September 26, 2023
Solved

Need Help Extracting Entire List of Projects from Workfront API

  • September 26, 2023
  • 1 reply
  • 1428 views

 

I'm currently working on extracting project details from Workfront using the API. I've tried using the endpoint https://*.my.workfront.com/attask/api/v15.0/proj/search, but it seems to only return completed projects. I need to retrieve the entire list of projects from the Project Dashboard in Workfront.

Could someone please provide me with the correct API endpoint or method to achieve this?

 

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

We use Fusion and use a combination of 3 modules:

  1. Count the number of projects using a proj/count call with no filters on it
  2. Repeater between 0 and min(10000;ceil(count/2000))
  3. Search a page using proj/search call with $$FIRST=i*2000 and $$LIMIT=2000 and entryDate_1_Sort=asc and ID_2_Sort=asc and fields=*,parameterValues:*

Note that Workfront's pagination support suffers from the known offset/limit problem when simultaneous modification occurs, so you do have to be aware of this potential behavior.  (I filed an enhancement ticket in the forums here to request a more proper cursor-based pagination mechanism.)

Hope this helps!

1 reply

C
cvergesAccepted solution
Level 5
September 26, 2023

We use Fusion and use a combination of 3 modules:

  1. Count the number of projects using a proj/count call with no filters on it
  2. Repeater between 0 and min(10000;ceil(count/2000))
  3. Search a page using proj/search call with $$FIRST=i*2000 and $$LIMIT=2000 and entryDate_1_Sort=asc and ID_2_Sort=asc and fields=*,parameterValues:*

Note that Workfront's pagination support suffers from the known offset/limit problem when simultaneous modification occurs, so you do have to be aware of this potential behavior.  (I filed an enhancement ticket in the forums here to request a more proper cursor-based pagination mechanism.)

Hope this helps!

    P
    prashantdhoke23Author
    Level 2
    October 4, 2023

    Thanks, @cverges, this helps me to extract the entire list of projects through Workfront API.

    Terms & ConditionsAccessibility statement

    Loading footer...