# nextPageToken Pagination not working correctly

**URL:** <https://connective.celigo.com/t/nextpagetoken-pagination-not-working-correctly/503>\
**Category:** Integrator.io\
**Tags:** pagination, http, google-sheets\
**Created:** [March 29, 2023, 7:15pm UTC](https://connective.celigo.com/t/nextpagetoken-pagination-not-working-correctly/503 "2023-03-29T19:15:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shadnerjoseph](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@shadnerjoseph](https://connective.celigo.com/u/shadnerjoseph)\
**Post date:** [March 29, 2023, 7:15pm UTC](https://connective.celigo.com/t/nextpagetoken-pagination-not-working-correctly/503/1 "2023-03-29T19:15:57Z")

</div>

Good Afternoon,

I have set up a http connection between Google My Business API to google sheets and I am trying to set up the nextPageToken but I am unsuccessful. I am only retrieving the last review of the first page. I included "{{export.http.paging.token}}" in the "HTTP request body" as required and "/nextPageToken" in the "Path to next page token field in HTTP response body\*". Thank you for any and all help! I am including screenshots below.

 ![5301043caa20740200000001-e0946124b9164bfe948d1a9749d7eaea.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/57ae8ee9afa470304ed420036b01ae723e84a38a.png)

Beginning of response:

 ![5301043caa20740200000001-a8cd6849a3444d85a2a716c99bcbc66b.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/278541229dd0ebf49c1db03543bd9637705db2ab.png)

Bottom of response:

 ![5301043caa20740200000001-b98e027c167a45b0a671cf07e275c043.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/0291374c386c344bd9ee735820e929c6c4d8aea8.png)

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [March 29, 2023, 9:45pm UTC](https://connective.celigo.com/t/nextpagetoken-pagination-not-working-correctly/503/2 "2023-03-29T21:45:31Z")

</div>

@shadnerjoseph I'm not able to test this since I don't have a google my business account, but I reviewed the docs and it looks like the setup should be something like this:

 ![5301043caa20740200000001-5e677a73fdcc4922a929b53d913fe64c.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/38788c926e5b6ba72d618b3ee94b5b3536ffc48e.png)