Cenit IO | open integration Platform(iPaaS)

Operation | Cenit Admin

Webhooks
All Webhooks
Operations
Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} [Shared] | GET [Shared]

Show
REST API

Retrieve all existing Webhooks:

Retrieve all existing Webhooks you have previously created.

get https://cenit.io/api/v2/setup/webhook.json

Curl
Php
Ruby
Python
Nodejs
JQuery

tenant_access_key='...'
tenant_access_token='...'

curl -X GET \
     -H "X-Tenant-Access-Key: ${tenant_access_key}" \
     -H "X-Tenant-Access-Token: ${tenant_access_token}" \
     -H "Content-Type: application/json" \
     -d '{"page":1,"limit":25,"order":"id"}' \
     "https://cenit.io/api/v2/setup/webhook.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/webhook.json";
$headers = array(
  "Content-Type: application/json",
  "X-Tenant-Access-Key: ${tenant_access_key}",
  "X-Tenant-Access-Token: ${tenant_access_token}"
);
$options = array(
  'http' => array(
    'header'  => implode($headers, "\r\n"),
    'method'  => 'GET',
    'content' => '{"page":1,"limit":25,"order":"id"}'
  )
);

$context  = stream_context_create($options);
$response = file_get_contents($uri, false, $context);

print_r(json_decode($response, true));

require 'rest-client'
require 'json'

tenant_access_key = '...'
tenant_access_token = '...'

response = RestClient::Request.execute(
  :url => "https://cenit.io/api/v2/setup/webhook.json",
  :method => 'GET',
  :payload => '{"page":1,"limit":25,"order":"id"}',
  :headers => {
    'Content-Type' => 'application/json',
    'X-Tenant-Access-Key' => tenant_access_key,
    'X-Tenant-Access-Token' => tenant_access_token
  }
)

puts JSON.parse(response.body)

import json
from requests import Request, Session

