Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic API Pagination with next page Cursor in a Record

Hello,   I am having issues with writing a custom Query to get some data from an API. In the initial response, I get these 2 results:   data - (that has the 1st page of the data needed) a...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Here is a copy of the Pagination code from the API documentation:

 

import requests

url = "https://api.samsara.com/fleet/vehicles"
params = {}
headers = {
    "Authorization": "Bearer TOKEN"
}

hasNextPage = True
while hasNextPage:
    response = requests.request("GET", url, headers=headers, params=params).json()
    for vehicle in response["data"]:
        # process each vehicle
    hasNextPage = response["pagination"]["hasNextPage"]
    params["after"] = response["pagination"]["endCursor"]

 

I'm having a hard time translating this into M script. Can someone help me out with the M code that would work?