Salesforce SOQL - Pass Object Type as Parameter
Hello, Is it possible to pass the “Object Type” into a Salesforce SOQL Snap (or Salesforce lookup or Salesforce Read) I want to dynamically pull data from multiple salesforce objects and pull them into my SQL DB using a lookup table. However, when trying to use a parameter in the “Object Type” field, i get an error, despite the parameter not being null. See attached. ThanksSolved7.6KViews0likes8CommentsPipeline not going to error view when SFDC update snap fails
I did not map Id field on the mapper while updating sfdc record. which should technically fail the update Snap. I added an error view to the salesforce update snap but it is not going to the error view. I tried logging the output after SFDC updated. I dont see an error message on in the file as well. Why is it not going to error view?2KViews0likes2CommentsImpact of Snaplogic to Salesforce Connectivity for Cipher Changes | Salesforce Government Cloud
Hi @dmiller , We have recently received notification from Salesforce -“Chipper got retired for Salesforce Government Cloud” (Please refer the image). Just to verify is there any impact on existing connectivity for this changes?4.1KViews1like5CommentsSalesforce SOAP Merge
Hi, I am using SOAP snap to connect to Salesforce. I am able to get a session id back. Using the session id, I want to perform a Salesforce SOAP API Merge() call. I am able to generate a merge envelope and using a mapper I feed in a master record and a record to merge: But for some reason I keep getting the following error on the merge SOAP step: “error”: “MISSING_ARGUMENT: merge called with a batch of 0 ids to merge; must specify at least 1 id” I bet I am missing something simple. Can anyone chime in what that might be?3.3KViews1like3CommentsSalesForce - 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.17KViews0likes14CommentsLoading records of object having two lookup fields on the same object(Contact)
There is one object relationship. The object has two lookup relationship both on the Contact. We are trying to load relationship record data and relate that record with both the contacts. We have external ids field created on Contacts which are being used to load the data. But they are not getting loaded. When we pass salesforce id directly then the record gets created. Relationship(Child)->Contact1(Parent), Contact2(Parent) In the upsert snap, we are using contact1 field as the related object. And while mapping we are passing salesforce id of Contact2 field, but the record is not getting created. If anyone has implemented similar kind of functionality please let me know the steps. Thanks!4.3KViews0likes7CommentsCreating Junction object record in Salesforce
I have a csv file which has Account, Contact and Account Contact Relationship data. Account is parent to Contact and Relationship, Contact is parent to Relationship. In my pipeline I need to first insert Account, then Contact and related the Contact with Account → This part is done. Once Account and contact are inserted, I need to create a junction object record which will be stored in the object Account contact relationship. As the data can already exist in the system for relationship, I need to perform an upsert operation. If anyone has created a pipeline related to this, your help would be much appreciated. Thanks in advance!1.7KViews0likes0CommentsDate in Salesforce acceptable format
Hi Team, I have 2 fields, Start and End Date coming from upstream systems (i.e. snowflake) in UTC and want this to be inserted to downstream systems (i.e. Salesforce) in UTC as well. After developing the pipeline, we found that the dates are off by 4 hours when it goes into Salesforce. Thus, I tried changing the date to EST format in order to resolve the issue however at Salesforce, the dates are further going off by 4 hours. Should I just add 4 hours in my mapper which formats date so that it goes as is in Salesforce? If that’s the case, how should I add those 4 hours? It seems like the Salesforce Org is GTM-4 therefore it always converts the time - 4hours. Some screenshots for convenience. Snowflake execute with the below settings: EST Add-on: With the EST add on, the dates on Salesforce is going as 2025-12-29T15:00:00Z which is 29 Dec 2025 3pm. Removed EST Add-on: While removing the EST add-on, dates on Salesforce is still going as (Date - 4 hours) i.e. 29 Dec 2025 8pm. How can I tackle this? Thanking in advance for your time. Regards, DarshSolved6.5KViews0likes7Comments