tenant_access_key = '...'
tenant_access_token = '...'
uri = 'https://cenit.io/api/v2/setup/webhook.json' % (tenant_access_key, tenant_access_token)
options = {
  'headers': {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
  'data': json.dumps({"page":1,"limit":25,"order":"id"})
};

session = Session()
request = Request('GET', uri, **options)
prepped = request.prepare()
response = session.send(prepped)

print(response.json())

var request = require('request'),
    tenant_access_key = '...',
    tenant_access_token = '...',
    options = {
      method: 'GET',
      url: 'https://cenit.io/api/v2/setup/webhook.json',
      headers: {
        'Content-Type': 'application/json',
        'X-Tenant-Access-Key': tenant_access_key,
        'X-Tenant-Access-Token': tenant_access_token
      },
      json: true,
      qs: {"page":1,"limit":25,"order":"id"}
    };

request(options, function (error, response, data) {
  if (error) throw error;

  console.log(data);
});

var tenant_access_key = '...',
    tenant_access_token = '...';

jQuery.ajax({
  url: 'https://cenit.io/api/v2/setup/webhook.json',
  method: 'GET',
  dataType: 'json',
  crossOrigin: true,
  headers: {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
  data: {"page":1,"limit":25,"order":"id"},
  success: function(data, textStatus, jqXHR) {
    console.log(data);
  }
});

Create an Webhook:

Creates the specified Webhook. Any parameters not provided will be left unchanged.

post https://cenit.io/api/v2/setup/webhook.json

Curl
Php
Ruby
Python
Nodejs
JQuery

tenant_access_key='...'
tenant_access_token='...'

curl -X POST \
     -H "X-Tenant-Access-Key: ${tenant_access_key}" \
     -H "X-Tenant-Access-Token: ${tenant_access_token}" \
     -H "Content-Type: application/json" \
     -d '{"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false}' \
     "https://cenit.io/api/v2/setup/webhook.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/webhook.json";
$headers = array(
  "Content-Type: application/json",
  "X-Tenant-Access-Key: ${tenant_access_key}",
  "X-Tenant-Access-Token: ${tenant_access_token}"
);
$options = array(
  'http' => array(
    'header'  => implode($headers, "\r\n"),
    'method'  => 'POST',
    'content' => '{"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false}'
  )
);

$context  = stream_context_create($options);
$response = file_get_contents($uri, false, $context);

print_r(json_decode($response, true));

require 'rest-client'
require 'json'

tenant_access_key = '...'
tenant_access_token = '...'

response = RestClient::Request.execute(
  :url => "https://cenit.io/api/v2/setup/webhook.json",
  :method => 'POST',
  :payload => '{"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false}',
  :headers => {
    'Content-Type' => 'application/json',
    'X-Tenant-Access-Key' => tenant_access_key,
    'X-Tenant-Access-Token' => tenant_access_token
  }
)

puts JSON.parse(response.body)

import json
from requests import Request, Session

tenant_access_key = '...'
tenant_access_token = '...'
uri = 'https://cenit.io/api/v2/setup/webhook.json' % (tenant_access_key, tenant_access_token)
options = {
  'headers': {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
  'data': json.dumps({"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false})
};

session = Session()
request = Request('POST', uri, **options)
prepped = request.prepare()
response = session.send(prepped)

print(response.json())

var request = require('request'),
    tenant_access_key = '...',
    tenant_access_token = '...',
    options = {
      method: 'POST',
      url: 'https://cenit.io/api/v2/setup/webhook.json',
      headers: {
        'Content-Type': 'application/json',
        'X-Tenant-Access-Key': tenant_access_key,
        'X-Tenant-Access-Token': tenant_access_token
      },
      json: true,
      body: {"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false}
    };

request(options, function (error, response, data) {
  if (error) throw error;

  console.log(data);
});

var tenant_access_key = '...',
    tenant_access_token = '...';

jQuery.ajax({
  url: 'https://cenit.io/api/v2/setup/webhook.json',
  method: 'POST',
  dataType: 'json',
  crossOrigin: true,
  headers: {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
  data: JSON.stringify({"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false}),
  success: function(data, textStatus, jqXHR) {
    console.log(data);
  }
});

Retrieve an existing Webhook:

Retrieves the details of an existing Webhook. You need only supply the unique Webhook identifier that was returned upon Webhook creation.

get https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json

Curl
Php
Ruby
Python
Nodejs
JQuery

tenant_access_key='...'
tenant_access_token='...'

curl -X GET \
     -H "X-Tenant-Access-Key: ${tenant_access_key}" \
     -H "X-Tenant-Access-Token: ${tenant_access_token}" \
     -H "Content-Type: application/json" \
     "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json";
$headers = array(
  "Content-Type: application/json",
  "X-Tenant-Access-Key: ${tenant_access_key}",
  "X-Tenant-Access-Token: ${tenant_access_token}"
);
$options = array(
  'http' => array(
    'header'  => implode($headers, "\r\n"),
    'method'  => 'GET',
  )
);

$context  = stream_context_create($options);
$response = file_get_contents($uri, false, $context);

print_r(json_decode($response, true));

require 'rest-client'
require 'json'

tenant_access_key = '...'
tenant_access_token = '...'

response = RestClient::Request.execute(
  :url => "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json",
  :method => 'GET',
  :headers => {
    'Content-Type' => 'application/json',
    'X-Tenant-Access-Key' => tenant_access_key,
    'X-Tenant-Access-Token' => tenant_access_token
  }
)

puts JSON.parse(response.body)

from requests import Request, Session

tenant_access_key = '...'
tenant_access_token = '...'
uri = 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json' % (tenant_access_key, tenant_access_token)
options = {
  'headers': {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
};

session = Session()
request = Request('GET', uri, **options)
prepped = request.prepare()
response = session.send(prepped)

print(response.json())

var request = require('request'),
    tenant_access_key = '...',
    tenant_access_token = '...',
    options = {
      method: 'GET',
      url: 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json',
      headers: {
        'Content-Type': 'application/json',
        'X-Tenant-Access-Key': tenant_access_key,
        'X-Tenant-Access-Token': tenant_access_token
      },
      json: true,
    };

request(options, function (error, response, data) {
  if (error) throw error;

  console.log(data);
});

var tenant_access_key = '...',
    tenant_access_token = '...';

jQuery.ajax({
  url: 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json',
  method: 'GET',
  dataType: 'json',
  crossOrigin: true,
  headers: {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
  success: function(data, textStatus, jqXHR) {
    console.log(data);
  }
});

Update an Webhook:

Updates the specified Webhook. Any parameters not provided will be left unchanged.

post https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json

Curl
Php
Ruby
Python
Nodejs
JQuery

tenant_access_key='...'
tenant_access_token='...'

curl -X POST \
     -H "X-Tenant-Access-Key: ${tenant_access_key}" \
     -H "X-Tenant-Access-Token: ${tenant_access_token}" \
     -H "Content-Type: application/json" \
     -d '{"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false}' \
     "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json";
$headers = array(
  "Content-Type: application/json",
  "X-Tenant-Access-Key: ${tenant_access_key}",
  "X-Tenant-Access-Token: ${tenant_access_token}"
);
$options = array(
  'http' => array(
    'header'  => implode($headers, "\r\n"),
    'method'  => 'POST',
    'content' => '{"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false}'
  )
);

$context  = stream_context_create($options);
$response = file_get_contents($uri, false, $context);

print_r(json_decode($response, true));

require 'rest-client'
require 'json'

tenant_access_key = '...'
tenant_access_token = '...'

response = RestClient::Request.execute(
  :url => "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json",
  :method => 'POST',
  :payload => '{"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false}',
  :headers => {
    'Content-Type' => 'application/json',
    'X-Tenant-Access-Key' => tenant_access_key,
    'X-Tenant-Access-Token' => tenant_access_token
  }
)

puts JSON.parse(response.body)

import json
from requests import Request, Session

tenant_access_key = '...'
tenant_access_token = '...'
uri = 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json' % (tenant_access_key, tenant_access_token)
options = {
  'headers': {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
  'data': json.dumps({"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false})
};

session = Session()
request = Request('POST', uri, **options)
prepped = request.prepare()
response = session.send(prepped)

print(response.json())

var request = require('request'),
    tenant_access_key = '...',
    tenant_access_token = '...',
    options = {
      method: 'POST',
      url: 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json',
      headers: {
        'Content-Type': 'application/json',
        'X-Tenant-Access-Key': tenant_access_key,
        'X-Tenant-Access-Token': tenant_access_token
      },
      json: true,
      body: {"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false}
    };

request(options, function (error, response, data) {
  if (error) throw error;

  console.log(data);
});

var tenant_access_key = '...',
    tenant_access_token = '...';

jQuery.ajax({
  url: 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json',
  method: 'POST',
  dataType: 'json',
  crossOrigin: true,
  headers: {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
  data: JSON.stringify({"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false}),
  success: function(data, textStatus, jqXHR) {
    console.log(data);
  }
});

Delete an existing Webhook:

Permanently deletes an existing Webhook. It cannot be undone.

delete https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json

Curl
Php
Ruby
Python
Nodejs
JQuery

tenant_access_key='...'
tenant_access_token='...'

curl -X DELETE \
     -H "X-Tenant-Access-Key: ${tenant_access_key}" \
     -H "X-Tenant-Access-Token: ${tenant_access_token}" \
     -H "Content-Type: application/json" \
     "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json";
$headers = array(
  "Content-Type: application/json",
  "X-Tenant-Access-Key: ${tenant_access_key}",
  "X-Tenant-Access-Token: ${tenant_access_token}"
);
$options = array(
  'http' => array(
    'header'  => implode($headers, "\r\n"),
    'method'  => 'DELETE',
  )
);

$context  = stream_context_create($options);
$response = file_get_contents($uri, false, $context);

print_r(json_decode($response, true));

require 'rest-client'
require 'json'

tenant_access_key = '...'
tenant_access_token = '...'

response = RestClient::Request.execute(
  :url => "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json",
  :method => 'DELETE',
  :headers => {
    'Content-Type' => 'application/json',
    'X-Tenant-Access-Key' => tenant_access_key,
    'X-Tenant-Access-Token' => tenant_access_token
  }
)

puts JSON.parse(response.body)

from requests import Request, Session

tenant_access_key = '...'
tenant_access_token = '...'
uri = 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json' % (tenant_access_key, tenant_access_token)
options = {
  'headers': {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
};

session = Session()
request = Request('DELETE', uri, **options)
prepped = request.prepare()
response = session.send(prepped)

print(response.json())

var request = require('request'),
    tenant_access_key = '...',
    tenant_access_token = '...',
    options = {
      method: 'DELETE',
      url: 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json',
      headers: {
        'Content-Type': 'application/json',
        'X-Tenant-Access-Key': tenant_access_key,
        'X-Tenant-Access-Token': tenant_access_token
      },
      json: true,
    };

request(options, function (error, response, data) {
  if (error) throw error;

  console.log(data);
});

var tenant_access_key = '...',
    tenant_access_token = '...';

jQuery.ajax({
  url: 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd.json',
  method: 'DELETE',
  dataType: 'json',
  crossOrigin: true,
  headers: {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
  success: function(data, textStatus, jqXHR) {
    console.log(data);
  }
});

Retrieve one attribute of an existing Webhook:

Retrieves one attribute of an existing Webhook.

get https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd/{view}.json

Curl
Php
Ruby
Python
Nodejs
JQuery

tenant_access_key='...'
tenant_access_token='...'
view='...'

curl -X GET \
     -H "X-Tenant-Access-Key: ${tenant_access_key}" \
     -H "X-Tenant-Access-Token: ${tenant_access_token}" \
     -H "Content-Type: application/json" \
     "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd/${view}.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$view = '...';
$uri = "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd/${view}.json";
$headers = array(
  "Content-Type: application/json",
  "X-Tenant-Access-Key: ${tenant_access_key}",
  "X-Tenant-Access-Token: ${tenant_access_token}"
);
$options = array(
  'http' => array(
    'header'  => implode($headers, "\r\n"),
    'method'  => 'GET',
  )
);

$context  = stream_context_create($options);
$response = file_get_contents($uri, false, $context);

print_r(json_decode($response, true));

require 'rest-client'
require 'json'

tenant_access_key = '...'
tenant_access_token = '...'
view = '...'

response = RestClient::Request.execute(
  :url => "https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd/#{view}.json",
  :method => 'GET',
  :headers => {
    'Content-Type' => 'application/json',
    'X-Tenant-Access-Key' => tenant_access_key,
    'X-Tenant-Access-Token' => tenant_access_token
  }
)

puts JSON.parse(response.body)

from requests import Request, Session

tenant_access_key = '...'
tenant_access_token = '...'
view = '...'
uri = 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd/%s.json' % (tenant_access_key, tenant_access_token, view)
options = {
  'headers': {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
};

session = Session()
request = Request('GET', uri, **options)
prepped = request.prepare()
response = session.send(prepped)

print(response.json())

var request = require('request'),
    tenant_access_key = '...',
    tenant_access_token = '...',
    view = '...',
    options = {
      method: 'GET',
      url: 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd/${view}.json',
      headers: {
        'Content-Type': 'application/json',
        'X-Tenant-Access-Key': tenant_access_key,
        'X-Tenant-Access-Token': tenant_access_token
      },
      json: true,
    };

request(options, function (error, response, data) {
  if (error) throw error;

  console.log(data);
});

var tenant_access_key = '...',
    tenant_access_token = '...',
    view = '...';

jQuery.ajax({
  url: 'https://cenit.io/api/v2/setup/webhook/5ba13de425d98515340015dd/${view}.json',
  method: 'GET',
  dataType: 'json',
  crossOrigin: true,
  headers: {
    'Content-Type': 'application/json',
    'X-Tenant-Access-Key': tenant_access_key,
    'X-Tenant-Access-Token': tenant_access_token
  },
  success: function(data, textStatus, jqXHR) {
    console.log(data);
  }
});

Basic info

Resource

Namespace	Name	Path	Description	Operations	Updated at
Google Sheets API v4	V4 Spreadsheets {spreadsheetid}	/v4/spreadsheets/{{spreadsheetId}}	-	Google Sheets API v4 \| V4 Spreadsheets {spreadsheetid} [Shared] \| GET [Shared]	October 01, 2018 19:46	Show

Method

get

Description

Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids will not be returned. You can include grid data one of two ways: * Specify a field mask listing your desired fields using the `fields` URL parameter in HTTP * Set the includeGridData URL parameter to true. If a field mask is set, the `includeGridData` parameter is ignored For large spreadsheets, it is recommended to retrieve only the specific fields of the spreadsheet that you want. To retrieve only subsets of the spreadsheet, use the ranges URL parameter. Multiple ranges can be specified. Limiting the range will return only the portions of the spreadsheet that intersect the requested ranges. Ranges are specified using A1 notation.

Basic info

Contact us