Cenit IO | open integration Platform(iPaaS)

Operation | Cenit Admin

Connectors
All Webhooks
Operations
Google Sheets API v4 | V4 Spreadsheets {spreadsheetid} Values {range} [Shared] | PUT [Shared]

Show
REST API

Retrieve all existing Operations:

Retrieve all existing Operations you have previously created.

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

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

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

post https://cenit.io/api/v2/setup/operation.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,"resource_id":{},"description":"","method":""}' \
     "https://cenit.io/api/v2/setup/operation.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/operation.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,"resource_id":{},"description":"","method":""}'
  )
);

$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/operation.json",
  :method => 'POST',
  :payload => '{"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false,"resource_id":{},"description":"","method":""}',
  :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/operation.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,"resource_id":{},"description":"","method":""})
};

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/operation.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,"resource_id":{},"description":"","method":""}
    };

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/operation.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,"resource_id":{},"description":"","method":""}),
  success: function(data, textStatus, jqXHR) {
    console.log(data);
  }
});

Retrieve an existing Operation:

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

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

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

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

post https://cenit.io/api/v2/setup/operation/5ba13de425d98515340015e5.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,"resource_id":{},"description":"","method":""}' \
     "https://cenit.io/api/v2/setup/operation/5ba13de425d98515340015e5.json"

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/operation/5ba13de425d98515340015e5.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,"resource_id":{},"description":"","method":""}'
  )
);

$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/operation/5ba13de425d98515340015e5.json",
  :method => 'POST',
  :payload => '{"creator_id":{},"updater_id":{},"tenant_id":{},"metadata":{},"authorization_id":{},"authorization_handler":false,"resource_id":{},"description":"","method":""}',
  :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/operation/5ba13de425d98515340015e5.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,"resource_id":{},"description":"","method":""})
};

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/operation/5ba13de425d98515340015e5.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,"resource_id":{},"description":"","method":""}
    };

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/operation/5ba13de425d98515340015e5.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,"resource_id":{},"description":"","method":""}),
  success: function(data, textStatus, jqXHR) {
    console.log(data);
  }
});

Delete an existing Operation:

Permanently deletes an existing Operation. It cannot be undone.

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

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

Retrieves one attribute of an existing Operation.

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

$tenant_access_key = '...';
$tenant_access_token = '...';
$view = '...';
$uri = "https://cenit.io/api/v2/setup/operation/5ba13de425d98515340015e5/${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/operation/5ba13de425d98515340015e5/#{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/operation/5ba13de425d98515340015e5/%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/operation/5ba13de425d98515340015e5/${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/operation/5ba13de425d98515340015e5/${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} Values {range}	/v4/spreadsheets/{{spreadsheetId}}/values/{{range}}	-	Google Sheets API v4 \| V4 Spreadsheets {spreadsheetid} Values {range} [Shared] \| GET [Shared] and Google Sheets API v4 \| V4 Spreadsheets {spreadsheetid} Values {range} [Shared] \| PUT [Shared]	October 01, 2018 19:46	Show

Method

put

Description

Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a valueInputOption.

Parameters

Name	Value	Description	Metadata	Updated at
includeValuesInResponse	-	Determines if the update response should include the values of the cells that were updated. By default, responses do not include the updated values. If the range to write was larger than than the range actually written, the response will include all values in the requested range (excluding trailing empty rows and columns).	{ "type": "boolean" }	September 20, 2018 20:49
responseDateTimeRenderOption	-	Determines how dates, times, and durations in the response should be rendered. This is ignored if response_value_render_option is FORMATTED_VALUE. The default dateTime render option is [DateTimeRenderOption.SERIAL_NUMBER].	{ "enum": [ "SERIAL_NUMBER", "FORMATTED_STRING" ...	September 20, 2018 20:49
responseValueRenderOption	-	Determines how values in the response should be rendered. The default render option is ValueRenderOption.FORMATTED_VALUE.	{ "enum": [ "FORMATTED_VALUE", "UNFORMATTED_VALUE", ...	September 20, 2018 20:49
valueInputOption	-	How the input data should be interpreted.	{ "enum": [ "INPUT_VALUE_OPTION_UNSPECIFIED", "RAW", ...	September 20, 2018 20:49

4 Parameters

Basic info

Contact us