Exporting

Once your data has been imported, enriched, and processed through AI workflows, you'll want to export it for use in other systems. Cension provides extremely flexible export options that let you get your data exactly where you need it.

The export system is designed to be both powerful and user-friendly. You can create multiple export configurations for a single dataset, each with its own format, filtering, and field mapping. This means you can have one export for your e-commerce platform, another for your analytics dashboard, and a third for your marketing automation tool - all from the same dataset.

When you first open the export interface, you'll see a default 'Base export' that's locked and cannot be edited. This serves as your primary export configuration that automatically mirrors your complete dataset schema and stays in sync as you add or modify columns. The Base export provides zero-setup access to your full dataset without any customization.

While you cannot edit the Base export, you can create unlimited custom exports with specific field mappings, filters, and formats. The Base export ensures you always have a guaranteed, unmodified view of your data alongside your tailored exports.

Cension supports all major data formats to ensure compatibility with your existing systems and workflows.

• CSV: Comma-separated values with customizable delimiters (comma, semicolon, pipe) and encoding options
• JSON: Standard web-ready format as arrays of objects, perfect for APIs and modern applications
• XML: Structured XML feeds for legacy systems and enterprise integrations
• Excel (.xlsx): Native Excel workbooks preserving data types and formatting
• SQL: Generated INSERT statements for direct database imports

Each export format includes a comprehensive field mapping table where you can control exactly how your data appears in the final output.

This mapping capability is crucial for seamless integration with platforms like Google Merchant Center, Shopify, or custom APIs that expect specific field names.

Not every row in your dataset needs to be exported. Cension gives you powerful filtering options to export only the data you need.

This ensures that only verified, high-quality data reaches your production systems and customer-facing applications.

Beyond one-time downloads, Cension lets you create live data feeds that automatically update when your dataset changes. These feeds are perfect for e-commerce platforms, marketing automation tools, and any system that needs fresh data.

This flexibility means you can serve different versions of your data to different systems without complex ETL processes or manual data preparation.

For advanced integrations and automated workflows, access your export feeds programmatically through Cension's REST API.

Getting started with API integration can be daunting, especially if you're not familiar with making HTTP requests. Cension provides ready-made prompts that you can copy and paste directly into popular development platforms.

These prompts include everything you need: the correct endpoint URLs, authentication headers, and example code showing how to make the API call and work with the returned data.

Simply copy the prompt, paste it into your chosen platform, and you'll have a working integration in minutes rather than hours.

1I need you to help me connect to a dataset API. Here are the connection details:
2
3API Endpoint: https://censionstorage.blob.core.windows.net/userphotos/api/export/{export_id}
4Authorization: Include header 'Authorization: export_{export_token}'
5
6This API returns JSON data from our dataset. Please:
7
81. Make a GET request to the endpoint above with the authorization header
92. Parse the JSON response which contains our structured dataset
103. Use this data in our application as needed
11
12Example request:
13```
14GET https://censionstorage.blob.core.windows.net/userphotos/api/export/{export_id}
15Headers:
16  Authorization: export_{export_token}
17  Content-Type: application/json
18```
19
20The response will be a JSON array containing the dataset records. Each record follows the field structure defined in our export mapping.
21
22Please implement the API call and show me how to work with the returned data in Cursor.

Sometimes you need your data as a static file rather than a live feed. Cension provides direct download options for all supported formats.

Downloads are processed in the background for large datasets, and you'll receive a notification when your file is ready.