Need Help Extracting Entire List of Projects from Workfront API | Adobe Higher Education
Skip to main content
P
prashantdhoke23
Level 2
September 26, 2023
Respondido

Need Help Extracting Entire List of Projects from Workfront API

  • September 26, 2023
  • 1 resposta
  • 1428 Visualizações

 

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?

 

Este tópico foi fechado para respostas.
Melhor resposta por 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 Resposta

C
cvergesResposta
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
    prashantdhoke23Autor
    Level 2
    October 4, 2023

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

    Termos e condiçõesAccessibility statement

    Loading footer...