<ConnectionManager Name="Epicor" RuntimeVersion="" Help="http://www.cozyroc.com/ssis/epicor-connection" xmlns="http://www.cozyroc.com/schema/rcm-config-1.0.xsd">
	<Service EndPoint="https://[ServerHost]/[ServerInstance]/api/v1" />
	<Authentication Name="Basic">
		<Documentation>https://en.wikipedia.org/wiki/Basic_access_authentication</Documentation>
		<User>
			<Parameter Name="Name" />
			<Parameter Name="Password" Type="password" />
			<Parameter Name="Company" />
			<Parameter Name="Plant" />
		</User>
		<Test Url="/WhoAmI" />
		<Parameters>
			<Parameter Name="Authorization" Value="Basic {{=Base64.encode(connection.user.Name + ':' + connection.user.Password)}}" Type="HttpHeader" />
			<Parameter Name="CallSettings" Value="{{={ Company: connection.user.Company, Plant: connection.user.Plant } }}" Type="HttpHeader" />
		</Parameters>
	</Authentication>
	<Authentication Name="Azure Token">
		<Documentation>https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/authenticate-oauth</Documentation>
		<User>
			<Parameter Name="ApplicationID" />
		</User>
		<Test Url="/WhoAmI" />
		<Token Url="https://login.microsoftonline.com/common/oauth2/authorize" Result="{{=response.access_token}}">
			<Documentation>https://docs.microsoft.com/en-us/azure/active-directory/develop/v2-oauth2-auth-code-flow#request-an-access-token</Documentation>
			<Parameters>
				<Parameter Name="client_id" Value="{{=connection.user.ApplicationID}}" />
				<Parameter Name="response_type" Value="code" />
				<Parameter Name="redirect_uri" Value="urn:ietf:wg:oauth:2.0:oob" />
				<Parameter Name="prompt" Value="consent" />
			</Parameters>
			<Authorized Id="urn:ietf:wg:oauth:2.0:oob" Result="{{=connection.execute({
				url: 'https://login.microsoftonline.com/common/oauth2/token',
				method: 'POST',
				parameters: {
					code: response.code,
					grant_type: 'authorization_code',
					client_id: connection.user.ApplicationID,
					resource: new Uri(connection.serverHost).authority(),
					redirect_uri: 'urn:ietf:wg:oauth:2.0:oob'
				}
			})}}" />
			<Refresh Url="https://login.microsoftonline.com/common/oauth2/token" Method="POST" Result="{{=response.refresh_token}}" Expiration="{{=Date.now() + (response.expires_in - 300) * 1000}}">
				<Documentation>https://docs.microsoft.com/en-us/azure/active-directory/develop/v2-oauth2-auth-code-flow#request-an-access-token</Documentation>
				<Parameters>
					<Parameter Name="refresh_token" Value="{{=token.Refresh}}" />
					<Parameter Name="grant_type" Value="refresh_token" />
					<Parameter Name="client_id" Value="{{=connection.user.ApplicationID}}" />
					<Parameter Name="resource" Value="{{=new Uri(connection.serverHost).authority()}}" />
					<Parameter Name="redirect_uri" Value="urn:ietf:wg:oauth:2.0:oob" />
				</Parameters>
			</Refresh>
		</Token>
		<Parameters>
			<Parameter Name="Authorization" Value="Bearer {{=token.Access}}" Type="HttpHeader" />
		</Parameters>
	</Authentication>
	<Authentication Name="Session Token">
		<User>
			<Parameter Name="Name" />
			<Parameter Name="Password" Type="password" />
		</User>
		<Test Url="/WhoAmI" />
		<Token Url="/TokenResource.svc" Result="{{=response.access_token}}">
			<Parameters>
				<Parameter Name="username" Value="{{=connection.user.Name}}" />
				<Parameter Name="password" Value="{{=connection.user.Password}}" />
			</Parameters>
		</Token>
		<Parameters>
			<Parameter Name="Authorization" Value="Bearer {{=token.Access}}" 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" />
			<Resource Name="Base">
				<Read>
					<Parameters>
						<Parameter Name="$skiptoken" Value="{{=parameters.iterator}}" />
						<Parameter Name="Prefer" Value="odata.include-annotations=&quot;OData.Community.Display.V1.FormattedValue&quot;, odata.maxpagesize={{=parameters.batchSize}}" Type="HttpHeader" />
						<Parameter Name="_includeUserParameters" Value="{{=parameters}}" />
					</Parameters>
					<Iterator>
						<Next Value="{{=new Uri(response['@odata.nextLink']).getQueryParamValue('$skiptoken')}}" />
					</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="Basic">
			<![CDATA[
require('base64');

]]>
		</Module>
		<Module Name="Azure Token">
			<![CDATA[
require('Uri');

]]>
		</Module>
	</Script>
</ConnectionManager>