UpdateTableFilterSettings
Updates Table Filter Settings.Input Properties
UpdateTableFilterSettingsRequest
Output Properties
UpdateTableFilterSettingsResponse
Http Request
PATCH https://yourcompany-api.exigo.com/3.0/filtergroup/update HTTP/1.1 Content-Type: application/json Authorization: Basic base64Encoded(yourlogin@yourcompany:yourpassword){ "destinationId": 1, "filterGroupId": null, "columnName": "1", "schemaName": "1", "tableName": "1", "filterValue": "1" }
Http Response
HTTP/1.1 200 OK Content-Type: application/json; charset=utf-8 Content-Length: length{ "result": null }
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: sandboxapi2.exigo.com Content-Type: text/xml; charset=utf-8 Content-Length: length SOAPAction: "https://api.exigo.com/UpdateTableFilterSettings" <?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> <UpdateTableFilterSettingsRequest 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> </UpdateTableFilterSettingsRequest> </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> <UpdateTableFilterSettingsResult 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 UpdateTableFilterSettingsRequest();
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.UpdateTableFilterSettingsAsync(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
UpdateTableFilterSettingsRequest req = new UpdateTableFilterSettingsRequest();
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
UpdateTableFilterSettingsResponse res = api.UpdateTableFilterSettings(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 UpdateTableFilterSettingsRequest()
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 UpdateTableFilterSettingsResponse = api.UpdateTableFilterSettings(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.UpdateTableFilterSettings($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
UpdateTableFilterSettingsRequest req = new UpdateTableFilterSettingsRequest();
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
UpdateTableFilterSettingsResponse res = api.getExigoApiSoap().updateTableFilterSettings(req, auth);
//Now examine the results:
}
catch (Exception ex)
{
System.out.println("Error: " + ex.getMessage());
}