cancel
Showing results for 
Search instead for 
Did you mean: 

NetSuite Update SNAP updating unchanged fields

Vikas2022
New Contributor II

Hello,

I am reading data from Salesforce for a couple of fields and using NetSuite Update Snap, to update the record for those fields in the NetSuite Customer object. 

However, While updating records in NetSuite (System Notes) what I have observed is every time any Salesforce-specific field value is changed let's say for Invoice_Preference__c from "Other" to "Email", Then along with "Invoice Preference", the "Address field" in NetSuite (System Notes) is also logged as Create type. 

So why is this happening only for the Address field and how can it be avoided?

Salesforce Input data 

[
  {
    "record": {
      "companyName": "GTML2C-483_test1",
      "customFields": {
        "Invoice Preference": {
          "internalId": 1
        },
        "SFDC ID": "0015Ed9AE",
        "UCID": "101575",
        "PO required": false,
        "Multiple Invoice Emails": false,
        "Additional Invoice Emails": null
      },
      "parent": {
        "externalId": null
      },
      "currency": {
        "internalId": 1
      },
      "phone": null,
      "addressbookList": {
        "addressbook": [
          {
            "addressbookAddress": {
              "addr1": "Ring 1",
              "city": "Vienna",
              "zip": "1010",
              "state": null,
              "country": "_austria"
            },
            "defaultBilling": "true",
            "defaultShipping": "false"
          },
          {
            "addressbookAddress": {
              "city": "Vienna",
              "zip": "1010",
              "state": null,
              "addr1": "Ring 1",
              "country": "_austria"
            },
            "defaultBilling": "false",
            "defaultShipping": "true"
          }
        ],
        "replaceAll": "false"
      },
      "email": "v.xyz@xyz.com",
      "externalId": "0015Ed9AE",
      "fax": null,
      "accountNumber": "2974",
      "comments": null,
      "vatRegNumber": null,
      "taxItem": {
        "name": null
      },
      "terms": {
        "internalId": null
      },
      "subsidiary": {
        "internalId": 1
      },
      "internalId": "28248"
    }
  }
]

 

NetSuite Update Snap Output

[
  {
    "soapenv:Body": {
      "@xmlns:soapenv": "http://schemas.xmlsoap.org/soap/envelope/",
      "@xmlns:xsd": "http://www.w3.org/2001/XMLSchema",
      "@xmlns:xsi": "http://www.w3.org/2001/XMLSchema-instance",
      "updateResponse": {
        "@xmlns": "urn:messages_2020_1.platform.webservices.netsuite.com",
        "writeResponse": {
          "platformCore:status": {
            "@xmlns:platformCore": "urn:core_2020_1.platform.webservices.netsuite.com",
            "@isSuccess": "true",
            "platformCore:statusDetail": {
              "platformCore:afterSubmitFailed": "false"
            }
          },
          "baseRef": {
            "@xmlns:platformCore": "urn:core_2020_1.platform.webservices.netsuite.com",
            "@externalId": "0015Ed9AE",
            "@internalId": "28248",
            "@type": "customer",
            "@xsi:type": "platformCore:RecordRef"
          }
        }
      }
    },
    "original": {
      "record": {
        "companyName": "GTML2C-483_test1",
        "customFields": {
          "Invoice Preference": {
            "internalId": 1
          },
          "SFDC ID": "0015Ed9AE",
          "UCID": "101575",
          "PO required": false,
          "Multiple Invoice Emails": false,
          "Additional Invoice Emails": null
        },
        "parent": {
          "externalId": null
        },
        "currency": {
          "internalId": 1
        },
        "addressbookList": {
          "addressbook": [
            {
              "addressbookAddress": {
                "addr1": "Ring 1",
                "city": "Vienna",
                "zip": "1010",
                "state": null,
                "country": "_austria"
              },
              "defaultBilling": "true",
              "defaultShipping": "false"
            },
            {
              "addressbookAddress": {
                "city": "Vienna",
                "zip": "1010",
                "state": null,
                "addr1": "Ring 1",
                "country": "_austria"
              },
              "defaultBilling": "false",
              "defaultShipping": "true"
            }
          ],
          "replaceAll": "false"
        },
        "email": "v.xyz@xyz.com",
        "externalId": "0015Ed9AE",
        "accountNumber": "2974",
        "taxItem": {
          "name": null
        },
        "terms": {
          "internalId": null
        },
        "subsidiary": {
          "internalId": 1
        },
        "internalId": "28248",
        "customFieldList": {
          "customField": [
            {
              "scriptId": "custentity_invoice_preference",
              "internalId": "2769",
              "type": "SelectCustomFieldRef",
              "value": {
                "internalId": 1
              }
            },
            {
              "scriptId": "custentity_sfdc_id",
              "internalId": "2759",
              "type": "StringCustomFieldRef",
              "value": "0015Ed9AE"
            },
            {
              "scriptId": "custentity_ucid",
              "internalId": "4499",
              "type": "StringCustomFieldRef",
              "value": "101575"
            },
            {
              "scriptId": "custentity_tri_po_required",
              "internalId": "3336",
              "type": "BooleanCustomFieldRef",
              "value": false
            },
            {
              "scriptId": "custentity_mult_invoice_emails",
              "internalId": "2754",
              "type": "BooleanCustomFieldRef",
              "value": false
            }
          ]
        },
        "nullFieldList": {
          "name": [
            "phone",
            "fax",
            "comments",
            "vatRegNumber",
            "custentity_addl_invoice_emails"
          ]
        }
      }
    }
  }
]

NetSuite Update SNAP

Vikas2022_1-1698302661849.png

Salesforce_NetSuite Field Mapping

Vikas2022_2-1698302848566.png

 



NetSuite System Notes for reference:
Vikas2022_0-1698302116279.png

Thanks!

@SpiroTaleski @og_integration 

5 REPLIES 5

Supratim
Contributor III

@Vikas2022 , As you already mapped external id, Did you observe the same behavior with NS Upsert Snap ? 

Vikas2022
New Contributor II

Yes @Supratim I am still seeing the same behaviour even with the NS Upsert Snap.

Hi @Vikas2022 In such case you can validate your request from NS  (Setup -> Integration _> SOAP Webservices log ). If your request doesn't contain that change then there would be chance of some NS internal script rans behind the scene while you update that particular NS object. Ask NS team to validate. I have faced same kind of issue before. 

Vikas2022
New Contributor II

Hello @Supratim Thanks for the information. So in Salesforce, I had just updated the phone field yet in the NetSuite's request.xml along with phone I could see the Address section code included, so Snaplogic is resending non-changed fields data as well in NetSuite via Update/Upsert SNAP which is resulting in duplicates. 




<ns1:addressbookList replaceAll="false">
                    <ns1:addressbook>
                        <ns1:defaultShipping>false</ns1:defaultShipping>
                        <ns1:defaultBilling>true</ns1:defaultBilling>
                        <ns1:addressbookAddress>
                            <ns4:country>_austria</ns4:country>
                            <ns4:addr1>Carinthian Street</ns4:addr1>
                            <ns4:city>Vienna</ns4:city>
                            <ns4:state/>
                            <ns4:zip>1010</ns4:zip>
                        </ns1:addressbookAddress>
                    </ns1:addressbook>
                    <ns1:addressbook>





Vikas2022_0-1699003045217.jpeg

Vikas2022_1-1699003080923.jpeg

How can I avoid this?