﻿<?xml version="1.0" encoding="utf-8"?>
<ConnectionManager Name="Stonex" RuntimeVersion="" Help="http://www.cozyroc.com/ssis/stonex-connection" xmlns="http://www.cozyroc.com/schema/rcm-config-1.0.xsd">
	<Service EndPoint="https://api.stonex.com" />

	<Authentication Name="Basic">
		<Documentation>https://developer.stonex.com/apis/detail/authentication</Documentation>

		<User>
			<Parameter Name="Username">
				<Documentation>Required. Specify the username.</Documentation>
			</Parameter>
			<Parameter Name="Password" Type="password">
				<Documentation>Required. Specify the password.</Documentation>
			</Parameter>
			<Parameter Name="SubscriptionKey" Type="password">
				<Documentation>Required. Specify the subscription key.</Documentation>
			</Parameter>
		</User>

		<Test Url="/global-activities/eod">
			<Parameters>
				<Parameter Name="pageSize" Value="1" Type="QueryString" />
			</Parameters>
		</Test>

		<Token Url="/authentication/login" Method="POST" Result="{{=response.accessToken}}">
			<Documentation>https://developer.stonex.com/apis/detail/authentication</Documentation>

			<Parameters>
				<Parameter Name="application/json" Value="{{={ username: connection.user.Username, password: connection.user.Password } }}" Type="Body" />
			</Parameters>

			<Refresh Url="/authentication/login" Method="POST" Result="{{=response.accessToken}}" Expiration="{{=Date.now() + (response.expirationInSeconds - 300) * 1000}}">
				<Documentation>https://developer.stonex.com/apis/detail/authentication</Documentation>

				<Parameters>
					<Parameter Name="application/json" Value="{{={ username: connection.user.Username, password: connection.user.Password } }}" Type="Body" />
				</Parameters>
			</Refresh>
		</Token>

		<Parameters>
			<Parameter Name="Authorization" Value="Bearer {{=token.Access}}" Type="HttpHeader" />
			<Parameter Name="Ocp-Apim-Subscription-Key" Value="{{=connection.user.SubscriptionKey}}" Type="HttpHeader" />
		</Parameters>
	</Authentication>

	<Resources>
		<Template>
			<Field Name="ShortText" DataType="DT_WSTR" Length="250" />
			<Field Name="LongText" DataType="DT_WSTR" Length="1000" />
			<Field Name="DateTime" DataType="DT_DBTIMESTAMP" />
			<Field Name="Date" DataType="DT_DBDATE" />
			<Field Name="Boolean" DataType="DT_BOOL" />

			<Resource Name="Base">
				<Read>
					<Parameters>
						<Parameter Name="pageNumber" Value="{{=parameters.iterator}}" />
						<Parameter Name="pageSize" Value="{{=parameters.batchSize}}" />
						<Parameter Name="_includeUserParameters" Value="{{=parameters}}" />
					</Parameters>

					<Iterator>
						<Next Value="{{=parseInt(parameters.iterator || 1) + 1}}" />
					</Iterator>
				</Read>

				<Create Method="POST">
					<Parameters>
						<Parameter Name="_includeUserParameters" Value="{{=parameters}}" />
						<Parameter Name="application/json" Value="{{=item}}" Type="Body" />
					</Parameters>
				</Create>

				<Update Method="PUT">
					<Parameters>
						<Parameter Name="_includeUserParameters" Value="{{=parameters}}" />
						<Parameter Name="application/json" Value="{{=item}}" Type="Body" />
					</Parameters>
				</Update>

				<Delete Method="DELETE" />
			</Resource>
		</Template>
	</Resources>
	<Script>
		<Module Name="Main">
			<![CDATA[
require('underscore');

]]>
		</Module>
	</Script>
</ConnectionManager>