CSV

Method Description

The operation is done via POST request. Request address can be obtained via Maestra. Product IDs in this CSV file should match product IDs transferred in product-related operations.

POST https://api.maestra.io/v3/operations/bulk?endpointId={API endpoint ID}&operation=DirectCrm.Retail.ImportProducts&csvCodePage=65001
HTTP/1.1

Authorization: SecretKey {Secret Key}
Accept: application/xml
Content-Type: text/csv

csvCodePage: Windows codepage ID for CSV file. 65001 (UTF-8) is preferred.
csvColumnDelimiter: Column delimiter symbol in CSV file.
csvTextQualifier: Optional start/end character in column value, masking otherwise invalid characters.
Authorization key: The value is obtained via Maestra.
The service allows up to 60 imports per hour. When this limit is exceeded, you’ll receive 429 Too Many Requests until the ratio of tasks queued/hour drops below 60.

Fields Description

Title	Description
ExternalId	Product ID
Name	Product name
Description	Product description
CategoryExternalId	Product category ID
PictureUrl	Link to product image
IsAvailable	Product availability (true/false)
Url	Link to product webpage

Request Example

POST https://api.maestra.io/v3/operations/bulk?endpointId=Maestra&operation=DirectCrm.Retail.ImportProducts&csvCodePage=65001

Authorization: SecretKey pcSKXcJ3D
Accept: application/xml
Content-Type: text/csv


ExternalId;Name;CategoryExternalId;ManufacturerName;IsAvailable;Price;PictureUrl;Url
89;Kenwood KDC-W707Y Car Audio;50;Kenwood;;;;
105;Panasonic CJ-A1323N Coaxial Car Audio Kit;40;Panasonic;;;;
169;Philips HD4665/20 Electric Kettle;27;Philips;1;4390;;
219;Rolsen C21SR74NT TV;3;Rolsen;;;;
242;Electrolux EWC 1350 Washing Machine;18;Electrolux;;;;
274;Alpine CDA-9857R Car Audio;50;Alpine;;;;
299;Rowenta CF2012 Curling Iron;1221;Rowenta;1;1660;;