Getting all organizations with v1/organizations endpoint

API
1

Hey, i’m trying to get all of the existing organizations, this is the code i’m using to process this

var sheet_orga = ss.getSheetByName('Orga/ID');
var token ='XXXXX'; 

var url_orga = "https://company.pipedrive.com/api/v1/organizations?api_token="+token;
var response_orga = UrlFetchApp.fetch(url_orga); 
var dataSet_orga = JSON.parse(response_orga.getContentText()); 

function GetOrga(){

  for (var i = 0; i < dataSet_orga.data.length; i++) {
    data_orga = dataSet_orga.data[i];
    sheet_orga.appendRow([data_orga.id, data_orga.name, data_orga.owner_id]);
  }
};

the problem is that it only retuns me the first 100 organizations and we have like 5000. Any idea of how i can get all of them ?

2

Hey @JuloSancho
This wiki might be helpful. By default all API responses are paginated. You need to provide the page number in the subsequent requests to get all data