How to loop through all offsets en get all results from HubSpot

[TDwebdev]

Hello,

I want loop through all companies and make one list of all 3000 companies.

My code:

    $api_key = $this->api_key();

        // Get companies

        $url = "https://api.hubapi.com/companies/v2/companies/paged?limit=250&properties=relationcode&offset=68858&h..." . $api_key;

        $ch = curl_init();

        curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "GET");

        curl_setopt($ch, CURLOPT_URL, $url);

        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

        // Get result after POST

        $result = curl_exec($ch);

        // Convert the JSON result to a array

        $result_back = json_decode($result);

        $companys = $result_back->companies;

           echo "<pre>";

           print_r($result_back);

           echo "</pre>";

        return $companys;

[TDwebdev · Accepted solution]

I fixed the problem with the while loop :

        $offset = 0;
        $hasMore = true;

        while ($hasMore === true) {
           //Add the API call in the while loop with the $offset in the url
            $url = "https://api.hubapi.com/deals/v1/deal/paged?Associations=true&limit=250&offset=".$offset."&hapikey=" . $api_key;
            $offset = $result_back['offset'];
            $hasMore = $result_back['hasMore'];

        }

[dennisedson]

@TDwebdev 

You should get a paging object in your return.  Within that, you will use the link value to append to the uri for a new call. 

Example of the object:

"paging": {
    "next": {
      "after": "NTI1Cg%3D%3D",
      "link": "?after=NTI1Cg%3D%3D"
    }
  }