Mapping Lookup Relationships from WP to SF

  • Resolved ritikarawlani

    (@ritikarawlani)


    6 years, 3 months ago

    We are trying to push contacts and accounts data from WordPress to Salesforce. On the WordPress side, we have used PODS to create 2 custom post types: 1) Accounts (arevtest_org) 2)Contacts (arevtest_contact).

    A field of type ‘Relationship’ is created on arevtest_contact and related to arevtets_org.

    Could you please help us understand how we can map this relationship from WordPress to Salesforce? In the Fieldmaps we tried selecting the Relationship field on the WordPress Contact POD corresponding to AccountID on the Salesforce Object. But the Salesforce AccountID expects a Salesforce Record ID and hence this fails. We observed the Contact Relationship field is sending a string like this to Salesforce:

    “57267;10067;2018-11-26 21:49:06;2018-11-26 13:49:06;;DAD Test 1;;publish;closed;closed;;dad-test-1;;;2018-11-26 21:49:06;2018-11-26 13:49:06;;0;https://test.site/?post_type=arevtest_org&p=57267;0;arevtest_org;;0;57267”

    where,
    57267 – WordPress ID of Account
    DAD Test 1 – Account Name
    Arevtest_org – POD name for Accounts

    Would appreciate any suggestions to make this work!

Viewing 1 replies (of 1 total)
  • Plugin Author Jonathan Stegall

    (@jonathanstegall)

    @ritikarawlani this kind of functionality is not currently built into the plugin, however it’s possible you could do it with developer hooks.

    I’m not sure if you can do it because the two objects both are created in Salesforce at the same time, but here’s what you could possibly investigate:

    1. All of the developer hooks are listed in the documentationdocumentation.
    2. We have several hooks that modify what happens before the plugin saves data. They’re described here. For example, there’s object_sync_for_salesforce_pre_push and object_sync_for_salesforce_push_success. I think it’s possible you could use one of those. But again I’m not sure it would work because the two objects are being created at the same time.

Viewing 1 replies (of 1 total)
  • The topic ‘Mapping Lookup Relationships from WP to SF’ is closed to new replies.

Tags