SupportFeedbackChangelog
API Reference

GET Query

get
https://api.fulcrumapp.com/api/v2/query

Execute a Query API request using HTTP GET. Provide a SQL like query to query against your organization's data.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Query Params
string
required

The SQL query to execute.

string
Defaults to csv

The format of the results returned by the query. Options include csv, json, geojson, postgres.

boolean
Defaults to true

Include headers for csv format?

boolean
Defaults to false

Include column metadata for json format?

boolean
Defaults to false

Return row arrays instead of objects for json format?

string

Table name for postgres format. Defaults to query.

string

The name of the column used to sort on.

string

The sort direction (asc, desc).

int32
Defaults to 1

The page number requested.

int32
Defaults to 20000

The number of items to return per page.

Headers
string
Defaults to application/json
string
Defaults to Application
Responses

Updated 3 months ago

Language
Credentials
Header
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json

Updated 3 months ago