Skip to content
Permalink
master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Go to file
 
 
Cannot retrieve contributors at this time

REST API: POST imports

By sending an HTTP PUT request to the following URL it is possible to import data:

https://api.copernica.com/v3/imports?access_token=xxxx

Available parameters

The following parameters are available for the method.

  • database: The ID of the database.
  • name: Name of the import.
  • followups: Do we need to execute followups on (sub)profiles in the import? (true/false)
  • autostart: Do we need to execute the import immediately? (true/false)
  • rebuild: Do we need to rebuild the selections after the import? (true/false)
  • action: What is the action of the import? Options: add, update, update or add, ignore or add, delete.
  • keyFields: Array of key fields that are used in the import.
  • ignoreEmptyFields: Do we need to ignore empty fields in the import and keep the original values? (true/false)
  • removeMissing: Do we need to remove (sub)profiles from the database that are not in the import file? (true/false)
  • deleteTarget: When the action is delete you can define here what you want to remove. (profile/subprofile)
  • location: URL to the external location of the import file.
  • source: The data of the import if the import is not at an external location (string of array).
  • format: Optional parameter where you can set the format of the source when this is a string. (csv/json)
  • delimiter: Delimiter of the data. Required for CSV and non-array input. ("\t", ",", ";")

Note: default value is bold.

PHP example

The following example demonstrates how to use this method.

// dependencies
require_once('copernica_rest_api.php');

// change this to your access token
$api = new CopernicaRestAPI("your-access-token", 3);

// data to be sent to the api
$data = array(
	"database"	=> 1,
	"name"		=> "TestImport",
	"rebuild"	=> true,
	"action"	=> "update or add",
	"keyFields"	=> array("Email"),
	"format"	=> "json",
	"source"	=> '[
		{ 
			"Email": "support@copernica.com", 
			"Contactpersoon": "Jeroen" 
		}, 
		{ 
			"Email": "info@copernica.com", 
			"Contactpersoon": "Danny" 
		}
	]'
);

// do the call
$api->post("imports/", $data);

The example above requires the CopernicaRestApi class.

PHP example with subprofiles

The following example demonstrates how to use this method in combination with subprofiles:

// dependencies
require_once('copernica_rest_api.php');

// change this to your access token
$api = new CopernicaRestAPI("your-access-token", 3);

// data to be sent to the api
$data = array(
	"database"	=> 1,
	"name"		=> "TestImport",
	"rebuild"	=> true,
	"action"	=> "update or add",
	"keyFields"	=> array("Email", "Order.OrderID"),
	"format"	=> "json",
	"source"	=> '[
		{ 
			"Email": "support@copernica.com", 
			"Contactpersoon": "Jeroen",
			"Order.OrderID": "00001", 
			"Order.Status": "Completed" 
		}, 
		{ 
			"Email": "info@copernica.com", 
			"Contactpersoon": "Danny",
			"Order.OrderID": "00001", 
			"Order.Status": "Completed" 
		}
	]'
);

// do the call
$api->post("imports/", $data);

The example above requires the CopernicaRestApi class.

More information