in sonic-build/routes/kusto.js [18:46]
async function test_queryBuilds(){
var url = "https://dev.azure.com/mssonic/build/_apis/build/definitions?api-version=6.0&includeAllProperties=true";
var definitionsRes = await request('GET', url);
var definitions = JSON.parse(definitionsRes);
var results = {};
//Sequence, DefinitionId, DefinitionName, Platform, SourceBranch
var rows = [];
for (var i=0; i<definitions.value.length; i++){
var row = [];
var definition = definitions.value[i];
if (definition.path.startsWith("\\selftest") || definition.path.startsWith("\\fips")){
continue;
}
var platform =definition.name.startsWith("Azure.sonic-buildimage.official.") ? definition.name.substring(32) : "";
row.push(rows.length+1);
row.push(definition.id);
row.push(definition.name);
row.push(platform);
row.push(definition.repository.defaultBranch);
rows.push(row);
}
rows.sort((a, b) => a[2].localeCompare(b[2]));
for (var i=0; i<rows.length; i++){
rows[i][0] = i+1;
}
results['_rows'] = rows;
return results;
}