Add more endpoint focused in dashboard with totals

Hi @viktorbenei,
I builded a new dashboard on Google Data Studio with Spreedsheet, but i wanted only count of all builds of each apps without pagging and with period time, because this way would more easy to obtain.

It is possible to add in the future?! Please, can you change this limit of 50? Or offer other endpoint with only this parameters, i believe that is very useful for all devs.

Thanks.

Hi @ipirangamobile,

Thanks for the #feature-request!

May I ask what the use case for this would be? Just to be sure we get the right idea.

  • What data exactly you’d want to get / visualise?
  • For what would you use this data?

Also, do you mean something like a dashboard described here: Build dashboard / Build Time Trend / Stats / Analytics or rather just a one-time report which you could generate?

I’d suggest you to just share a use case, step by step (as much as possible) so that we (and others who read this #feature-request ) will understand exactly what this feature would do (what we have to implement and how it would work). :slight_smile:

This is the dashboard we builded with API

For to build this dashboard, we used the ImportJSON project (GitHub - bradjasper/ImportJSON: Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet) for Google Spreedsheet, and after that, we added the follow script to add the authentication

function ImportJSONTokenAuthentication(url, query, parseOptions, token) {
   var fetchOptions = {
      "headers" : {
        "Authorization" : 'token ' + token
      },
      muteHttpExceptions: true
   };

  return ImportJSONAdvanced(url, fetchOptions, query, parseOptions, includeXPath_, defaultTransform_);
}

After this code, we created other layer of code, in bitriseFunctions.gs
You can view more in: GitHub - rennanc/BitriseGoogleSheets: Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet .

With Spreedsheet generated with informations, we loaded this file in Google Data Studio.

  1. What data exactly you’d want to get / visualise?
    I need the follow itens in response:
  • Total of builds
  • Total of builds of each app with status and platform type
  • Period max would be 12 months.
  1. For what would you use this data?
    This is necessary for DevOps team because we need to monitor de quality of development, the need of upgrade the plan of bitrise, and points of attention as deploy being sent with errors. We need demonstrate to management the need to increase the plan.
1 Like

Got it, thanks for the details and for the scripts @ippMobile! :slight_smile:

P.S.: you can use pagination to fetch more than 50 items of any list endpoint.

Also, don’t forget to vote on your feature request to bump its priority @ippMobile! :wink:

1 Like

Ok :wink:, this affirmation that i needed, thanks. :sunglasses:

1 Like