Request
curl -X POST https://api.iterationlayer.com/sheet-generation/v1/generate \
-H "Authorization: Bearer YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"format": "csv",
"sheets": [
{
"name": "Orders",
"columns": [
{
"name": "Order ID",
},
{
"name": "Date",
},
{
"name": "Customer",
},
{
"name": "Email",
},
{
"name": "Items",
},
{
"name": "Subtotal",
},
{
"name": "Shipping",
},
{
"name": "Total",
},
{
"name": "Status",
}
],
"rows": [
[
{
"value": "ORD-38291",
},
{
"value": "2026-03-18",
"format": "date",
},
{
"value": "Elena Rodriguez",
},
{
"value": "elena.r@gmail.com",
},
{
"value": 3,
"format": "number",
},
{
"value": 189.97,
"format": "currency",
},
{
"value": 12.99,
"format": "currency",
},
{
"value": 202.96,
"format": "currency",
},
{
"value": "Shipped",
}
],
[
{
"value": "ORD-38292",
},
{
"value": "2026-03-18",
"format": "date",
},
{
"value": "James Whitfield",
},
{
"value": "j.whitfield@outlook.com",
},
{
"value": 1,
"format": "number",
},
{
"value": 549.00,
"format": "currency",
},
{
"value": 0,
"format": "currency",
},
{
"value": 549.00,
"format": "currency",
},
{
"value": "Processing",
}
],
[
{
"value": "ORD-38293",
},
{
"value": "2026-03-19",
"format": "date",
},
{
"value": "Priya Sharma",
},
{
"value": "priya.sharma@company.io",
},
{
"value": 5,
"format": "number",
},
{
"value": 74.95,
"format": "currency",
},
{
"value": 8.99,
"format": "currency",
},
{
"value": 83.94,
"format": "currency",
},
{
"value": "Delivered",
}
],
[
{
"value": "ORD-38294",
},
{
"value": "2026-03-19",
"format": "date",
},
{
"value": "Marcus Chen",
},
{
"value": "mchen@protonmail.com",
},
{
"value": 2,
"format": "number",
},
{
"value": 329.98,
"format": "currency",
},
{
"value": 15.99,
"format": "currency",
},
{
"value": 345.97,
"format": "currency",
},
{
"value": "Shipped",
}
],
[
{
"value": "ORD-38295",
},
{
"value": "2026-03-20",
"format": "date",
},
{
"value": "Aisha Okafor",
},
{
"value": "aisha.o@gmail.com",
},
{
"value": 1,
"format": "number",
},
{
"value": 89.00,
"format": "currency",
},
{
"value": 5.99,
"format": "currency",
},
{
"value": 94.99,
"format": "currency",
},
{
"value": "Pending",
}
]
]
}
]
}'Response
{
"success": true,
"data": {
"buffer": "T3JkZXIgSUQsRGF0ZSxDdXN0b21l...",
"mime_type": "text/csv"
}
}Request
import { IterationLayer } from "iterationlayer";
const client = new IterationLayer({
apiKey: "YOUR_API_KEY",
});
const result = await client.generateSheet({
format: "csv",
sheets: [
{
name: "Orders",
columns: [
{
name: "Order ID",
},
{
name: "Date",
},
{
name: "Customer",
},
{
name: "Email",
},
{
name: "Items",
},
{
name: "Subtotal",
},
{
name: "Shipping",
},
{
name: "Total",
},
{
name: "Status",
},
],
rows: [
[
{
value: "ORD-38291",
},
{
value: "2026-03-18",
format: "date",
},
{
value: "Elena Rodriguez",
},
{
value: "elena.r@gmail.com",
},
{
value: 3,
format: "number",
},
{
value: 189.97,
format: "currency",
},
{
value: 12.99,
format: "currency",
},
{
value: 202.96,
format: "currency",
},
{
value: "Shipped",
},
],
[
{
value: "ORD-38292",
},
{
value: "2026-03-18",
format: "date",
},
{
value: "James Whitfield",
},
{
value: "j.whitfield@outlook.com",
},
{
value: 1,
format: "number",
},
{
value: 549.00,
format: "currency",
},
{
value: 0,
format: "currency",
},
{
value: 549.00,
format: "currency",
},
{
value: "Processing",
},
],
[
{
value: "ORD-38293",
},
{
value: "2026-03-19",
format: "date",
},
{
value: "Priya Sharma",
},
{
value: "priya.sharma@company.io",
},
{
value: 5,
format: "number",
},
{
value: 74.95,
format: "currency",
},
{
value: 8.99,
format: "currency",
},
{
value: 83.94,
format: "currency",
},
{
value: "Delivered",
},
],
[
{
value: "ORD-38294",
},
{
value: "2026-03-19",
format: "date",
},
{
value: "Marcus Chen",
},
{
value: "mchen@protonmail.com",
},
{
value: 2,
format: "number",
},
{
value: 329.98,
format: "currency",
},
{
value: 15.99,
format: "currency",
},
{
value: 345.97,
format: "currency",
},
{
value: "Shipped",
},
],
[
{
value: "ORD-38295",
},
{
value: "2026-03-20",
format: "date",
},
{
value: "Aisha Okafor",
},
{
value: "aisha.o@gmail.com",
},
{
value: 1,
format: "number",
},
{
value: 89.00,
format: "currency",
},
{
value: 5.99,
format: "currency",
},
{
value: 94.99,
format: "currency",
},
{
value: "Pending",
},
],
],
},
],
});Response
{
"success": true,
"data": {
"buffer": "T3JkZXIgSUQsRGF0ZSxDdXN0b21l...",
"mime_type": "text/csv"
}
}Request
from iterationlayer import IterationLayer
client = IterationLayer(api_key="YOUR_API_KEY")
result = client.generate_sheet(
format="csv",
sheets=[
{
"name": "Orders",
"columns": [
{
"name": "Order ID",
},
{
"name": "Date",
},
{
"name": "Customer",
},
{
"name": "Email",
},
{
"name": "Items",
},
{
"name": "Subtotal",
},
{
"name": "Shipping",
},
{
"name": "Total",
},
{
"name": "Status",
},
],
"rows": [
[
{
"value": "ORD-38291",
},
{
"value": "2026-03-18",
"format": "date",
},
{
"value": "Elena Rodriguez",
},
{
"value": "elena.r@gmail.com",
},
{
"value": 3,
"format": "number",
},
{
"value": 189.97,
"format": "currency",
},
{
"value": 12.99,
"format": "currency",
},
{
"value": 202.96,
"format": "currency",
},
{
"value": "Shipped",
},
],
[
{
"value": "ORD-38292",
},
{
"value": "2026-03-18",
"format": "date",
},
{
"value": "James Whitfield",
},
{
"value": "j.whitfield@outlook.com",
},
{
"value": 1,
"format": "number",
},
{
"value": 549.00,
"format": "currency",
},
{
"value": 0,
"format": "currency",
},
{
"value": 549.00,
"format": "currency",
},
{
"value": "Processing",
},
],
[
{
"value": "ORD-38293",
},
{
"value": "2026-03-19",
"format": "date",
},
{
"value": "Priya Sharma",
},
{
"value": "priya.sharma@company.io",
},
{
"value": 5,
"format": "number",
},
{
"value": 74.95,
"format": "currency",
},
{
"value": 8.99,
"format": "currency",
},
{
"value": 83.94,
"format": "currency",
},
{
"value": "Delivered",
},
],
[
{
"value": "ORD-38294",
},
{
"value": "2026-03-19",
"format": "date",
},
{
"value": "Marcus Chen",
},
{
"value": "mchen@protonmail.com",
},
{
"value": 2,
"format": "number",
},
{
"value": 329.98,
"format": "currency",
},
{
"value": 15.99,
"format": "currency",
},
{
"value": 345.97,
"format": "currency",
},
{
"value": "Shipped",
},
],
[
{
"value": "ORD-38295",
},
{
"value": "2026-03-20",
"format": "date",
},
{
"value": "Aisha Okafor",
},
{
"value": "aisha.o@gmail.com",
},
{
"value": 1,
"format": "number",
},
{
"value": 89.00,
"format": "currency",
},
{
"value": 5.99,
"format": "currency",
},
{
"value": 94.99,
"format": "currency",
},
{
"value": "Pending",
},
],
],
}
],
)Response
{
"success": true,
"data": {
"buffer": "T3JkZXIgSUQsRGF0ZSxDdXN0b21l...",
"mime_type": "text/csv"
}
}Request
package main
import il "github.com/iterationlayer/sdk-go"
func main() {
client := il.NewClient("YOUR_API_KEY")
result, err := client.GenerateSheet(il.GenerateSheetRequest{
Format: "csv",
Sheets: []il.Sheet{
{
Name: "Orders",
Columns: []il.SheetColumn{
{
Name: "Order ID",
},
{
Name: "Date",
},
{
Name: "Customer",
},
{
Name: "Email",
},
{
Name: "Items",
},
{
Name: "Subtotal",
},
{
Name: "Shipping",
},
{
Name: "Total",
},
{
Name: "Status",
},
},
Rows: []il.SheetRow{
{
{
Value: "ORD-38291",
},
{
Value: "2026-03-18",
Format: "date",
},
{
Value: "Elena Rodriguez",
},
{
Value: "elena.r@gmail.com",
},
{
Value: 3,
Format: "number",
},
{
Value: 189.97,
Format: "currency",
},
{
Value: 12.99,
Format: "currency",
},
{
Value: 202.96,
Format: "currency",
},
{
Value: "Shipped",
},
},
{
{
Value: "ORD-38292",
},
{
Value: "2026-03-18",
Format: "date",
},
{
Value: "James Whitfield",
},
{
Value: "j.whitfield@outlook.com",
},
{
Value: 1,
Format: "number",
},
{
Value: 549.00,
Format: "currency",
},
{
Value: 0,
Format: "currency",
},
{
Value: 549.00,
Format: "currency",
},
{
Value: "Processing",
},
},
{
{
Value: "ORD-38293",
},
{
Value: "2026-03-19",
Format: "date",
},
{
Value: "Priya Sharma",
},
{
Value: "priya.sharma@company.io",
},
{
Value: 5,
Format: "number",
},
{
Value: 74.95,
Format: "currency",
},
{
Value: 8.99,
Format: "currency",
},
{
Value: 83.94,
Format: "currency",
},
{
Value: "Delivered",
},
},
{
{
Value: "ORD-38294",
},
{
Value: "2026-03-19",
Format: "date",
},
{
Value: "Marcus Chen",
},
{
Value: "mchen@protonmail.com",
},
{
Value: 2,
Format: "number",
},
{
Value: 329.98,
Format: "currency",
},
{
Value: 15.99,
Format: "currency",
},
{
Value: 345.97,
Format: "currency",
},
{
Value: "Shipped",
},
},
{
{
Value: "ORD-38295",
},
{
Value: "2026-03-20",
Format: "date",
},
{
Value: "Aisha Okafor",
},
{
Value: "aisha.o@gmail.com",
},
{
Value: 1,
Format: "number",
},
{
Value: 89.00,
Format: "currency",
},
{
Value: 5.99,
Format: "currency",
},
{
Value: 94.99,
Format: "currency",
},
{
Value: "Pending",
},
},
},
},
},
})
if err != nil {
panic(err)
}
_ = result
}Response
{
"success": true,
"data": {
"buffer": "T3JkZXIgSUQsRGF0ZSxDdXN0b21l...",
"mime_type": "text/csv"
}
}