Action | Syntax |
---|---|
To add a new custom mapped field | Netsuite field name(field ID*)=SalesForce_Field_(API) Name For example: url=Website |
To add a reference field | netsuitefieldname=SalesForce_Reference_Field__r\:SalesForce_Reference_Key For example: Subsidiary=NSCRM__Subsidiary__r\:NSCRM__NS_Internal_Id__c If Subsidiary is 1984 in NetSuite, the resulting json would be: NSCRM__Subsidiary__r : { NSCRM_NS_Internal_Id_c : "1984" } |
To replace a field | If a field is already mapped by default for a given object and you want to replace that mapping, then place the new mapping in the sync file. The sync file will override the base mapping. |
To delete a field | If there is a base mapping that you do not want to be mapped, then you can remove that mapping by placing a minus sign - in front of the Salesforce field on its own line. For example: -NSCRM__Fax__c The above would remove any base mapping to the salesforce field NSCRM__Fax__c |
To add a comment line | If a line in the sync file starts with #, it will be viewed as a comment line and consequentially ignored. This helps you to document why and what are you doing in the sync file. For example: #Comment Line fax=Fax phone=Phone subsidiary=NSCRM__NS_Subsidiary_Id__r\:NSCRM__NS_Internal_Id__c |
To add a currency field | This is a special case. Salesforce needs Currencies as ISO codes. When we pull a currency field from NetSuite, it is an Id. Hence, if you want to custom map currency and need an ISO code, then begin the line with $ and it will do an ISO code lookup. For example: $currency=CurrencyIsoCode If you want the raw currency id to go over, then the $ is not required. For example: currency=CurrencyNSIdOnSF |