CSV

Method Description

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

POST https://api.maestra.io/v3/operations/bulk?endpointId={API endpoint ID}&operation=DirectCrm.Retail.ImportProductCategories&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.

Field Descriptions

Title	Description
CategoryExternalId	Category ID
ParentCategoryExternalId	Parent category ID
Name	Category name

Sample Request

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

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


CategoryExternalId;ParentCategoryExternalId;Name
1;;Audio, video
2;1;CRT TVs
3;1;TVs
4;1157;DVD Players
5;1156;Home Theaters
6;1155;Headsets
7;1158;TV Mounts
8;1156;Audio Systems
9;1155;MP3 Players
10;1156;Sound
12;1156;Car Sound