Sample JSON data for Field Mapping

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"
            }
        ]
    }
}
Was this article helpful?
0 out of 0 found this helpful

More resources