Neuron ESB User Network

The Service Bus for the Connected Business

Hi,

We're getting started with Salesforce integration using Neuron ESB, and we've set up some basic SOQL queries, which work great. We want to do some more complex manipulations of the data in Salesforce based on the results of queries. Not knowing either system all that well, I have a question on the best way to proceed here. If I want to do a basic DML thing like update a field indexed by an ID that's returned by a query like:

List<Contact> cc = [Select Id, ParentID from Contact where modDate >= 5];

for Contact c: cc  {

        List<Contact> aa = [Select Id, readyDate from Contact where Id = c.ParentID];

        aa.readyDate = systimestamp();

        update aa;

}

From what I see, I could expose this from Salesforce as a custom API call. I imagine I could do this in code from Neuron. If wanted to, I suppose I could transform the returned XML from the initial SOQL call to a series of updates. Maybe there are easier ways. My question is what do you think would be the easiest way to do something like this?

Mark

Tags: DML, SOQL, Salesforce

Views: 155

Reply to This

Replies to This Discussion

We wouldn't suggest calling SF from code in Neuron.  You can either use the update operation on the sObject or expose your custom logic as a APEX service and use the adapter.

That's what I thought, thanks Joe!

RSS

Neuron ESB Product Support Forums and Communities

Latest Activity

Anupama Nair posted a discussion

Marketo Adapter Invalid Token

Hi,We are using the Marketo adapter to push account updates to Marketo. It works well for some time then starts failing with Invalid Token unless restarted. Is there a configuration that can be done so it can auto refresh the token when required?Thanks!See More
Nov 6, 2023
Sayantini Basak posted a discussion

Maximum payload size(REST API) for requests interfacing to NeuronESB

I am new to Neuron ESB and in our current scenario,We need to process batch transactions comprising of ~1000 records and send them to Neuron ESB for further processing. I would like to understand what is the maximum size of payload that can be transferred using REST interface to Neuron ESB.See More
Jul 22, 2022
Profile IconRobert E Dunie and Sayantini Basak joined Neuron ESB User Network
Apr 28, 2022
Profile IconDayanand, Frederic C, Steffen Greve-Oksfeldt and 1 more joined Neuron ESB User Network
Mar 16, 2022
Profile IconCam Vong and Mitja Luznar joined Neuron ESB User Network
Jan 27, 2022
Profile IconWill Hitzges, Chad Parsons, michael larsen and 4 more joined Neuron ESB User Network
Jun 11, 2021
Anupama Nair posted a discussion

ODBC stored proc polling with temporary tables

We have set up an ODBC adapter to poll a stored proc.We found that if the stored proc has a temporary table defined the rows returned are always 0.Any idea why this would be and what we can do to get around it?See More
Dec 14, 2020
Prasanth Kharade is now a member of Neuron ESB User Network
Dec 30, 2019

Badge

Loading…

© 2024   Created by Neuron Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service