AnsweredAssumed Answered

Lookback API Efficiency - querying for n stories

Question asked by kjmorton on Jul 10, 2018
Latest reply on Jul 10, 2018 by Sagi_Gabay

Hi

 

So I am tasked with running a query for a large list of n formatted ID strings. Below, I have outlined how I am currently running the query. I have noticed the query takes anywhere from 0.5-2 seconds per formatted ID.

 

I am wondering if there is a faster method of querying for a large number n of strings.

LookbackApi lookbackApi = new LookbackApi(); lookbackApi.setCredentials("myusername", "mypassword"); lookbackApi.setWorkspace("myworkspace");

LookbackQuery query = lookbackApi.newSnapshotQuery();

query.setPagesize(20000)
      .setStart(0)
      .requireFields("ScheduleState", "FormattedID", "_ValidFrom", "Blocked", "Project")
      .sortBy("_ValidFrom")
     .hydrateFields("ScheduleState", "Project");

for(String formattedID : list) {
    query.addFindClause("FormattedID", formattedID);
    query.execute();
    // process the query results
}

 

Appreciate any info you can provide!

Outcomes