Changing my Method of Records Import but the option is not active(it is grayed out)

Integration Apps
1

The Import step in my NetSuite Contact to Salesforce Contact Add/Update, is currently set to the “recommended” setting SOAP, Operation is set to Insert/Update. The setting “How can we find existing records? is set to ((celigo_sfnsio__NetSuite_Id__c = {{{string internalid}}}) AND (Email = {{{email email}}}))

My integration is not understanding when it encounters a duplicate, that it should Update the existing record instead of Insert it and returns the error: duplicate value found: celigo_sfnsio__NetSuite_Id__c duplicates value on record with id: 003Hs00004kHzZZIA0.

There is only one value for this contact in Salesforce and in NetSuite. I think Celigo in trying to Insert the contact from NetSuite but all the connecting fields(NetSuite Id (IO), NetSuite Record (IO), in Salesforce & Salesforce ID (IO) in NetSuite are properly populated in both NetSuite and Salesforce.

I tried mapping all 3 of these fields but cannot determine the Celigo field id for the NetSuite Contact URL(NetSuite Record (IO).
What is the celigo field id that represents the NetSuite Contact URL

I asked AI how to update my Import so that Celigo knows to Update instead of Insert and the response was:

Copilot

To find the Composite HTTP method and the option to select "Create new records & update existing records" in your Salesforce integration on Celigo:

Steps to Access the Composite HTTP Method and Option

  1. Navigate to the Import Settings:

    • In the provided UI context, you are editing an import in the FlowBuilder for Salesforce. Within the Imports tab of the FlowBuilder, identify the import you wish to configure.

  2. Select the Method for Records Import:

    • Look for the "How would you like the records imported?" section in the import configuration.

  3. Select Composite HTTP Method:

    • For the HTTP method (required) field, choose Composite.

    • Once Composite is selected, you will see options for Composite types.

  4. Choose “Create new records & update existing records”:

    • Under Composite type (required), select Create new records & update existing records to dynamically handle both creating and updating data

When I get to step 3 all the selections are grayed out. How would I either reset the method to Composite or add more/different criteria so that Celigo understands to “Update” instead of Insert?

Thanks.

2

Hey Colleen

I see what’s happening. If you’re working with an SFNSIO Integrated App, then yep, the import settings in IA aren’t editable, advice from CoPilot might’ve been based on a custom flow scenario instead.

About that duplicate error: it sounds like the record was found, but maybe the other criteria didn’t line up, so it defaulted to an insert. Can you double-check if the record that triggered the error has the same email address?

That’ll help confirm if the matching logic is behaving as expected.

What you can do is run a quick SOQL query in the Salesforce Debug console to see what’s being matched.

Let me know what you find and we can troubleshoot further from there!

1 Like