Read import

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…

Definition

The API enables vendors, plugins and enterprise clients to manage Imports externally by API. It adds the option to automate data flow by service instead of a manual user process. Utilizing the API can significantly shorten the time to import, which is useful for external plugins.

You may make use of Management API for Imports by:

  • Copying import definition from one project to another.
  • Deploying the same import to multiple projects by a script.

Management API for Imports exposes API methods to list, read, create, and delete import definitions. *Read** operation retrieves the whole import definition of an already existing import. This can be used to create a new import.

Authorization

In this API call you must use the following authorization access and permissions:

Available access typePermissions needed
Private accessImports > Allow to Read Imports

Admin must first create Private access keys and grant permissions. Then the service can call the API and perform the operation.

Read more about:

Request

Path parameters

ParameterTypeDescriptionRequired
import_idstringThe ID of your import.Required
projectTokenstringThe ID of your project.Required

Response description

ParameterTypeDescriptionRequired
importobjectGeneral metadata object about import.Optional

Import object description

ParameterTypeDescriptionRequired
import_idstringThe ID of your import.Required
import_definitionobjectThe definition of your import.Optional

Import_definition object description

ParameterTypeDescriptionRequired
namestringThe name of your import.Required
triggerone of: objectThe trigger for import either now, or repeated based on frequency or new files.Required
activebooleanDefault: trueOptional
sourceone of: objectThe source of imported data.Required
destinationone of: objectThe destination where data is imported.Required
mappingobjectData mapping pattern of your import.Required

Trigger object description

Trigger can be defined by one of the two object descriptions:

(1) First trigger object description option:

ParameterTypeDescriptionRequired
trigger_typestring

Type of the trigger.

Allowed values: now, on_new_file

Required

(2) Second trigger object description option:

ParameterTypeDescriptionRequired
trigger_typestringType of the trigger.Required
frequencystring

The frequency in which imports are triggered.

Allowed values: hourly, daily, weekly, monthly

Required
timesarrayk:parame<= 48 itemsRequired
daysarray (oneOf) ers]
{
"dat or
array (oneOf) "h-0": "Pa
The days on which imports are triggered.Optional
minutesarrayk:parametRequired
timezonestringTimezone in which time of trigger is set.Required
from_datenumber<float>From which date imports are triggered.Optional
to_datenumber<float>To which date imports are triggered.Optional

Times object description

ParameterTypeDescriptionRequired
hourinteger>= 0, <= 23Required
minuteinteger>= 0, <= 59Required

Source object description

Source can be defined by one of the two object descriptions:

(1) First source object description option:

ParameterTypeDescriptionRequired
source_typestringAllowed value: urlRequired
import_urlstringRequired
use_socks_proxybooleanDefault: falseOptional
authobjectOptional

(2) Second source object description option:

ParameterTypeDescriptionRequired
source_typestringAllowed value: filestorageRequired
integration_idstring

The ID of your integration.

>= 24 characters

Required
parent_pathstringOptional
pathstring>= 1 charactersRequired
file_selectionstringAllowed values: all, last_mod, last_alpha, not_importedRequired

Auth object description

ParameterTypeDescriptionRequired
usernamestringRequired
passwordstringRequired

Destination object description

Destination can be defined by one of the three object descriptions:

(1) First destination object description option:

ParameterTypeDescriptionRequired
event_destinationobjectA specific event type into which you import data.Required

(2) Second destination object description option:

ParameterTypeDescriptionRequired
customer_destinationobjectThe customer table where you import data.Required

(3) Third destination object parameter option:

ParameterTypeDescriptionRequired
catalog_destinationobjectThe catalog into which you import data.Required

Event_destination object description

ParameterTypeDescriptionRequired
event_typestring>= 1 charactersOptional
event_triggersbooleanDefault: falseOptional

Catalog_destination object description

ParameterTypeDescriptionRequired
catalog_namestringName of the catalog into which you import data.Required
catalog_attributesone of: objectOptional

Catalog_attributes object description

Catalog_attributes can be defined by one of the two object descriptions:

(1) First catalog_attributes object description option:

ParameterTypeDescriptionRequired
catalog_typestringAllowed values: generic, product, variantsRequired

(2) Second catalog_attributes object description option:

ParameterTypeDescriptionRequired
catalog_typestringAllowed values: generic, product, variantsRequired
associated_product_catalog_idstringThe ID of your product catalog.Optional

Mapping object description

ParameterTypeDescriptionRequired
tz_infostring

The timezone to use for time/datetime/timestamp columns.

Default: UTC

Optional
column_mappingobjectRequired

Column_mapping object description

ParameterTypeDescriptionRequired
id_mappingsarrayk:parameThe ID of your mappings.Required
property_mappingsarrayk:parameRequired
timestamp_columnstringOptional

Id_mappings object description

ParameterTypeDescriptionRequired
from_columnstringRequired
to_idstringRequired

Property_mappings object description

ParameterTypeDescriptionRequired
from_columnstringOptional
to_columnstringRequired
target_typestringDefault: stringOptional
searchablebooleanOptional
indexedstringOptional
❗️

Limitations

  • Update API method is not implemented.
  • You cannot create an import for Vouchers.
  • You cannot create import of other types (e.g. from Input/Uploaded file, from Database by query, from the application).
  • Managing import definitions created by Users is done in the app (not via API).
  • API does not work with unsupported import types. This impacts all API operations. For example, you cannot List/Read/Create Copy&Paste import.

API rate limits:

  • The joint number of requests for operations 'List', 'Read', and 'Delete' cannot exceed 100 requests per minute.
Path Params
string
required
string
required
Headers
string
enum
Defaults to application/json
Allowed:
Responses

Language
Credentials
Basic
base64
:
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json

© Bloomreach, Inc. All rights reserved.