Using a Import Endpoint

Browser

Go to the Browser of an Import Endpoint and select the Upload Tab.

To get to the Browser of an Import Endpoint, go to the Endpoints table list and click on the Globe Icon in the last column of the Import Endpoint which is connected to your created Data Collection.

 

The Browser will show you the Access Points on the left side of the selected Endpoint along with the connected Data Collections. On the right side you will see a list of files which were or still are uploaded to one of the connected Data Collections. Go to the Upload Tab you see above the list.

 

First you want to select a JSON or CSV file by clicking on or dragging a file to the drop section.

This will automatically fill the Name and Content Type field but you can change them at any time.

In this example a json file with the following data is used:

[
  {
    "id": 1,
    "sku": "sku-1",
    "lang": "de"
  },
  {
    "id": 2,
    "sku": "sku-2",
    "lang": "en"
  },
  {
    "id": 3,
    "sku": "sku-3",
    "lang": "fr"
  }
]

Do not forget that every record must have every Unique Key (in this case “id” and “sku”).

Use the Charset field to enter the correct encoding of your file. If you do not enter a encoding, UTF-8 is expected.

If you have multiple Data Collections connected to the Import Endpoint select the Data Collection you want to import to.

If you have only one Data Collections connected it is selected automatically.

You can change the Access Point by using the accordion of Access Points on the left side. The API Key of the Access Point has to be active.

The Import will use the Filter and the Format of the selected Access Point.

Now you can click the Upload button in the bottom right corner. If your upload was successful, you can switch back to the List tab where your file should be listed.

The Data Collection Record Count on the left side may not be up to date. To update the Record Count either go to the Data Collection table and reload all Data Collections or go to the editor of the Data Collection and click on the refresh button in the Number of Records field.

Upload Table List

The table list shows the metadata of all uploaded files.

Status

An upload can have one the following statuses:

Import Endpoint with Options

The options are the same options you can define in an Import Format.

Programming

If you want to program an upload you can use the URL with a POST method given in the Upload tab in the Import Endpoint Browser.

Query

You can set the name of the file and the options in the Query. If you have multiple Data Collections connected to the Import Endpoint you have to set the collection query with the Data Collection name as value.

?collection=<data-collection-name>&name=<name>&options[<options-key>]=<options-value>

Headers

The header expects a Content-Type of application/json or text/csv.
If you do not set the charset it uses the charset of the Import Format which defaults to UTF-8 if not defined.
For the Authorization you need an API Key of an Access Point in the Import Endpoint. You can get it from the API Key editor in the API Key field.

{
  "Content-Type": "<content-type>;charset=<charset>",
  "Authorization": "<api-key>"
}

Was this article helpful?

0 0

How can we improve this article?

Please submit the reason for your vote so that we can improve the article.

Name

Email

Submit