\query\list

Description
The endpoint gets all of the reactive queries associated with your account. Use the cursor to page through your queries. Each request will return 100 queries. Set the cursor to the last item in the request to get the next page, or user -1 to get the first page.
URL Structure
https://api.vay.studio/query/list
Method
POST
Headers
X-Auth-Token
Required. Your API Key.
Body
cursor
The last query to start when fetching.

{
    "cursor": -1
}
                
Returns
result[i].user String
The user id that created the query.
result[i].id Number
The reactive query id.
result[i].query String
The reactive query's SQL statement.
result[i].properties Object | Null
Optional metadata about the source.

{
    "errorCode": 0,
    "error": "",
    "result": [
        {
            "user": 1205624629821964300,
            "id": 1205653371671806000,
            "query": "SELECT \n  sum(cast(injured as int)) as injured_sum,\n  sum(cast(killed as int)) as killed_sum \n  \nFROM vay.`san-diego/traffic-collisions/pd-collisions-datasd-v1.csv`\n",
            "properties": {
                "name": "sd-traffic-sum"
            }
        },
        {
            "user": 1205624629821964300,
            "id": 1214990662802342000,
            "query": "select * from vay.`san-diego/traffic-volumes/traffic-counts-datasd-v1.csv` limit 300",
            "properties": {
                "name": "sd-long-test"
            }
        }
    ]
}
            
vay logo

© Copyright 2019 Vay Technologies LLC.
All rights reserved.