LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: abhisek

Hi,

Is there any upsert node available in Lavastorm for interaction with SFDC?

I wanted to establishing a process where in data will be identified for new or existing records and accordingly updated into Saleforce as
Insert or Update. This is common type of functionality found in other tools.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: lnason

Yes - There is a "Lavastorm Transact for SalesForce" node in the Lavastorm Analytics Library, also know as "LAL".

In case you are not already familiar with how library graphs can be used, to use the LAL....you would need to select Graph->Edit Base Libraries and then add an entry labelled "lal1".

Luke

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: abhisek

I am working on LAE 4.6 , is it available in this version.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: lnason

Unfortunately not, the SalesForce nodes are only compatible with version 4.6.1 or later.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: abhisek

Hi Inason, can you provide an example with Lavastorm Transact for Salesforce node. We are using LAE version 4.6.1.2.
Its urgent.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: lnason

I've attached a simple example that executes a query and runs an update against the Account object. I used my SalesForce developer instance to test this. You'll need to populate your Salesforce credentials in the graph level parameters.

Luke

LAL_SFDC_Node_Examples_ForumPost.brg
LAL_SFDC_Node_Examples_ForumPost.brp

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: abhisek

Many Thanks Inason/Luke,

Exploring the 5.1 LAE, is there any node for Saleforce Bulk Query, Saleforce Job Creation, etc
How can we achieve those?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: lnason

We don't have any support for the Bulk API at this time. If you are inclined to do so, you might be able to build something with a combination of HTTP/Java nodes.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

Hi, returning to your original question re. Salesforce Upsert support: The 'Lavastorm Update for Salesforce' node was released in the Lavastorm Analytic Library (LAL) Rel. 39 and provides the Upsert method. The node is in the Publishing category of the node library.

The latest version of LAL can be found on the Lavastorm Installers page here:

http://na3.salesforce.com/_ui/selfse...0150000000pH2G

Kind regards,
Adrian