Salesforce Upsert not giving me the correct options

Hi there,

I would like to use the built-in method to upsert a record (insert if not there, update if it is) to the Campaign Member table. I am only seeing the fields I can update, but not the fields needed to create a new record (contact ID and campaign ID). Am I doing something wrong? I’d like to avoid doing a router if needed.

Welcome to the Make community!

You shouldn’t need to map a contact/campaign ID. What other fields are there in this module— could you provide a screenshot of it?

Here’s what a create record looks like:

Here’s what an upsert looks like:

For the upsert, I would expect to see the required fields (eg. campaignID and the other related ones like ContactID) From my understanding an upsert means that if it doesn’t find a record, it will create one. If it does find one, it will update it.

Thanks for taking a look!

@samliew - I just wanted to see if you saw my response. The required field for CampaignID should be available in an upsert, otherwise I can’t insert a new record.

It looks like you’re right about it.

For technical issues or bugs with a custom app, do contact Make support as they will also be able to reach out to the developer for further advise.

Ok—-thanks! I am new to the platform, so I wasn’t sure if I was missing something obvious with such a popular app