Cenit IO | open integration Platform(iPaaS)

Operation | Cenit Admin

Connectors
All Webhooks
Operations
Google Sheets API v4 | V4 Spreadsheets {spreadsheetid}:getbydatafilter [Shared] | POST [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/5ba13de425d98515340015f3.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/5ba13de425d98515340015f3.json"

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

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

$tenant_access_key = '...';
$tenant_access_token = '...';
$uri = "https://cenit.io/api/v2/setup/operation/5ba13de425d98515340015f3.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/5ba13de425d98515340015f3.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/5ba13de425d98515340015f3.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/5ba13de425d98515340015f3.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/5ba13de425d98515340015f3.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/5ba13de425d98515340015f3/{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/5ba13de425d98515340015f3/${view}.json"

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

Method

post

Description

Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. This method differs from GetSpreadsheet in that it allows selecting which subsets of spreadsheet data to return by specifying a dataFilters parameter. Multiple DataFilters can be specified. Specifying one or more data filters will return the portions of the spreadsheet that intersect ranges matched by any of the filters. 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 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.

Basic info

Contact us