Temenos banking API support OData protocol. Querying data from data service you need query options, these query options called filters. These filters can be used a query parameters.
The default URL of IRIS Data service is:
http://127.0.0.1/Prospect-iris/Prospect.svc/GB0010001/enqCustomerInfos()?$filter=CusNo eq ‘66052’
|—————————————–Service Root———————————————–|———SD———|———Resource Name——|—————————Filters————————|
NOTE: GB0010001 is company name and T24 specific and SD stands for Service Document
System query options are prefixed with $ character, these filter options are used to control the amount
and order of the data. IRIS Data Service supports following System query options – all the filters self-explanatory
according to name.
| Filter |
Name |
Example |
| eq |
Equal |
/GB0010001/enqCustomerInfos()?$filter=CusNo eq ‘66052’ |
| ne |
Not Equal |
/GB0010001/enqCustomerInfos()?$filter=CusNo ne ‘66052’ |
| le |
Less Then |
/GB0010001/enqCustomerInfos()?$filter=Sector le ‘1000’ |
| gt |
Greater Then |
/GB0010001/enqCustomerInfos()?$filter=Sector gt ‘2000’ |
| ge |
Greater then and Equal |
/GB0010001/enqCustomerInfos()?$filter=Sector ge ‘2000’ |
| le |
Less then and Equal |
/GB0010001/enqCustomerInfos()?$filter=Sector le ‘1000’ |
| or |
Logical or |
/GB0010001/enqCustomerInfos()?$filter=Sector eq ‘1000’ or Sector eq ‘1000’ |
| and |
Logical and |
/GB0010001/enqCustomerInfos()?$filter=Sector eq ‘1000’ and AccountOfficer eq ‘1’ |
| Filter |
Name |
Example |
| (default) |
Ascending |
/GB0010001/enqCustomerInfos()?$orderby=Sector |
| asc |
Ascending |
/GB0010001/enqCustomerInfos()?$orderby=Sector asc |
| eq |
Descending |
/GB0010001/enqCustomerInfos()?$orderby=Sector desc |
| Example |
| /GB0010001/enqCustomerInfos()?$select=CusNo |
| /GB0010001/enqCustomerInfos()?$select=CusNo,Mnem |
| /GB0010001/enqCustomerInfos(‘66052’)?$select=CusNo,Mnem |
| Example |
| /GB0010001/enqCustomerInfos()?$top=5 |
| /GB0010001/enqCustomerInfos()?$top=5&$select=CusNo,Mnem |
| /GB0010001/enqCustomerInfos()?$top=5&$select=CusNo,Mnem&$orderby=CusNo desc |
| Example |
| /GB0010001/enqCustomerInfos()?$skip=1 |
| /GB0010001/enqCustomerInfos()?$skip=5&$select=CusNo,Mnem |
| /GB0010001/enqCustomerInfos()?$skip=5&$select=CusNo,Mnem&$orderby=CusNo desc |
| Example |
| /GB0010001/enqCustomerInfos()?$top=10 OR /GB0010001/enqCustomerInfos()?$skip=0&$top=10 |
| /GB0010001/enqCustomerInfos()?$skip=10&$top=10 |
| /GB0010001/enqCustomerInfos()?$skip=20&$top=10 |