Get Data

get

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

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

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:

organization

string

Organization ID.

filter

object

Filter rows based on any field/column with supported conditions.

Responses

Language

URL

Response

Click Try It! to start a request and see the response here! Or choose an example:

application/json

200OK

400Bad Request

defaultInternal Server Error