curl --request POST \
--url https://api.merchantops.ai/api/products/export \
--header 'Content-Type: application/json' \
--data '
{
"product_keys": [
"<string>"
],
"column_mappings": [
{
"column_name": "<string>",
"source_field": "<string>",
"sub_field": "<string>",
"use_label": false
}
],
"export_format": "xlsx",
"export_mode": "attribute_rows",
"filter_by_label": false,
"filter_latest_version": false,
"label_keys": [
"<string>"
],
"source_filter": [
"<string>"
]
}
'import requests
url = "https://api.merchantops.ai/api/products/export"
payload = {
"product_keys": ["<string>"],
"column_mappings": [
{
"column_name": "<string>",
"source_field": "<string>",
"sub_field": "<string>",
"use_label": False
}
],
"export_format": "xlsx",
"export_mode": "attribute_rows",
"filter_by_label": False,
"filter_latest_version": False,
"label_keys": ["<string>"],
"source_filter": ["<string>"]
}
headers = {"Content-Type": "application/json"}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'Content-Type': 'application/json'},
body: JSON.stringify({
product_keys: ['<string>'],
column_mappings: [
{
column_name: '<string>',
source_field: '<string>',
sub_field: '<string>',
use_label: false
}
],
export_format: 'xlsx',
export_mode: 'attribute_rows',
filter_by_label: false,
filter_latest_version: false,
label_keys: ['<string>'],
source_filter: ['<string>']
})
};
fetch('https://api.merchantops.ai/api/products/export', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.merchantops.ai/api/products/export",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'product_keys' => [
'<string>'
],
'column_mappings' => [
[
'column_name' => '<string>',
'source_field' => '<string>',
'sub_field' => '<string>',
'use_label' => false
]
],
'export_format' => 'xlsx',
'export_mode' => 'attribute_rows',
'filter_by_label' => false,
'filter_latest_version' => false,
'label_keys' => [
'<string>'
],
'source_filter' => [
'<string>'
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.merchantops.ai/api/products/export"
payload := strings.NewReader("{\n \"product_keys\": [\n \"<string>\"\n ],\n \"column_mappings\": [\n {\n \"column_name\": \"<string>\",\n \"source_field\": \"<string>\",\n \"sub_field\": \"<string>\",\n \"use_label\": false\n }\n ],\n \"export_format\": \"xlsx\",\n \"export_mode\": \"attribute_rows\",\n \"filter_by_label\": false,\n \"filter_latest_version\": false,\n \"label_keys\": [\n \"<string>\"\n ],\n \"source_filter\": [\n \"<string>\"\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.merchantops.ai/api/products/export")
.header("Content-Type", "application/json")
.body("{\n \"product_keys\": [\n \"<string>\"\n ],\n \"column_mappings\": [\n {\n \"column_name\": \"<string>\",\n \"source_field\": \"<string>\",\n \"sub_field\": \"<string>\",\n \"use_label\": false\n }\n ],\n \"export_format\": \"xlsx\",\n \"export_mode\": \"attribute_rows\",\n \"filter_by_label\": false,\n \"filter_latest_version\": false,\n \"label_keys\": [\n \"<string>\"\n ],\n \"source_filter\": [\n \"<string>\"\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.merchantops.ai/api/products/export")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"product_keys\": [\n \"<string>\"\n ],\n \"column_mappings\": [\n {\n \"column_name\": \"<string>\",\n \"source_field\": \"<string>\",\n \"sub_field\": \"<string>\",\n \"use_label\": false\n }\n ],\n \"export_format\": \"xlsx\",\n \"export_mode\": \"attribute_rows\",\n \"filter_by_label\": false,\n \"filter_latest_version\": false,\n \"label_keys\": [\n \"<string>\"\n ],\n \"source_filter\": [\n \"<string>\"\n ]\n}"
response = http.request(request)
puts response.read_body{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>",
"ctx": {},
"input": "<unknown>"
}
]
}Export Products
Export products to Excel/CSV with custom column mapping (synchronous).
Use the async variant (/export-async) for large selections; this
endpoint streams the file inline and is intended for small selections.
Authentication Required: Requires product:read permission.
curl --request POST \
--url https://api.merchantops.ai/api/products/export \
--header 'Content-Type: application/json' \
--data '
{
"product_keys": [
"<string>"
],
"column_mappings": [
{
"column_name": "<string>",
"source_field": "<string>",
"sub_field": "<string>",
"use_label": false
}
],
"export_format": "xlsx",
"export_mode": "attribute_rows",
"filter_by_label": false,
"filter_latest_version": false,
"label_keys": [
"<string>"
],
"source_filter": [
"<string>"
]
}
'import requests
url = "https://api.merchantops.ai/api/products/export"
payload = {
"product_keys": ["<string>"],
"column_mappings": [
{
"column_name": "<string>",
"source_field": "<string>",
"sub_field": "<string>",
"use_label": False
}
],
"export_format": "xlsx",
"export_mode": "attribute_rows",
"filter_by_label": False,
"filter_latest_version": False,
"label_keys": ["<string>"],
"source_filter": ["<string>"]
}
headers = {"Content-Type": "application/json"}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'Content-Type': 'application/json'},
body: JSON.stringify({
product_keys: ['<string>'],
column_mappings: [
{
column_name: '<string>',
source_field: '<string>',
sub_field: '<string>',
use_label: false
}
],
export_format: 'xlsx',
export_mode: 'attribute_rows',
filter_by_label: false,
filter_latest_version: false,
label_keys: ['<string>'],
source_filter: ['<string>']
})
};
fetch('https://api.merchantops.ai/api/products/export', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.merchantops.ai/api/products/export",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'product_keys' => [
'<string>'
],
'column_mappings' => [
[
'column_name' => '<string>',
'source_field' => '<string>',
'sub_field' => '<string>',
'use_label' => false
]
],
'export_format' => 'xlsx',
'export_mode' => 'attribute_rows',
'filter_by_label' => false,
'filter_latest_version' => false,
'label_keys' => [
'<string>'
],
'source_filter' => [
'<string>'
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.merchantops.ai/api/products/export"
payload := strings.NewReader("{\n \"product_keys\": [\n \"<string>\"\n ],\n \"column_mappings\": [\n {\n \"column_name\": \"<string>\",\n \"source_field\": \"<string>\",\n \"sub_field\": \"<string>\",\n \"use_label\": false\n }\n ],\n \"export_format\": \"xlsx\",\n \"export_mode\": \"attribute_rows\",\n \"filter_by_label\": false,\n \"filter_latest_version\": false,\n \"label_keys\": [\n \"<string>\"\n ],\n \"source_filter\": [\n \"<string>\"\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.merchantops.ai/api/products/export")
.header("Content-Type", "application/json")
.body("{\n \"product_keys\": [\n \"<string>\"\n ],\n \"column_mappings\": [\n {\n \"column_name\": \"<string>\",\n \"source_field\": \"<string>\",\n \"sub_field\": \"<string>\",\n \"use_label\": false\n }\n ],\n \"export_format\": \"xlsx\",\n \"export_mode\": \"attribute_rows\",\n \"filter_by_label\": false,\n \"filter_latest_version\": false,\n \"label_keys\": [\n \"<string>\"\n ],\n \"source_filter\": [\n \"<string>\"\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.merchantops.ai/api/products/export")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"product_keys\": [\n \"<string>\"\n ],\n \"column_mappings\": [\n {\n \"column_name\": \"<string>\",\n \"source_field\": \"<string>\",\n \"sub_field\": \"<string>\",\n \"use_label\": false\n }\n ],\n \"export_format\": \"xlsx\",\n \"export_mode\": \"attribute_rows\",\n \"filter_by_label\": false,\n \"filter_latest_version\": false,\n \"label_keys\": [\n \"<string>\"\n ],\n \"source_filter\": [\n \"<string>\"\n ]\n}"
response = http.request(request)
puts response.read_body{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>",
"ctx": {},
"input": "<unknown>"
}
]
}Cookies
Body
Request model for exporting products to Excel.
List of product keys to export
Column mapping configuration (required for column_based mode)
Show child attributes
Show child attributes
File format: 'xlsx' for Excel, 'csv' for CSV
xlsx, csv Export format: 'column_based' uses custom column mappings, 'attribute_rows' creates one row per property
column_based, attribute_rows If true, filter products by specific labels
If true, only export the latest version of each product
Label keys to filter by (used when filter_by_label=true)
Filter products by source (e.g., ['merchant_input', 'scraper'])
Response
Successful Response