Expert

Data Connections

Dynamic pricing, inventory & more

Overview

Connect your configurators to external data sources for dynamic pricing, inventory, and more.

REST APIs

Connect to any API endpoint

JSON Data

Load structured data files

CSV Import

Upload spreadsheet data

Databases

Connect via API proxy

Loading External Data

Use the data element to fetch external data.

Data Element

Type | URL                  | Format | Refresh
data | /api/products.json   | json   | 60000

type Element type data

url Data source URL /api/prices.json

format Data format json

refresh Update interval (ms) 60000

Using Loaded Data

Reference loaded data in formulas.

Formula References

Price     | =Data.products[0].price
InStock   | =Data.products[0].inventory > 0
Material  | =VLOOKUP(MaterialID, Data.materials, 2)

API Integration

Connect to REST APIs for real-time data.

REST API Element

Type | URL                           | Method | Headers
api  | https://api.example.com/price | GET    | {"Authorization": "Bearer xxx"}

Webhooks

Send data to external systems when events occur.

Webhook Element

Type    | URL                           | Trigger | Data
webhook | https://api.example.com/order | submit  | {config}

CSV Data

Import CSV data for lookup tables.

CSV Example

// CSV: materials.csv
ID,Name,PricePerKg
1,Steel,2.50
2,Aluminum,4.00
3,Copper,8.00
// Spreadsheet reference
MaterialID  | 2
Price       | =VLOOKUP(MaterialID, materials, 3)

Upload CSV file to project assets

Reference in spreadsheet

Use VLOOKUP to access data

Authentication

Secure your API connections.

API Key Simple key in header or query Public APIs

Bearer Token OAuth2 access token Secure APIs

Basic Auth Username and password Legacy systems

Error Handling

Price | =IF(ISERROR(Data.price), DefaultPrice, Data.price)

Best Practices

Tips for reliable data integration.

Cache Data

Reduce API calls when possible

Handle Errors

Provide fallbacks for failures

Secure Keys

Never expose API keys in client

Rate Limits

Respect API limits

← Back to Documentation