Skip to main content

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 😉


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.locoi, '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_jsono'data']''boards']'0]0'items_page'],
record_path=h'items', 'column_values'],
meta=a
'items', 'id'],
'items', 'name'],
'column_values', 'display_value']
],
errors="ignore",
)
df_features_norm.insert(0, "board_id", pulse_3.locoi, "board_id"])
if i%100 == 0:
time.sleep(125)
item_features = pd.concat(titem_features, df_features_norm], ignore_index=True)
item_features.head()
Be the first to reply!

Reply