LAE

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

Originally posted by: khopkins

Hello everyone,

I am currently using the salesforce nodes to insert and update data in Salesforce however we now have a requirement to delete old data from an object.
This is so that we can maintain only a 13 month window of data within the object and i am having trouble using the suggested methods from the saleforce forums.
They suggest we use the soql nodes and the delete command to remove the data but i cannot get this to work.

Has anyone actually done this before or know how to do it as any help would be appreciated.

Regards,

Keith

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

Originally posted by: khopkins

Hi Everyone,

I really need an answer to this as i have to delete records from salesforce objects based on criteria passed into and using the SOQL salesforce node

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

Originally posted by: simon.wilby

Hi Keith,

a few questions first - which version of lae are you running? I'm assuming that you're using the lal version of the salesforce nodes (Lavastorm Transact for Salesforce and Lavastorm Query for Salesforce) - can you confirm?

I'm not 100% sure on what you're trying to achieve here - is it a delete object ie a contact
OR
Are you trying to remove data from an object?
Maybe you could post an example of the data you've created and what it is you're trying to remove?

Regards

Simon

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

Originally posted by: khopkins

Hi Simon,

Yes i am using version 4.6.1 with the salesforce nodes supplied by Neil Callaghan from Lavastorm.

What i am trying to do is remove a set of records out of a salesforce object depending on a set of criteria.
For example there are a large number of invoice records for customers that we only want to show the last 13 months of within salesforce so after every upsert of data into this object we then need to remove records of invoice data that is older the 13 months.

Regards,

Keith

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

Originally posted by: simon.wilby

Hi Keith,

sorry for the delay in responding, I spoke with Neil and it turns out the Salesforce nodes you're using are not the "productised" LAL nodes. I'm not familiar with the ones that you're using so it may take some time to investigate. However I don't see any reason why you couldn't install LAL and have the two side by side. just going to look into that - will reply with more as soon as I can.

Regards

Simon

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

Originally posted by: simon.wilby

Hi Keith,

ok so having looked into this I would suggest the best solution is to install LAL (available on our downloads page)

Select the Download LAL v2.20.3 link and follow the release notes for further information.

this will install a few different nodes but also the productised version of the SFDC nodes. There's a section in the release notes that will guide you in adding lal as a base library if you need it.

Also if you have a look at the forum thread for lal you'll see an example graph for the Salesforce nodes I attached to the post LAL 2.19.0 (Compatible with 4.6) has been released.

Hopefully this will be enough to assist you in your issue. Let me know how it goes and if you need any help

Regards

Simon

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

Originally posted by: khopkins

Hi Simon,

I will have a look as soon as i can this week but i will have to somehow test it without deploying it fully to the live server environment.

Regards,

Keith