<ConnectionManager Name="Workbooks" RuntimeVersion="" Help="http://www.cozyroc.com/ssis/workbooks-connection" xmlns="http://www.cozyroc.com/schema/rcm-config-1.0.xsd">
	<Service EndPoint="https://secure.workbooks.com" />

	<Authentication Name="Session">
		<Documentation>https://github.com/workbooks/client_lib</Documentation>

		<User>
			<Parameter Name="APIKey">
				<Documentation>Required. Specify API key.</Documentation>
			</Parameter>
		</User>

		<Test Url="/crm/cases.api?_limit=2" />

		<Token Url="/login.api" Method="POST" Result="{{=response.session_id}}">
			<Parameters>
				<Parameter Name="api_key" Value="{{=connection.user.APIKey}}"/>
				<Parameter Name="client" Value="api"/>
				<Parameter Name="api_version" Value="1"/>
			</Parameters>

			<Refresh Url="/login.api" Method="POST" Result="{{=response.session_id}}" Expiration="{{=Date.now() + (28800 - 300) * 1000}}">
				<Parameters>
					<Parameter Name="api_key" Value="{{=connection.user.APIKey}}"/>
					<Parameter Name="client" Value="api"/>
					<Parameter Name="api_version" Value="1"/>
				</Parameters>
			</Refresh>
		</Token>

		<Parameters>
			<Parameter Name="Workbooks-Session" Value="{{=token.Access}}" Type="Cookie" />
		</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="_start" Value="{{=parameters.iterator}}" />
						<Parameter Name="_limit" Value="{{=parameters.batchSize}}" />
						<Parameter Name="_includeUserParameters" Value="{{=parameters}}" />
					</Parameters>

					<Iterator>
						<Next Value="{{=parseInt(parameters.iterator || 0) + parameters.batchSize}}">
							<Documentation>https://github.com/workbooks/client_lib#limiting-your-query</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">
					<Parameters>
						<Parameter Name="_includeUserParameters" Value="{{=parameters}}" />
						<Parameter Name="application/json" Value="{{=item}}" Type="Body" />
					</Parameters>
				</Delete>
			</Resource>
		</Template>
	</Resources>
	<Script>
		<Module Name="Main">
			<![CDATA[
require('underscore');

]]>
		</Module>
	</Script>
</ConnectionManager>