Cenit IO | open integration Platform(iPaaS)

Resource | Cenit Admin

Connectors
Resources
Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} [Shared]

Show
REST API

Retrieve all existing Resources:

Retrieve all existing Resources you have previously created.

get https://cenit.io/api/v2/setup/resource.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/resource.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/resource.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/resource.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/resource.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/resource.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/resource.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 Resource:

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

post https://cenit.io/api/v2/setup/resource.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":{},"namespace":"","name":"","metadata":{},"path":"","description":""}' \
     "https://cenit.io/api/v2/setup/resource.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/resource.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":{},"namespace":"","name":"","metadata":{},"path":"","description":""}'
  )
);

$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/resource.json",
  :method => 'POST',
  :payload => '{"creator_id":{},"updater_id":{},"tenant_id":{},"namespace":"","name":"","metadata":{},"path":"","description":""}',
  :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/resource.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":{},"namespace":"","name":"","metadata":{},"path":"","description":""})
};

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/resource.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":{},"namespace":"","name":"","metadata":{},"path":"","description":""}
    };

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/resource.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":{},"namespace":"","name":"","metadata":{},"path":"","description":""}),
  success: function(data, textStatus, jqXHR) {
    console.log(data);
  }
});

Retrieve an existing Resource:

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

get https://cenit.io/api/v2/setup/resource/5ba13de325d98515340015ae.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/resource/5ba13de325d98515340015ae.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/resource/5ba13de325d98515340015ae.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/resource/5ba13de325d98515340015ae.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/resource/5ba13de325d98515340015ae.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/resource/5ba13de325d98515340015ae.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/resource/5ba13de325d98515340015ae.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 Resource:

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

post https://cenit.io/api/v2/setup/resource/5ba13de325d98515340015ae.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":{},"namespace":"","name":"","metadata":{},"path":"","description":""}' \
     "https://cenit.io/api/v2/setup/resource/5ba13de325d98515340015ae.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/resource/5ba13de325d98515340015ae.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":{},"namespace":"","name":"","metadata":{},"path":"","description":""}'
  )
);

$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/resource/5ba13de325d98515340015ae.json",
  :method => 'POST',
  :payload => '{"creator_id":{},"updater_id":{},"tenant_id":{},"namespace":"","name":"","metadata":{},"path":"","description":""}',
  :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/resource/5ba13de325d98515340015ae.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":{},"namespace":"","name":"","metadata":{},"path":"","description":""})
};

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/resource/5ba13de325d98515340015ae.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":{},"namespace":"","name":"","metadata":{},"path":"","description":""}
    };

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/resource/5ba13de325d98515340015ae.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":{},"namespace":"","name":"","metadata":{},"path":"","description":""}),
  success: function(data, textStatus, jqXHR) {
    console.log(data);
  }
});

Delete an existing Resource:

Permanently deletes an existing Resource. It cannot be undone.

delete https://cenit.io/api/v2/setup/resource/5ba13de325d98515340015ae.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/resource/5ba13de325d98515340015ae.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/resource/5ba13de325d98515340015ae.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/resource/5ba13de325d98515340015ae.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/resource/5ba13de325d98515340015ae.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/resource/5ba13de325d98515340015ae.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/resource/5ba13de325d98515340015ae.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 Resource:

Retrieves one attribute of an existing Resource.

get https://cenit.io/api/v2/setup/resource/5ba13de325d98515340015ae/{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/resource/5ba13de325d98515340015ae/${view}.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$view = '...';
$uri = "https://cenit.io/api/v2/setup/resource/5ba13de325d98515340015ae/${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/resource/5ba13de325d98515340015ae/#{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/resource/5ba13de325d98515340015ae/%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/resource/5ba13de325d98515340015ae/${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/resource/5ba13de325d98515340015ae/${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

Namespace

Google Sheets API v4

Name

V4 Spreadsheets {spreadsheetid}

Path

/v4/spreadsheets/{{spreadsheetId}}

Operations

Resource	Method	Description	Parameters
Google Sheets API v4 \| V4 Spreadsheets {spreadsheetid} [Shared]	get	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.		Show

1 Operations

Id

5ba13de325d98515340015ae

Created at

September 18, 2018 18:03

Updated at

October 01, 2018 19:46

Parameters & Headers

Parameters

Name	Value	Description	Metadata	Updated at
includeGridData	-	True if grid data should be returned. This parameter is ignored if a field mask was set in the request.	{ "type": "boolean" }	September 20, 2018 20:49
ranges	-	The ranges to retrieve from the spreadsheet.	{ "collectionFormat": "multi", "items": { "type": "string" ...	September 20, 2018 20:49

2 Parameters

Template parameters

Name	Value	Description	Metadata	Updated at
spreadsheetId	-	The spreadsheet to request.	{ "required": true, "type": "string" }	September 20, 2018 20:49

1 Parameters

Basic info

Parameters & Headers

Contact us