Good Morning,
I am having an issue where I am only able to export a single review to google sheets. I am trying to receive multiple while using the next page token for the pagination method. I am only receiving one review which is the last review on the first page. When I turn off the pagination settings I am receiving the same response. In total there should be 856 reviews.
Thank you for any and all help.
Handlebar Template:
{
"values": [
{{#each data}}
["{{reviewId}}", "{{createTime}}", "{{displayName}}"]
{{#unless @last}},{{/unless}}{{/each}}
]
}
Ending relative URI for google Sheets:
/values/Sheet1!A:N:append?valueInputOption=RAW&insertDataOption=INSERT_ROWS