You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to batch UPDATE "contact type" to a specific value based on where clause

Received Response
14
Views
3
Comments
edited Nov 21, 2017 3:15PM in Integrations and APIs 3 comments

Content

Hi there.

I'd like to know Where and how do you go about to perform an UPDATE STATEMENT like this:

(Pseudo code)
Update CONTACTS
SET CONTACT TYPE ="NCHS Employee" (ID=5)
WHERE CONTACT.EMAIL contains "@mch.com"

If it helps, we have Integration Cloud (ICS) and also JDeveloper installed as well

 

Any hint is truly appreciated

Thanks, Bruno

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!