getData
Get rows
Retrieves data rows from the specified table or view. Note that column names returned in the result section are not JSON standardized, they represent the actual name of the column and may contain foreign, unknown and ill formatted characters.
/data/{table_id}/select
Usage and SDK Samples
curl -X POST "https://api.dataengine.accessacloud.com/data/{table_id}/select?page=&page_size=&api_version="import io.swagger.client.*;
import io.swagger.client.auth.*;
import io.swagger.client.model.*;
import io.swagger.client.api.DataApi;
import java.io.File;
import java.util.*;
public class DataApiExample {
public static void main(String[] args) {
DataApi apiInstance = new DataApi();
Integer tableId = 56; // Integer |
Infinis.WebAPI.v2022_01.Datas.RowFilterModel model = ; // Infinis.WebAPI.v2022_01.Datas.RowFilterModel |
BigDecimal apiVersion = 8.14; // BigDecimal | The requested API version
Integer page = 56; // Integer | Page number.
Integer pageSize = 56; // Integer | Number of results returned per page.
try {
Infinis.WebAPI.API.Objects.ApiListResponseOfInfinis.WebAPI.v2022_01.Datas.DocumentationWorkAroundJObject result = apiInstance.getData(tableId, model, apiVersion, page, pageSize);
System.out.println(result);
} catch (ApiException e) {
System.err.println("Exception when calling DataApi#getData");
e.printStackTrace();
}
}
}import io.swagger.client.api.DataApi;
public class DataApiExample {
public static void main(String[] args) {
DataApi apiInstance = new DataApi();
Integer tableId = 56; // Integer |
Infinis.WebAPI.v2022_01.Datas.RowFilterModel model = ; // Infinis.WebAPI.v2022_01.Datas.RowFilterModel |
BigDecimal apiVersion = 8.14; // BigDecimal | The requested API version
Integer page = 56; // Integer | Page number.
Integer pageSize = 56; // Integer | Number of results returned per page.
try {
Infinis.WebAPI.API.Objects.ApiListResponseOfInfinis.WebAPI.v2022_01.Datas.DocumentationWorkAroundJObject result = apiInstance.getData(tableId, model, apiVersion, page, pageSize);
System.out.println(result);
} catch (ApiException e) {
System.err.println("Exception when calling DataApi#getData");
e.printStackTrace();
}
}
}Integer *tableId = 56; //
Infinis.WebAPI.v2022_01.Datas.RowFilterModel *model = ; //
BigDecimal *apiVersion = 8.14; // The requested API version
Integer *page = 56; // Page number. (optional) (default to 1)
Integer *pageSize = 56; // Number of results returned per page. (optional) (default to 100)
DataApi *apiInstance = [[DataApi alloc] init];
// Get rows
[apiInstance getDataWith:tableId
model:model
apiVersion:apiVersion
page:page
pageSize:pageSize
completionHandler: ^(Infinis.WebAPI.API.Objects.ApiListResponseOfInfinis.WebAPI.v2022_01.Datas.DocumentationWorkAroundJObject output, NSError* error) {
if (output) {
NSLog(@"%@", output);
}
if (error) {
NSLog(@"Error: %@", error);
}
}];
var DataEngineRestUserApi = require('clic_data_rest_user_api');
var api = new DataEngineRestUserApi.DataApi()
var tableId = 56; // {Integer}
var model = ; // {Infinis.WebAPI.v2022_01.Datas.RowFilterModel}
var apiVersion = 8.14; // {BigDecimal} The requested API version
var opts = {
'page': 56, // {Integer} Page number.
'pageSize': 56 // {Integer} Number of results returned per page.
};
var callback = function(error, data, response) {
if (error) {
console.error(error);
} else {
console.log('API called successfully. Returned data: ' + data);
}
};
api.getData(tableId, model, apiVersion, opts, callback);
using System;
using System.Diagnostics;
using IO.Swagger.Api;
using IO.Swagger.Client;
using IO.Swagger.Model;
namespace Example
{
public class getDataExample
{
public void main()
{
var apiInstance = new DataApi();
var tableId = 56; // Integer |
var model = new Infinis.WebAPI.v2022_01.Datas.RowFilterModel(); // Infinis.WebAPI.v2022_01.Datas.RowFilterModel |
var apiVersion = 8.14; // BigDecimal | The requested API version
var page = 56; // Integer | Page number. (optional) (default to 1)
var pageSize = 56; // Integer | Number of results returned per page. (optional) (default to 100)
try
{
// Get rows
Infinis.WebAPI.API.Objects.ApiListResponseOfInfinis.WebAPI.v2022_01.Datas.DocumentationWorkAroundJObject result = apiInstance.getData(tableId, model, apiVersion, page, pageSize);
Debug.WriteLine(result);
}
catch (Exception e)
{
Debug.Print("Exception when calling DataApi.getData: " + e.Message );
}
}
}
}
<?php
require_once(__DIR__ . '/vendor/autoload.php');
$api_instance = new Swagger\Client\Api\DataApi();
$tableId = 56; // Integer |
$model = ; // Infinis.WebAPI.v2022_01.Datas.RowFilterModel |
$apiVersion = 8.14; // BigDecimal | The requested API version
$page = 56; // Integer | Page number.
$pageSize = 56; // Integer | Number of results returned per page.
try {
$result = $api_instance->getData($tableId, $model, $apiVersion, $page, $pageSize);
print_r($result);
} catch (Exception $e) {
echo 'Exception when calling DataApi->getData: ', $e->getMessage(), PHP_EOL;
}
?>use Data::Dumper;
use WWW::SwaggerClient::Configuration;
use WWW::SwaggerClient::DataApi;
my $api_instance = WWW::SwaggerClient::DataApi->new();
my $tableId = 56; # Integer |
my $model = WWW::SwaggerClient::Object::Infinis.WebAPI.v2022_01.Datas.RowFilterModel->new(); # Infinis.WebAPI.v2022_01.Datas.RowFilterModel |
my $apiVersion = 8.14; # BigDecimal | The requested API version
my $page = 56; # Integer | Page number.
my $pageSize = 56; # Integer | Number of results returned per page.
eval {
my $result = $api_instance->getData(tableId => $tableId, model => $model, apiVersion => $apiVersion, page => $page, pageSize => $pageSize);
print Dumper($result);
};
if ($@) {
warn "Exception when calling DataApi->getData: $@\n";
}from __future__ import print_statement
import time
import swagger_client
from swagger_client.rest import ApiException
from pprint import pprint
# create an instance of the API class
api_instance = swagger_client.DataApi()
tableId = 56 # Integer |
model = # Infinis.WebAPI.v2022_01.Datas.RowFilterModel |
apiVersion = 8.14 # BigDecimal | The requested API version
page = 56 # Integer | Page number. (optional) (default to 1)
pageSize = 56 # Integer | Number of results returned per page. (optional) (default to 100)
try:
# Get rows
api_response = api_instance.get_data(tableId, model, apiVersion, page=page, pageSize=pageSize)
pprint(api_response)
except ApiException as e:
print("Exception when calling DataApi->getData: %s\n" % e)Parameters
Path parameters
| Name | Description |
|---|---|
| table_id* |
Integer
(int32)
Required
|
Body parameters
| Name | Description |
|---|---|
| model * |
Query parameters
| Name | Description |
|---|---|
| page |
Integer
(int32)
Page number.
|
| page_size |
Integer
(int32)
Number of results returned per page.
|
| api_version* |
BigDecimal
The requested API version
Required
|
Responses
Status: 200 - Table delete result
{success=true, pagination={result_count=10, result_total_count=15, current_page=1, page_size=10, has_more_results=true}, result=[{Year=2018, Model Type=Mercedes, Car Type=Berline, Sales Units=12500, Target Units=30000, Sales=15487, Cost=80000, Profit=20000}]}