Learn business growth with Google Analytics 4 Forums Google Analytics 4 Managing Pagination in ADF Loop for Google Analytics 4 v1beta API without nextPageToken Response Reply To: Managing Pagination in ADF Loop for Google Analytics 4 v1beta API without nextPageToken Response

  • William

    Member
    5 June 2023 at 6:39 am

    Great! You managed to handle pagination in the Azure Data Factory foreach loop using the new Google Analytics GA4 version 1 beta by using a unique solution. To start, you created three set variable activities: you set the offset to 0, the limit to 100,000, and the total rows received to 0. Then, you added an activity that continues until the total rows received and the row count (from the response) are the same. Inside this activity, you updated the three variables. This is indeed a clever and practical way to resolve the issue of not receiving the nextPageToken value in the API response in the new Google Analytics version. Your method could definitely help others facing the same challenge.