curl -X POST "https://api-integration.ollang.com/integration/folder/export-xlsx" \
-H "X-Api-Key: <your-api-key>" \
-H "Content-Type: application/json" \
-d '{
"folderIds": ["60b8d6f1e1b9b1d8c6c0d8e1"],
"targetLanguages": ["tr", "en"]
}' \
--output bulk_export.xlsx
const response = await fetch(
"https://api-integration.ollang.com/integration/folder/export-xlsx",
{
method: "POST",
headers: {
"X-Api-Key": "<your-api-key>",
"Content-Type": "application/json",
},
body: JSON.stringify({
folderIds: ["60b8d6f1e1b9b1d8c6c0d8e1"],
targetLanguages: ["tr", "en"],
}),
},
);
const blob = await response.blob();
const url = URL.createObjectURL(blob);
// Download or process the XLSX file
import requests
response = requests.post(
"https://api-integration.ollang.com/integration/folder/export-xlsx",
headers={
"X-Api-Key": "<your-api-key>",
"Content-Type": "application/json",
},
json={
"folderIds": ["60b8d6f1e1b9b1d8c6c0d8e1"],
"targetLanguages": ["tr", "en"],
},
)
with open("bulk_export.xlsx", "wb") as f:
f.write(response.content)
Binary XLSX file (multi-sheet spreadsheet with segment data)
{
"statusCode": 400,
"message": [
"each value in folderIds must be a string",
"folderIds should not be empty"
],
"error": "Bad Request"
}
{
"error": "Unauthorized",
"message": "Invalid or missing API key",
"code": "UNAUTHORIZED"
}
{
"statusCode": 500,
"message": "No segment data found for the given folders and target languages."
}
Ollang API Reference
Bulk Export Folders XLSX
Export video timestamps, transcriptions, and translations for multiple folders as a multi-sheet XLSX spreadsheet
POST
/
integration
/
folder
/
export-xlsx
curl -X POST "https://api-integration.ollang.com/integration/folder/export-xlsx" \
-H "X-Api-Key: <your-api-key>" \
-H "Content-Type: application/json" \
-d '{
"folderIds": ["60b8d6f1e1b9b1d8c6c0d8e1"],
"targetLanguages": ["tr", "en"]
}' \
--output bulk_export.xlsx
const response = await fetch(
"https://api-integration.ollang.com/integration/folder/export-xlsx",
{
method: "POST",
headers: {
"X-Api-Key": "<your-api-key>",
"Content-Type": "application/json",
},
body: JSON.stringify({
folderIds: ["60b8d6f1e1b9b1d8c6c0d8e1"],
targetLanguages: ["tr", "en"],
}),
},
);
const blob = await response.blob();
const url = URL.createObjectURL(blob);
// Download or process the XLSX file
import requests
response = requests.post(
"https://api-integration.ollang.com/integration/folder/export-xlsx",
headers={
"X-Api-Key": "<your-api-key>",
"Content-Type": "application/json",
},
json={
"folderIds": ["60b8d6f1e1b9b1d8c6c0d8e1"],
"targetLanguages": ["tr", "en"],
},
)
with open("bulk_export.xlsx", "wb") as f:
f.write(response.content)
Binary XLSX file (multi-sheet spreadsheet with segment data)
{
"statusCode": 400,
"message": [
"each value in folderIds must be a string",
"folderIds should not be empty"
],
"error": "Bad Request"
}
{
"error": "Unauthorized",
"message": "Invalid or missing API key",
"code": "UNAUTHORIZED"
}
{
"statusCode": 500,
"message": "No segment data found for the given folders and target languages."
}
Returns an XLSX spreadsheet with one sheet per order/language combination for all orders in the specified folders. Each sheet contains segment data (timecodes, source transcription, translated text).
The spreadsheet contains the following columns per sheet:
Sheet names follow the pattern
| Column | Description |
|---|---|
| SR NO | Sequential row number |
| TCR | Timecode (start timestamp) |
| SPEAKER | Speaker name |
| DIALOGUES | Source transcription text |
| Target Language | Translated text (column header is the target language code) |
{OrderName} - {targetLanguage} (max 31 characters).
curl -X POST "https://api-integration.ollang.com/integration/folder/export-xlsx" \
-H "X-Api-Key: <your-api-key>" \
-H "Content-Type: application/json" \
-d '{
"folderIds": ["60b8d6f1e1b9b1d8c6c0d8e1"],
"targetLanguages": ["tr", "en"]
}' \
--output bulk_export.xlsx
const response = await fetch(
"https://api-integration.ollang.com/integration/folder/export-xlsx",
{
method: "POST",
headers: {
"X-Api-Key": "<your-api-key>",
"Content-Type": "application/json",
},
body: JSON.stringify({
folderIds: ["60b8d6f1e1b9b1d8c6c0d8e1"],
targetLanguages: ["tr", "en"],
}),
},
);
const blob = await response.blob();
const url = URL.createObjectURL(blob);
// Download or process the XLSX file
import requests
response = requests.post(
"https://api-integration.ollang.com/integration/folder/export-xlsx",
headers={
"X-Api-Key": "<your-api-key>",
"Content-Type": "application/json",
},
json={
"folderIds": ["60b8d6f1e1b9b1d8c6c0d8e1"],
"targetLanguages": ["tr", "en"],
},
)
with open("bulk_export.xlsx", "wb") as f:
f.write(response.content)
Authorizations
This endpoint requires API key authentication. Include your API key in the request header:- Header name:
X-Api-Key - Header value: Your API key from the Ollang dashboard
Body Parameters
string[]
required
Array of folder IDs containing the orders to export.
string[]
required
Array of target language codes to include in the export.
Response
The response is a binary XLSX file download. The response headers include:Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheetContent-Disposition: attachment; filename="bulk_export_{date}.xlsx"
Binary XLSX file (multi-sheet spreadsheet with segment data)
{
"statusCode": 400,
"message": [
"each value in folderIds must be a string",
"folderIds should not be empty"
],
"error": "Bad Request"
}
{
"error": "Unauthorized",
"message": "Invalid or missing API key",
"code": "UNAUTHORIZED"
}
{
"statusCode": 500,
"message": "No segment data found for the given folders and target languages."
}
Was this page helpful?