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.

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

        "bad field names on insert/update call:" is most likely relating to your SQL query statement not being in the correct format.