Customer Deposit / Payment Field Mapping
{
"mapping": {
"fields": [
{
"generate": "undepfunds",
"hardCodedValue": "T",
"fieldtype": "",
"discardIfEmpty": false
},
{
"generate": "paymentmethod",
"hardCodedValue": 10,
"fieldtype": "",
"discardIfEmpty": false
},
{
"generate": "location",
"lookupName": "locationlookup"
}
]
},
"lookups": {
"locationlookup": {
"resultFieldId": "location",
"recordType": "parent"
}
}
}Transaction Currency-Specific Account Mapping
The JSON example below uses Stripe's API response currency value to select a NetSuite bank account based on USD or CAD.
Note: If multiple mapping field groups are utilized, always add the account lookup to the bottom of the JSON.
{
"lookups": {
"accountlookup": {
"map": {
"usd": "1001 Stripe USD Bank Account",
"cad": "2001 Stripe CAD Bank Account"
}
}
},
"mapping": {
"fields": [
{
"generate": "account",
"extract": "currency",
"discardIfEmpty": true,
"fieldType": "text",
"lookupName": "accountlookup"
}
]
}
}