IMPORTJSONAPI
IMPORTJSONAPI copied to clipboard
How to parse the full response
First of all - beautiful function, just what I was looking for. I've got more of a question I guess than an issue. So I've got a JSON response like so:
{
"metrics": [
{
"human_date": "2016-11-26",
"active_customers": 642,
"active_subscriptions": 642
},
{
"human_date": "2016-11-27",
"active_customers": 640,
"active_subscriptions": 640
}
]
}
And I'm querying it like so to get the metrics $.metrics.* and passing human_date, active_customers and active_subscription as column parameters, and I get back the data perfectly. But how do I get all the data from the metrics array and formatted with headers without actually knowing what kind of metrics will I get back from the API in advance?
I can manage getting the metrics themselves in a list like so $.metrics...~ but I cannot get them back as column names/headers.
Any ideas?
Thanks for the feedback! As to your question you can't do this at the moment but it is something that could be added. I'll need a few days to think about the best way to implement this feature.
I am looking to get column headers for my json data also