How to fix pd.json_normalize so it will take "title"

monday Apps & Developers
,
1

Hello, I have a python code, but i do not know how monday filters work with pd.json_normalize python function. I don’t think it is written ok, because I believe column{title} should be written somewhere. Can someone help me? Thanks in advance :wink:

item_features = pd.DataFrame()
pulse_3 = pulse_3.reset_index(drop=True)
for i in range(1,len(pulse_3)):
    q_features = (
        "{boards(ids:" 
        + pulse_3.loc[i, 'board_id'] 
        + "){items_page (limit:500){cursor items {id name column_values{... on MirrorValue {display_value} ... on BoardRelationValue{display_value} column{title} text type}}}}}"
    )
    q_features = {"query": q_features}
    r_features = requests.post(url=apiUrl, json= q_features, headers=headers)
    features_json = r_features.json()
    
    df_features_norm = pd.json_normalize(
       features_json['data']['boards'][0]['items_page'],
       record_path=['items', 'column_values'],
       meta=[
            ['items', 'id'],
            ['items', 'name'],
            ['column_values', 'display_value']
       ],
       errors="ignore",
    )
    df_features_norm.insert(0, "board_id", pulse_3.loc[i, "board_id"])
    if i%100 == 0:
        time.sleep(125)
    item_features = pd.concat([item_features, df_features_norm], ignore_index=True)
item_features.head()