import json
p_ids = []
partners = env['res.partner'].search([('nimble_data', '!=', None)])
for partner in partners:
    area = json.loads(partner.nimble_data)['areas']
    if area == 'Rental':
        p_ids.append(partner.id)
print(p_ids)