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=ImportProducts&csvCodePage=65001&externalSystem={External system ID}&transactionId={Idempotency key value in GUID format}

Authorization: SecretKey {Secret Key}
Accept: application/json
Content-Type: text/csv;charset=utf-8

• 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.
• TransactionId: an idempotency key used to prevent duplicate request execution. The key must be generated in GUID format (version 4 is recommended). For repeated requests with the same key, the response will return the status TransactionAlreadyProcessed.
• 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.
• The maximum file size accepted is 200 MB. If you need to upload a larger amount of data, it should be split into multiple files.

Fields Description

Request Example

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

Authorization: SecretKey pcSKXcJ3D
Accept: application/json
Content-Type: text/csv;charset=utf-8


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,,