Log in
Log into community
Find answers from the community
View all posts
Related posts
Did this answer your question?
π
π
π
Powered by
Hall
Inactive
Updated 11 months ago
0
Follow
someone know ?
someone know ?
Inactive
0
Follow
M
Meow Meow
11 months ago
Β·
someone know ?
L
M
3 comments
Share
Open in Discord
L
Logan M
11 months ago
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
M
Meow Meow
11 months ago
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"
]
}
L
Logan M
11 months ago
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
Join on Discord