Find answers from the community

Updated 11 months ago

someone know ?

someone know ?
L
M
3 comments
youd have to parse it as a dataframe.

You can get the sql query used from response.metadata -- you could parse the columns from there into a dataframe
but the metada comes like this below, youre saying ther eis a way to get the proper parse then put in dataframe ?

{
"c8ce0-a074-457-b35a-de108f7":{}
"sql_query":"SELECT Division_No, SUM(Shipped_Dollars) as Total_Sales
FROM MasterView
WHERE Division_No IN ('28', '38')
GROUP BY Division_No"
"result":[
0:[
0:"28"
1:"Decimal('3648.97')"
]
1:[
0:"38"
1:"Decimal('3497.22')"
]
]
"col_keys":[
0:"Division_No"
1:"Total_Sales"
]
}
yea pretty mmuch -- would parse the SELECT above to get the column names of the results
Add a reply
Sign up and join the conversation on Discord