Get jobs Activity of last 43-days

Help Studio
1

I am using a get job activity, and I am using a use Expression in a filter. I want to get jobs from the last 43 days to today’s date using the expression
"StartTime gt " + Now.AddDays(-42).ToString(“yyyy-MM-ddTHH:mm:ss.fffZ”) +
" and StartTime lt " + Now.ToString(“yyyy-MM-ddTHH:mm:ss.fffZ”)

Its just give me a 43-day job, are there any restrictions to get only 100 jobs or 1-day jobs? want a solution that gives me a job from the past 43 days to today’s date

Forum Engagement Daily Reports
2

@Muhammad_Imran_Hashmi

100 is the maximum jobs it returns

you need to write logic to loop and extract all the jobs ..

get jobs has a property skip ..which can be leveraged

now steps

  1. initiliaze vartotalreturned = List(Of Jobs)
  2. do while loop with get jobs inside it and skip give vartotalreturned.count
  3. assign with varTotalreturned = varTotalreturned.Concat(varreturned)
  4. Do while condition is (vartotalreturned.count mod 100) = 0

cheers

3

Hi @Muhammad_Imran_Hashmi

get Jobs returns max 100 per call, so use paging.
Filter example:
StartTime gt " + Now.AddDays(-43).ToString(“yyyy-MM-ddTHH:mm:ss.fffZ”) +
" and StartTime lt " + Now.ToString(“yyyy-MM-ddTHH:mm:ss.fffZ”)

Set Top=100 and increase Skip (0,100,200…) until no more results.

Happy Automation

4

Get Jobs activity returns a maximum of 100 records per request due to OData pagination limits. Since you are trying to retrieve jobs for a larger date range (for example, the last 43 days), you will only receive the first 100 records unless you implement pagination logic.

To fetch all jobs, you must use the Top and Skip properties inside a loop. Initialize a master list to store all jobs, call Get Jobs with Top = 100 and increment Skip by 100 after each iteration, then append the returned batch to your total list.

  • First Initialize :
    varTotalReturned = New List(Of Job)
* Then Use a **Do While** loop:
* Inside the loop, use **Get Jobs**
* Set **Skip = varTotalReturned.Count**
* Store result in `varReturned`
* Append results:

varTotalReturned = varTotalReturned.Concat(varReturned).ToList

Loop condition:

Do While (varTotalReturned.Count Mod 100) = 0

The loop should continue while the current batch count equals 100, which ensures more records exist.
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.