Overview
When using Update Record on ERP, you can add a type prefix to make sure data is sent correctly to your ERP (Business Central or NetSuite).
Format:
type:value
Type prefixes are not case-sensitive.
Supported Types
🟢 Boolean (true/false)
Use for yes/no fields.
Format: boolean:true or boolean:false
Example: boolean:true → sends True
Must be exactly true or false.
🔢 Integer (whole numbers)
Format: integer:number
Examples:
integer:10→ sends 10integer:-5→ sends -5
Decimals not allowed — use decimal: instead.
💰 Decimal (numbers with decimals)
Format: decimal:number
Examples:
decimal:45.20decimal:0.01
Use for currency, percentages, or any field needing decimal precision.
🚫 Null (clear a field)
Format: null:null
Example: null:null → clears the field
📝 String (default)
If no prefix is set, it’s sent as a string.
Examples:
Hello Worldhttps://example.com
Strings with colons (like URLs) are preserved as-is.
Notes & Tips
Type prefixes are case-insensitive (
Boolean:True=boolean:true).Unknown prefixes are treated as strings.
Quick Reference
Type | Format | Example | Result |
Boolean | boolean:true |
| True |
Integer | integer:number |
| 100 |
Decimal | decimal:number |
| 99.99 |
Null | null:null |
| None |
String | (no prefix) |
| "Hello" |