2,743
edits
AOTG API: Creditor Lookup: Difference between revisions
no edit summary
(Created page with "{{DRAFT}} ==Creditor Lookup== Get a list of supplier. {{AOTGApiMethodsSpec|GET|/api/public/v1/Lookup/CreditorLookup|Params=$filter, $top}} <br/> ==Code Snippets== *Add header...") |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
Line 1:
==Creditor Lookup==
Get a list of supplier.
Line 182 ⟶ 181:
Use parameter of $filter or $top to filter the result of creditor.
*Below sample uses 3 conditions to '''filter''' the result
*#Creditor code that contains "400-x003", and convert all characters to small letter.
*#Currency of the creditor is "USD"
*#Customer who is still active
<pre>
http://aotg.cloud:8080/api/public/v1/Lookup/CreditorLookup?$filter=(substringof('400-x003',tolower(AccNo)) or CurrencyCode eq 'USD') and IsActive eq true
</pre>
===Code Snippets===
{{AOTGApiCodeSnippetTab
|Python=
<syntaxhighlight lang="Python">
import requests
url = "http://aotg.cloud:8080/api/public/v1/Lookup/CreditorLookup"
querystring = {"$filter":"%28substringof%28%27400-x003%27,tolower%28AccNo%29%29%20or%20CurrencyCode%20eq%20%27USD%27%29%20and%20IsActive%20eq%20true"}
payload = ""
headers = {
'SOTC_AUTH': "SAMs1a36d2-a139-e911-b8b3-000aa03t3d",
'Content-Type': "application/json",
'cache-control': "no-cache"
}
response = requests.request("GET", url, data=payload, headers=headers, params=querystring)
print(response.text)
</syntaxhighlight>
|PHPHttp=
<syntaxhighlight lang="PHP">
<?php
$request = new HttpRequest();
$request->setUrl('http://aotg.cloud:8080/api/public/v1/Lookup/CreditorLookup');
$request->setMethod(HTTP_METH_GET);
$request->setQueryData(array(
'$filter' => '%28substringof%28%27400-x003%27,tolower%28AccNo%29%29%20or%20CurrencyCode%20eq%20%27USD%27%29%20and%20IsActive%20eq%20true'
));
$request->setHeaders(array(
'cache-control' => 'no-cache',
'Content-Type' => 'application/json',
'SOTC_AUTH' => 'SAMs1a36d2-a139-e911-b8b3-000aa03t3d'
));
try {
$response = $request->send();
echo $response->getBody();
} catch (HttpException $ex) {
echo $ex;
}
</syntaxhighlight>
|RestSharp=
<syntaxhighlight lang="C#">
var client = new RestClient("http://aotg.cloud:8080/api/public/v1/Lookup/CreditorLookup?$filter=%28substringof%28%27400-x003%27,tolower%28AccNo%29%29%20or%20CurrencyCode%20eq%20%27USD%27%29%20and%20IsActive%20eq%20true");
var request = new RestRequest(Method.GET);
request.AddHeader("cache-control", "no-cache");
request.AddHeader("Content-Type", "application/json");
request.AddHeader("SOTC_AUTH", "SAMs1a36d2-a139-e911-b8b3-000aa03t3d");
IRestResponse response = client.Execute(request);
</syntaxhighlight>
|PHPcURL=
<syntaxhighlight lang="PHP">
<?php
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_PORT => "8080",
CURLOPT_URL => "http://aotg.cloud:8080/api/public/v1/Lookup/CreditorLookup?$filter=%28substringof%28%27400-x003%27,tolower%28AccNo%29%29%20or%20CurrencyCode%20eq%20%27USD%27%29%20and%20IsActive%20eq%20true",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_POSTFIELDS => "",
CURLOPT_HTTPHEADER => array(
"Content-Type: application/json",
"SOTC_AUTH: SAMs1a36d2-a139-e911-b8b3-000aa03t3d",
"cache-control: no-cache"
),
));
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}
</syntaxhighlight>
}}
| |||