airtable-retry-logic.py

class AirtableClient:
    # ...

    def request(self, method, *args, **kwargs):
        # ...
        retries = 0
        wait = 30
        while True:
            response = self.session.request(method, *args, headers=headers, **kwargs)
            if response.status_code != 429 or retries == 3:
                break
            retries += 1
            log.warn(
                "http 429 response from airtable, retry after wait",
                retry=retries,
                wait=wait,
            )
            time.sleep(wait)
            wait = math.ceil(wait * 1.5)
        response.raise_for_status()
        time.sleep(1 / self.requests_per_second_limit)
        return response