Queries

Get query by query Id

This method requires the Queries:Get permission to be associated with the role.

GET

/gb/queries/{query_id}

curl --request GET \
  --url https://api.catch-e.com/gb/queries/{query_id} \
  --header 'Authorization: <api-key>' \
  --header 'Time-Zone: UTC'

{
  "_embedded": {
    "scheduler_jobs": [
      {
        "average_run_time": 300,
        "last_run": "2020-02-21 10:05:00",
        "method": "executeQuery",
        "scheduler_job_id": "123456",
        "status_flag": "active"
      }
    ]
  },
  "_link": {
    "self": {
      "href": "https://api.catch-e.com/gb/queries/100001"
    }
  },
  "description": "List of contacts",
  "maximum_execution_time": 300,
  "name": "List of contacts",
  "query": "SELECT * FROM fm_contacts;",
  "query_id": "123456",
  "status_flag": "active",
  "super_flag": "yes"
}

Authorizations

Authorizationstringheaderrequired

For accessing the API a valid token must be passed in all the queries in the 'Authorization' header.

A valid token is generated by the API and returned by the /authenticate method by supplying a valid username and password.

The following syntax must be used in the 'Authorization' header :

Bearer aaaaaa/bbbbbb.ccccccc.dddddd

Path Parameters

query_idstringrequired

Query Id to search

Headers

Time-Zonestringheaderdefault:UTC

The timezone value can be given in several formats, none of which are case sensitive:

As a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'.
As a string indicating an offset from UTC of the form [H]H:MM, prefixed with a + or -, such as '+10:00', '-6:00', or '+05:30'. A leading zero can optionally be used for hours values less than 10;

Maximum string length: 100

Pattern: ^[a-zA-Z0-9\/\:\+\-\_]+$

Response

Success

_embeddedobject

Show child attributes

_linkobject

Show child attributes

descriptionstring

Description of the query

Example: List of contacts

maximum_execution_timeinteger

Maximum run time set in seconds

Example: 300

namestring

Name of the query

Example: List of contacts

querystring

SQL query

Example: SELECT * FROM fm_contacts;

query_idstring

Query ID

Example: 123456

status_flagenum<string>default:active

Status of the query

Available options: active, inactive, deleted

super_flagenum<string>

When checked ON, only 'super' users can Edit and Save changes to queries

Available options: yes, no

Example: yes

Still need help? Ask the team