import pandas as pd
import pysnow
from pandas.io.json import json_normalize
from datetime import datetime

qb_query = pysnow.QueryBuilder().field('short_description').equals('PAD > 4. Solicitações Corporativas > Dados Cadastrais, Manutenção e Criação de Acessos').AND().field('sys_created_on').greater_than(datetime(2021,1,1)).AND().field('assignment_group').equals('807d1e0bdb4a77405c7d0fbca3961969')
c = pysnow.Client(user = 'thalles.ribeiro', password = 'Kroton20201', instance='kroton')
table = c.resource(api_path='/table/sn_customerservice_case_dga')
response = table.get(query = qb_query)

df_final_loop = pd.DataFrame.from_dict(json_normalize(response.all()),orient = 'columns')

df_final_loop = df_final_loop[['number','sys_updated_on',....]]

lista_colunas = ['number', 'sys_updated_on',...]
            
for col in lista_colunas:
    if col not in df_final_loop.columns:
        df_final_loop[col] = np.nan
    
df_final_loop = df_final_loop.fillna('-')