python data and insert
I made a form ins streamlit, I want to submit the data to my database in supabase. I keep getting an error about data not being json format. I read supabase doesn't handle python data. Is there a way to convert it or put it in differently? I'm using st_supabase_connection should i be trying with something else?
My insert string.
st_supabase_client.table("DIRP").insert([{"Schedule_Notes","Pulled_Week","Service_now_status","Specialist_Name","REQ_Number","PO_Number","Warranty_Status","Cost_Center_x5_0400","FacName","Address","City","State","Zip_Code","Point_of_Contact","Email","Phone_Number","Weeknumber_read_only","Coupa_Closure","Ticket_Type","Billing_Week_Read_Only","Scheduled_Date","Snow_Closure"}]).execute()
connection.commit()
My insert string.
st_supabase_client.table("DIRP").insert([{"Schedule_Notes","Pulled_Week","Service_now_status","Specialist_Name","REQ_Number","PO_Number","Warranty_Status","Cost_Center_x5_0400","FacName","Address","City","State","Zip_Code","Point_of_Contact","Email","Phone_Number","Weeknumber_read_only","Coupa_Closure","Ticket_Type","Billing_Week_Read_Only","Scheduled_Date","Snow_Closure"}]).execute()
connection.commit()
