﻿<?xml version="1.0" encoding="utf-8"?>
<ConnectionManager Name="Sage 200" RuntimeVersion="" Help="http://www.cozyroc.com/ssis/sage-200-connection" xmlns="http://www.cozyroc.com/schema/rcm-config-1.0.xsd">
	<Service EndPoint="https://api.columbus.sage.com/uk/sage200extra/accounts/v1" />

	<Authentication Name="OAuth">
		<Documentation>https://developer.sage.com/200/guides/authenticating/</Documentation>

		<User>
			<Parameter Name="client_id">
				<Documentation>Required. Identifier of application that is associated with the authentication token.</Documentation>
			</Parameter>
			<Parameter Name="client_secret">
				<Documentation>Specify application client secret. Optional.</Documentation>
			</Parameter>
			<Parameter Name="subscription_id">
				<Documentation>Required. Specify the subscription identifier.</Documentation>
			</Parameter>
			<Parameter Name="company_id">
				<Documentation>Required. Specify the company identifier.</Documentation>
			</Parameter>
			<Parameter Name="site_id">
				<Documentation>Required. Specify the site identifier.</Documentation>
			</Parameter>
			<Parameter Name="redirect_uri" Default="https://www.cozyroc.com/oauth_callback">
				<Documentation>Required. Specify redirect_uri.</Documentation>
			</Parameter>
			<Parameter Name="scope" Default="openid profile email offline_access">
				<Documentation>Required. Specify the desired scopes.</Documentation>
			</Parameter>
		</User>

		<Test Url="/current_user/" />

		<Token Url="{{=OAuth2.authorize_url}}" Result="{{=response.access_token}}">
			<Documentation>https://developer.sage.com/200/guides/authenticating/</Documentation>

			<Parameters>
				<Parameter Name="response_type" Value="code" />
				<Parameter Name="audience" Value="s200ukipd/sage200" />
				<Parameter Name="client_id" Value="{{=token.client_id}}" />
				<Parameter Name="scope" Value="{{=token.scope()}}" />
				<Parameter Name="redirect_uri" Value="{{=token.redirect_uri}}" />
				<Parameter Name="state" Value="{{=oauth2.getState()}}" />
			</Parameters>

			<Authorized Id="{{=token.redirect_uri}}" Result="{{=
				connection.execute({
					url: OAuth2.access_token_url,
					method: OAuth2.access_token_method,
					parameters: {
						grant_type: 'authorization_code',
						code: response.code,
						client_id: token.client_id,
						client_secret: token.client_secret,
						scope: token.scope,
						redirect_uri: token.redirect_uri
				} })
			}}" />

			<Refresh Url="{{=OAuth2.refresh_token_url}}" Method="POST" Result="{{=response.refresh_token}}" Expiration="{{=Date.now() + (response.expires_in - 300) * 1000}}">
				<Documentation>https://developer.sage.com/200/guides/authenticating/</Documentation>

				<Parameters>
					<Parameter Name="grant_type" Value="refresh_token" />
					<Parameter Name="client_id" Value="{{=token.client_id}}" />
					<Parameter Name="client_secret" Value="{{=token.client_secret}}" />
					<Parameter Name="refresh_token" Value="{{=token.Refresh}}" />
				</Parameters>
			</Refresh>
		</Token>

		<Parameters>
			<Parameter Name="Authorization" Value="Bearer {{=token.Access}}" Type="HttpHeader" />
			<Parameter Name="ocp-apim-subscription-key" Value="{{=token.subscription_id}}" Type="HttpHeader" />
			<Parameter Name="X-Company" Value="Bearer {{=token.company_id}}" Type="HttpHeader" />
			<Parameter Name="X-Site" Value="Bearer {{=token.site_id}}" 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="page" Value="{{=parameters.iterator}}" />
						<Parameter Name="items_per_page" Value="{{=parameters.batchSize}}" />
						<Parameter Name="_includeUserParameters" Value="{{=parameters}}" />
					</Parameters>

					<Iterator>
						<Next Value="{{=parseInt(parameters.iterator || 1) + 1}}">
							<Documentation>https://developer.sage.com/accounting/guides/efficiencies/pagination/</Documentation>
						</Next>
					</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>
		<Module Name="OAuth 2">
			<![CDATA[
require('oauth2');

var OAuth2 = {
	authorize_url: 'https://id.sage.com/authorize',
	access_token_url: 'https://id.sage.com/oauth/token',
	access_token_method: 'POST',
	refresh_token_url: 'https://id.sage.com/oauth/token'
};
]]>
		</Module>
	</Script>
</ConnectionManager>