SalesForce - REST API with OAUTH2 Token Auto Refresh Issue
Hi, Is anyone using REST Get snap with Salesforce instance using OAUTH2 account? I am having trouble with keeping my Account tokens up to date. I am able to connect and receive an Access Token and a Refresh Token on my account using the Account “Refresh” button. But SF does not provide me back a “Access token expiration” time. Apparently per SnapLogic support, I cannot enable “auto refresh token” on the account so the token can refresh without an expiration date on the token. I have to manually every hour open my account settings in Snaplogic account and hit “Refresh” to receive a new refresh and access tokens. If not, my snap step returns error “Session expired or invalid”,“errorCode”:“INVALID_SESSION_ID” in all of my pipelines. It’s very frustrating and redundant having to do this multiple times a day. Is there a way to pass thru a expiration token time to the account? Or is there a way I can force a token refresh each time my pipeline runs without my input? My use case is, SF snaps do not give us ability to access rich functionality such as getdeleted() or getupdated() on SF objects. These logs contain hard deleted items per object (when the object is replicated in SF) and we use these logs to keep the data in synch in our DB without having to re-download hundreds of millions of records per object every hour which is not possible. This log data is not accessible through SOQL as far as I can see and they are not in the recycle bin (hence hard deleted) so standard snaps don’t work for this. Example of REST Get service url for hard deleted item logs: https://instance#.salesforce.com/services/data/v39.0/sobjects/AccountTeamMember/deleted/?start=2017-09-13T00:00:00-00:00&end=2017-09-15T00:00:00-00:00 SF documentation: Developer SF REST API - GetDeleted() Another way of getting these results from what I have read is to use REST API QueryAll() functionality in SF. But it uses same Account configuration. Any help of feedback is much appreciated.
Salesforce Outbound Message Notification
A key feature in Salesforce is the ability to send outbound notifications upon changes to assets - such as Accounts, Contacts, Leads, etc. This can be useful for real-time integrations with external systems. To implement this feature, as a prerequisite, you should already have a Salesforce Developer account. This can be obtained for free. Also note that only new and modified records can be sent outbound. Deletions cannot be captured. Attached is a sample pipeline that receives an outbound message from Salesforce and sends a response back. Outbound Message Integration_2017_02_28.slp (6.5 KB)Anyone got SOAP execute for Salesforce working?
I am getting error: Failure: An exception occurred while executing the SOAP request, Reason: Could not send the SOAP request, Resolution: Verify that the template is correct, the substituted values are valid and the provided envelope matches the namespaces that are required by the targeted service how an basic account should be configured? Do we need to give api token also in password on setting up account? Do we need to have separate login call for salesforce login to get session ID? Any help is much appreciated.Order of Execution Not Right
Hello, A pipleine I’m working on seems to attempt to execute the Upsert Content (2) snap before the Create Deal/Job snap is executed. Since the Content record is a child of the Deal/Job, the absence of the Deal/Job Id is causing the Upsert Content (2) to fail. I’ve tried to route the documents down the one branch but the pipeline fails because Salesforce (the endpoint), doesn’t recognise the additional variables in the Map Deal/Job snap if the Pass Through option is selected. I’m not sure how to best approach this. Please note my understanding of SnapLogic is beginner level and I’m not a developer by trade.
