<ConnectionManager Name="WooCommerce" RuntimeVersion="" Help="http://www.cozyroc.com/ssis/woocommerce-connection" xmlns="http://www.cozyroc.com/schema/rcm-config-1.0.xsd">
	<Service EndPoint="https://[ServerHost]/wp-json/wc/v3" />
	<Authentication Name="Basic" Cached="false">
		<Documentation>https://woocommerce.github.io/woocommerce-rest-api-docs/#authentication</Documentation>
		<User>
			<Parameter Name="ConsumerKey" />
			<Parameter Name="ConsumerSecret" Type="password" />
		</User>
		<Test Url="/system_status" />
		<Parameters>
			<Parameter Name="Authorization" Value="Basic {{=Base64.encode(connection.user.ConsumerKey + ':' + connection.user.ConsumerSecret)}}" 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 Result="{{=response}}">
					<Parameters>
						<Parameter Name="page" Value="{{=parameters.iterator}}" />
						<Parameter Name="per_page" 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");
require("base64");
]]>
		</Module>
	</Script>
</ConnectionManager>