Get Data

get

https://api.upcare.ph/api/data/{db}

To be used to get values from the data table (i.e., database table in wide format).

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Path Params

string

required

length ≤ 255

Name of the database.

Query Params

columns

string

length ≤ 1024

Columns of the table to be returned.

local_time_start

string

length ≤ 24

Start of the interval. By default, the interval is 1 hour. The maximum interval is 1 day.

local_time_end

string

length ≤ 24

End of the interval. By defaÍult, the interval is 1 hour. The maximum interval is 1 day.

topic

string

length ≤ 255

Data with the specified topic.

source

string

length ≤ 255

Data with the specified source.

format

string

enum

Format of the data to be returned. (i.e., csv)

Allowed:

limit

int32

1 to 1024

Limit of the data to be returned.

page

int32

1 to 2147483647

Page of the data to be returned.

order_by

string

length ≤ 255

Order of the data to be returned.

sort_order

string

enum

Sort order of the data to be returned.

Allowed:

Responses

200OK

400Bad Request

defaultInternal Server Error