prakarshjain510
New Contributor II
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Loading records of object having two lookup fields on the same object(Contact)
Thanks @bojanvelevski After adding validate and execute, I am getting the following error in the poller snap - This is the relationship mapper: Not sure, why this error is coming though, as in the Relationship Upsert Snap, I am using contact as the related object and the external id field created on the Contact object. Thanks!1.1KViews0likes0CommentsRe: Loading records of object having two lookup fields on the same object(Contact)
One more thing to add, the Salesforce Poller after Relationship Create is not giving any output. I added a Join snap after that just to check if I am getting any value in the left path of join, but I am not getting anything.2.8KViews0likes2CommentsRe: Loading records of object having two lookup fields on the same object(Contact)
There was no error shown in the pipelines. In the mapper snap, I can see the id is generated for the relationship object. Pipeline created: In the Salesforce Created output, this is what I am getting: Yes, the Salesforce accepts External Id field. While inserting Contact, I am doing upsert based on External Id, and it is working fine. I had created a similar pipeline, where a junction object was getting upserted. The difference was, the junction object was child to Account and Contact. And in this case, the relationship object is child to two Contact lookup fields. It would be really helpful if we can jump on a call to discuss this. Appreciate all the help. Thanks!2.8KViews0likes3CommentsLoading 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.7KViews0likes0CommentsRe: Salesforce Batch Create question. Creating Junction Records?
Hi Dave, I can see that you have mentioned you were able to a record and associated child records in a single transaction. I am also trying to do the same thing but not able to do it. If you can please share the snap you have created for the above functionality, it would be really helpful. Thanks!2.8KViews0likes0CommentsRe: Inserting Multiple object records Salesforce
Hi Kishore, Thank you for the revert. I tried the way you have mentioned, but it is not working. As of now I am using the following pipeline - In the mapper snap I have mapped the contact and the account fields both and in the upsert snap, I have selected Contact as the object type and in the related object and field it was Account and External Id field respectively as suggested by the comment. I also tried inserting the account first and then again reading the data from csv to insert the contact. But the account insert snap and the file reader snap are not getting joined maybe because the output from insert snap is not a valid one for the file reader snap. Is it possible if you can share the pipeline with me for reference?2.7KViews0likes0Comments