Thanks for replying. I knew the usage of page_size but it's not convenient if we want to get a specific range with variable start index.
Hope Goolgle consider to add the offset support in GAQL, anyways... thanks again! On Friday, January 7, 2022 at 2:28:46 a.m. UTC-5 adsapi wrote: > Hi, > > Thanks for reaching out to us. > > Note that LIMIT with offset is not supported in GAQL. An equivalent way to > achieve this using pagination. The pagination uses pageSize by specifying > page_size > <https://developers.google.com/google-ads/api/reference/rpc/v9/SearchGoogleAdsRequest#page_size> > > in your request. This will break up the result set of the query into > multiple responses that each contain up to page_size > <https://developers.google.com/google-ads/api/reference/rpc/v9/SearchGoogleAdsRequest#page_size> > > objects. If page_size > <https://developers.google.com/google-ads/api/reference/rpc/v9/SearchGoogleAdsRequest#page_size> > > is not specified, it is automatically set to the maximum page size of > 10,000 rows. > > Suppose if your account contains 50,000 keywords and page_size > <https://developers.google.com/google-ads/api/reference/rpc/v9/SearchGoogleAdsRequest#page_size> > > is set to 1,000, the result set will contain 1,000 GoogleAdsRow > <https://developers.google.com/google-ads/api/reference/rpc/v9/GoogleAdsRow> > objects in the first response, along with a next_page_token > <https://developers.google.com/google-ads/api/reference/rpc/v9/SearchGoogleAdsRequest#next_page_token>. > > To retrieve the next one thousand rows, simply send the request again with > the same page size, but update the request's page_token to the response's > next_page_token > <https://developers.google.com/google-ads/api/reference/rpc/v9/SearchGoogleAdsRequest#next_page_token>. > > The value of page_size > <https://developers.google.com/google-ads/api/reference/rpc/v9/SearchGoogleAdsRequest#page_size> > > in the subsequent requests can be different each time. The next_page_token > <https://developers.google.com/google-ads/api/reference/rpc/v9/SearchGoogleAdsRequest#next_page_token> > > will not be populated on the response that contains the last batch of > rows. For more information on paging, you may refer to this guide > <https://developers.google.com/google-ads/api/docs/reporting/paging>. Let > us know if you have any further questions. > > Regards, > [image: Google Logo] > Yasar > Google Ads API Team > > > ref:_00D1U1174p._5004Q2UhT68:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/a7b4fc16-c8e1-4f2b-a4ec-25fce611587cn%40googlegroups.com.
