Addresses the following bug which occurred in automation.pdap.io:
Traceback (most recent call last):
File "/var/lib/jenkins/workspace/Data Sources Mirror/mirror.py", line 389, in <module>
full_mirror_to_digital_ocean()
File "/var/lib/jenkins/workspace/Data Sources Mirror/mirror.py", line 24, in full_mirror_to_digital_ocean
data = get_full_table_data(table)
File "/var/lib/jenkins/workspace/Data Sources Mirror/mirror.py", line 42, in get_full_table_data
data = api.table(
File "/usr/local/lib/python3.9/site-packages/pyairtable/api/table.py", line 263, in all
return [record for page in self.iterate(**options) for record in page]
File "/usr/local/lib/python3.9/site-packages/pyairtable/api/table.py", line 263, in <listcomp>
return [record for page in self.iterate(**options) for record in page]
File "/usr/local/lib/python3.9/site-packages/pyairtable/api/table.py", line 233, in iterate
for page in self.api.iterate_requests(
File "/usr/local/lib/python3.9/site-packages/pyairtable/api/api.py", line 301, in iterate_requests
response = self.request(method, url, fallback=fallback, options=options)
File "/usr/local/lib/python3.9/site-packages/pyairtable/api/api.py", line 251, in request
return self._process_response(response)
File "/usr/local/lib/python3.9/site-packages/pyairtable/api/api.py", line 265, in _process_response
raise exc
File "/usr/local/lib/python3.9/site-packages/pyairtable/api/api.py", line 255, in _process_response
response.raise_for_status()
File "/usr/local/lib/python3.9/site-packages/requests/models.py", line 1024, in raise_for_status
raise HTTPError(http_error_msg, response=self)
requests.exceptions.HTTPError: ('422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/app473MWXVJVaD7Es/Data%20Requests?filterByFormula=DATETIME_DIFF%28NOW%28%29%2Cstatus_last_changed%2C%27hours%27%29+%3C+2', "{'type': 'INVALID_FILTER_BY_FORMULA', 'message': 'The formula for filtering records is invalid: Unknown field names: status_last_changed'}")
Also added Type Hinting under the "Leave it better than you found it" principle
Testing
Run the script following the instructions in the README.md file.
Fixes
Description
Testing
README.md
file.Performance
Docs