Exigo Web Services API v2024.9.6.6

CreateTableFilterSettings

Creates Table Filter Settings.

Input Properties

CreateTableFilterSettingsRequest
PropertyData TypeNotes
DestinationIdInt32
FilterGroupId TableGroupID
ColumnNameStringOptional.
SchemaNameStringOptional.
TableNameStringOptional.
FilterValueStringOptional.

Output Properties

CreateTableFilterSettingsResponse
PropertyData TypeNotes

Http Request

Rest call not available for this method yet.

Http Response


                            

Soap Request

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.

POST /3.0/ExigoApi.asmx HTTP/1.1
Host: api.exigo.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "https://api.exigo.com/CreateTableFilterSettings"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Header> <ApiAuthentication xmlns="http://api.exigo.com/"> <LoginName>string</LoginName> <Password>string</Password> <Company>string</Company> <Identity>string</Identity> <RequestTimeUtc>dateTime</RequestTimeUtc> <Signature>string</Signature> </ApiAuthentication> </soap:Header> <soap:Body> <CreateTableFilterSettingsRequest xmlns="http://api.exigo.com/"> <DestinationId>int</DestinationId> <FilterGroupId>Misc or AutoOrder or Core or Commission or Customer or CustomersExtended or Item or Log or Messaging or Order or Payout or Tree or User or Image</FilterGroupId> <ColumnName>string</ColumnName> <SchemaName>string</SchemaName> <TableName>string</TableName> <FilterValue>string</FilterValue> </CreateTableFilterSettingsRequest> </soap:Body> </soap:Envelope>

Soap Response

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <CreateTableFilterSettingsResult xmlns="http://api.exigo.com/" /> </soap:Body> </soap:Envelope>

C# Rest Client

Install Nuget package Exigo.Api.Client

try

{

    //Create Api Client

    var api = new ExigoApiClient("yourcmpany", "yourlogin", "yourpassword");

 

    //Create Request

    var req = new CreateTableFilterSettingsRequest();

 

    req.DestinationId = 1;

    req.FilterGroupId = TableGroupID.Misc;

    req.ColumnName = "1";

    req.SchemaName = "1";

    req.TableName = "1";

    req.FilterValue = "1";

 

    //Send Request to Server and Get Response

    var res = await api.CreateTableFilterSettingsAsync(req);

 

    //Now examine the results:

}

catch (Exception ex)

{

    Console.WriteLine("Error: " + ex.Message);

}

C# Soap Client

try

{

    //Create Main API Context Object

    ExigoApi api = new ExigoApi();

 

    //Create Authentication Header

    ApiAuthentication auth = new ApiAuthentication();

    auth.LoginName = "yourLoginName";

    auth.Password = "yourPassword";

    auth.Company = "yourCompany";

    api.ApiAuthenticationValue = auth;

 

    //Create Request

    CreateTableFilterSettingsRequest req = new CreateTableFilterSettingsRequest();

 

    req.DestinationId = 1;

    req.FilterGroupId = TableGroupID.Misc;

    req.ColumnName = "1";

    req.SchemaName = "1";

    req.TableName = "1";

    req.FilterValue = "1";

 

    //Send Request to Server and Get Response

    CreateTableFilterSettingsResponse res = api.CreateTableFilterSettings(req);

 

    //Now examine the results:

}

catch (Exception ex)

{

    Console.WriteLine("Error: " + ex.Message);

}

VB.Net

Try

    'Create Main API Context Object

    Dim api as new ExigoApi()

 

    'Create Authentication Header

    Dim auth as new ApiAuthentication()

    auth.LoginName = "yourLoginName"

    auth.Password = "yourPassword"

    auth.Company = "yourCompany"

    api.ApiAuthenticationValue = auth

 

    'Create Request

    Dim req as new CreateTableFilterSettingsRequest()

 

    req.DestinationId = 1

    req.FilterGroupId = TableGroupID.Misc

    req.ColumnName = "1"

    req.SchemaName = "1"

    req.TableName = "1"

    req.FilterValue = "1"

 

    'Send Request to Server and Get Response

    Dim res As CreateTableFilterSettingsResponse = api.CreateTableFilterSettings(req)

 

    'Now examine the results:

Catch ex As Exception

    Console.WriteLine("Error: " & ex.Message)

End Try

PHP

Note: PHP is not officially supported.

<?php

try

{

    //Setup the SoapClient and Authentication

    $api = new SoapClient("http://api.exigo.com/3.0/ExigoApi.asmx?WSDL");

    $ns = "http://api.exigo.com/";

    $auth = array()

    $auth["LoginName"] = new SoapVar("yourLoginName",XSD_STRING,null,null,null,$ns);

    $auth["Password"] = new SoapVar("yourPassword",XSD_STRING,null,null,null,$ns);

    $auth["Company"] = new SoapVar("yourCompany",XSD_STRING,null,null,null,$ns);

    $headerBody = new SoapVar($auth, SOAP_ENC_OBJECT);

    $header = new SoapHeader($ns, 'ApiAuthentication', $headerBody);

    $api->__setSoapHeaders(array($header));

 

    //Create Request

 

    $req->DestinationId = 1;

    $req->FilterGroupId = 1;

    $req->ColumnName = "1";

    $req->SchemaName = "1";

    $req->TableName = "1";

    $req->FilterValue = "1";

 

    //Send Request to Server and Get Response

    $res = $api.CreateTableFilterSettings($req);

 

    //Now examine the results:

}

catch (SoapFault $ex)

{

    echo "Error: ", $ex->getMessage();

}

?>

Java

Note: Java is not officially supported.

try

{

    //Create Main API Context Object

    ExigoApi api = new ExigoApi();

 

    //Create Authentication Header

    ApiAuthentication auth = new ApiAuthentication();

    auth.setLoginName("yourLoginName");

    auth.setPassword("yourPassword");

    auth.setCompany("yourCompany");

    api.setApiAuthenticationValue(auth);

 

    //Create Request

    CreateTableFilterSettingsRequest req = new CreateTableFilterSettingsRequest();

 

    req.setDestinationId(1);

    req.setFilterGroupId(1);

    req.setColumnName("1");

    req.setSchemaName("1");

    req.setTableName("1");

    req.setFilterValue("1");

 

    //Send Request to Server and Get Response

    CreateTableFilterSettingsResponse res = api.getExigoApiSoap().createTableFilterSettings(req, auth);

 

    //Now examine the results:

}

catch (Exception ex)

{

    System.out.println("Error: " + ex.getMessage());

}

CSV

This method does not support csv output.