<ConnectionManager Name="Plainview Projectplace" RuntimeVersion="" Help="http://www.cozyroc.com/ssis/plainview-projectplace-connection" xmlns="http://www.cozyroc.com/schema/rcm-config-1.0.xsd">
	<Service EndPoint="https://api.projectplace.com/1" />

	<Authentication Name="User" Cached="false">
		<Documentation>https://service.projectplace.com/apidocs/#articles/pageOAuth1.html</Documentation>

		<Test Url="/account" />

		<Token Url="{{=OA1a.getAuthorizationUrl(token, 'https://api.projectplace.com/initiate', 'https://api.projectplace.com/authorize')}}" Method="POST" Result="{{=OA1a.buildTokenStorage(response)}}">
			<Authorized Id="https://www.cozyroc.com/oauth_callback" Result="{{=OA1a.getAccessToken(response, token, 'https://api.projectplace.com/token')}}" />
		</Token>
		
		<Parameters>
			<Parameter Name="Authorization" Value="{{=OA1a.getAuthorizationHeader(token, request)}}" Type="HttpHeader" />
		</Parameters>
	</Authentication>
	
	<Resources>
		<Template>
			<Field Name="ShortText" DataType="DT_WSTR" Length="255" />
			<Field Name="LongText" DataType="DT_WSTR" Length="1000" />
			<Field Name="DateTime" DataType="DT_DBTIMESTAMP" />
			<Field Name="Date" DataType="DT_DBDATE" />
			
			<Resource Name="Base">
				<Read>
					<Parameters>
						<Parameter Name="count" Value="{{=parameters.batchSize}}" />
						<Parameter Name="offset" Value="{{=parameters.iterator}}" />
						<Parameter Name="_includeUserParameters" Value="{{=parameters}}" />
					</Parameters>

					<Iterator>
						<Next Value="{{=parseInt(parameters.iterator || 0) + parameters.batchSize}}" />
					</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");
require('sha1');
require('underscore.string')
_.mixin(s.exports());
require('big');
require('base64');
require('oauth1');

b64pad = '=';

var OA1a = new OAuth1({ 
	consumerCallback: "https://www.cozyroc.com/oauth_callback",
	consumerKey: "a5eb96f5a83767978b34e6a5247f9e37",
	consumerSecret: "e035efa241c39d5a5cfcf364ff91f146ef8e99e9",
	signMethod: 'HMAC-SHA1',
	signProc: function (toSign, secrets) {
		return b64_hmac_sha1(_.map(secrets, encodeURIComponent).join('&'), toSign);
	}
});
		]]>
		</Module>
	</Script>
</ConnectionManager>