Description

SIXP Resource Locators

For information about tables, their field structure and more, see Tables and Fieldsets.

SIXPRL syntax

	Table name		Field groups	Filter expression	Comment
syntax	/type	/table	[group[+group[...]]]	[?[expression]]	Avaliable tables, field groups and fields here: Tables and Fieldsets. Note that only fields marked with "q" are allowed in the filter expression. See also Special expressions below.
	/rt				Normal tables
	/hist				Daylogs. All changes to a base record during one day. The filter must specify a single base record. Every change results in a new complete record. The table is cleared during the night. The fieldset is limited to the fields marked by "dl" here: Tables and Fieldsets.
	/hist	/news			News table. See /hist/news (and /rt/news). This is not a daylog. Records are removed periodically in order to limit the number of articles in the server.
	/samp				Sampled tables, see Sampled tables fieldset
	/feed				Like /hist/... but without any initial data and without the limit of one underlying record.
examples	/rt	/stock/	info+quote	?Mkt="SSE"
	/rt	/stock/trade		?Mkt="SSE"	Note: trade is part of the table name. It is not a field group.

Note: Table name and Field groups affects the field set returned by the server. Filter expression does not.

Example:

Field groups

Tables with a lot of fields have "field groups". These tables have names with a / at the end. If you don't want all field groups you can specify them at the end: table_name/[field_group[+field_group[...]]]. Example:

/rt/derivative/ (alternative alias: /rt/derivative/all)
/rt/derivative/quote
/rt/derivative/quote+info+hist

Example:

/rt/derivative/quote+info?Mkt="SSE"

Field names

In SIXP version 4 you had to use the form group.Field to specify a field in a related table. Example: /rt/derivative/quote?info.Ty3="IDX". In SIXP version 5 this is still allowed but not necessary. Example: /rt/derivative/quote?Ty3="IDX".

Filter expressions

Operator	Precedence	Description
=	1 (highest)	Equal
<>	1	Not equal
<	1	Less
>	1	Greater
<=	1	Not greater
>=	1	Not less
><	1	True if the right operand is part of the left operand. Only valid for strings. Not case-sensitive.
!	2	Logical negation
&	3	Logical-AND
\|	4 (lowest)	Logical-OR

Parentheses are allowed. The relational and equality operators have a field name as the left operand and a constant value (within "") as the right operand. If any operand is NULL the result is false. Boolean fields are used with = or <> and the values "true" or "false".

Warning: Do not use the filters in a way so that records constantly come and go, like /rt/stock/quote?VoA<1000, as this will cause the whole record to be sent each time VoA drops below 1000. The network traffic will be high and the server is also not optimized for lots of inserts and deletes of records. Later versions of the server are normally configured to block these kind of queries.

Example:

/rt/stock/quote?Mkt<>"SSE"&Mkt<>"OSE"&Mkt<>"CSE"&Mkt<>"HEX"&Mkt<>"ICEX"&Mkt<>"SSEFN"&Mkt<>"NGM"&Mkt<>"BURG"

Special expressions

These expressions can only be combined with the &-operator in the beginning or end of the filter and not within parantheses.

Expression	Description	Applies to
~fields=Field1,Field2,...	Only the listed fields are sent to the client. This does not affect the fieldset. Fields that are not listed appears as if they are null.	all except /samp/...
~count="n"	To limit a /hist/... table to the n latest records.	/hist/... except /
~field=Field	The field to sample.	/samp/...
~sample="interval"	Sample interval in seconds.	/samp/...

More examples

SIXPRL	Description
/rt/stock/quote?Mkt="SSE"\|Mkt="CSE"	all quotes on both SSE and CSE
/rt/forex/quote?(Ccy1="USD"\|Ccy1="EUR")&Ccy2="SEK"	all quotes for USD/SEK and EUR/SEK
/hist/news?Src="/portals/0/DJ"&Subj><"dollar"	all news from DowJones where the word "dollar" is in the headline
/hist/news?Src="/portals/0/DJ"&!Subj><"press release"	all news from DowJones except those with "press release" in the headline