Using the query builder

See the pysnow.Request.get_multiple() and pysnow.QueryBuilder() documentation for more details.

import pysnow
from datetime import datetime as dt
from datetime import timedelta as td

# Create client object
s = pysnow.Client(instance='myinstance', user='myusername', password='mypassword')

# Set start and end range
start = dt(1970, 1, 1)
end = dt.now() - td(days=20)

# Query incident records with number starting with 'INC0123', created between 1970-01-01 and 20 days back in time
qb = (
    pysnow.QueryBuilder()
    .field('number').starts_with('INC0123')
    .AND()
    .field('sys_created_on').between(start, end)
)

r = s.query('incident', query=qb)

# Iterate over the result and print out number
for record in r.get_multiple():
    print(record['number'])