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
Parameter
Description
Example
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)
1
Upload CSV file to project assets
2
Reference in spreadsheet
3
Use VLOOKUP to access data
Authentication
Secure your API connections.
Method
Description
Use Case
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