Forum Discussion

Rmuenks1's avatar
Rmuenks1
Occasional Contributor
11 months ago

Salesforce API update issue

Hi Smartbear Community!   I'm using the unsupported API github extension for common Salesforce API calls.  I ran into an issue trying to edit/update existing ACCOUNT data. I'm using JS and have cre...
  • Rmuenks1's avatar
    Rmuenks1
    11 months ago

    ***SOLVED***

    Look in the folder where you extracted the Salesforce github files when originally installing the extension for the file:  \testcomplete-salesforce-extension-main\src\script.sj

    Within the file is code in the this.Update logic which builds a list of fields which are considered "updateable".  You can add logic to that list builder to exclude fields from the .Push when the _metadata.fields[i].name contains "__pc", or for any other condition of field names which are throwing errors when trying to perform a .Update call to Salesforce.

    For Example:

    Changing:  if (_metadata.fields[i].updateable)

    To:  if ((_metadata.fields[i].updateable) && (_metadata.fields[i].name.search("__pc") < 0))
           

    This will allow you to exclude problematic fields.

  • Rmuenks1's avatar
    Rmuenks1
    Occasional Contributor
    11 months ago

    Hi rraghvani! 

    Thanks, I was following the SOQL query format which was provided in the Examples provided with the github Salesforce / TestComplete extension which had this listed:

         // JavaScript example
         function Get_Names()
         {
          let names = Salesforce.Query("SELECT+Name+FROM+Account");
          for (let i = 0; i < names.Count(); i++)
          {
             Log.Message(names.GetItem(i).Name);
          }
           }

    I did try your suggestion however, and still got the error. 

    Status Code: 400
    Status Text: Bad Request

    Body:
    [{"message":"Account: bad field names on insert/update call: Additional_E_mail__pc, Special_Needs__pc, Custom_Permissions__pc, Lic_Designation__pc, FinServ__ReferredByUser__pc, FinServ__CommunicationPreferences__pc, FinServ__ContactPreference__pc, Business_Phone__pc, Events_Experiences__pc, NAM_ID__pc, Formal_First_Name__pc, FinServ__CustomerTimezone__pc, Flag_for_Deletion__pc, 

     

    • rraghvani's avatar
      rraghvani
      Champion Level 3
      11 months ago

      I'm not using the + symbol in the SQL statement, and SOQL query examples also doesn't use it.

       

      • Rmuenks1's avatar
        Rmuenks1
        Occasional Contributor
        11 months ago

        Ok, I will remove them. 

        If someone knows how to resolve the error for "bad field names on insert/update call:" or how to remove the Person Contact fields from the object I would appreciate it.