Pull data problem

  • Resolved wolfage

    (@wolfage)


    3 years, 6 months ago

    Hi! I have some strange problem with pulling data from SF to my wordpress site. I have two custom post types that are synced with SF instances. One is “Attendees” and second is “Speakers”. “Attendees” are pulling from SF to the site without any problems. But “Speakers” stop pull at all. But before everything works. One notice, accidently fieldmap for “Speakers” was removed from site so i have recreated it again manually, but new “Speakers” don’t pull from SF to the site. One thing that think could be a possible reason of problem is fields types. Most mapped fields are simple textfields in SF and in WP, but i have one field, called is_keynote which in SF is checkbox field and i map it with ACF True/False field. Maybe such mapping could cause any problems?

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

    (@jonathanstegall)

    I don’t think an ACF checkbox should be a problem. Especially if it was previously working.

    Try these steps to start debugging:

    1. First clear the plugin cache. It’s possible something is remaining from the previous fieldmap.
    2. Turn on debug mode in the plugin settings
    2. Update some of your Salesforce records for Speakers
    3. Watch what API call log entries the plugin creates.

    If the plugin is pulling data from the Speakers record type, it will create a log entry with the query that it is sending to Salesforce, and you can check if there’s an issue with the query.

    Thread Starter wolfage

    (@wolfage)

    @jonathanstegall First, thanks for your fast response. Yeah, i already did cache clear command before made new fieldmap. About the API call – i update one of my Speakers in SF and in log for this plugin i see such call “URL of API call to Salesforce: https://mill-all.my.salesforce.com/services/data/v52.0/sobjects/Online_Speaker__c/deleted/?start=2021-09-03T11:59:40Z&end=2021-09-03T12:09:40Z” I’m a little wondered why in this url exist word “deleted”.

    Plugin Author Jonathan Stegall

    (@jonathanstegall)

    This particular log is an API call that retrieves records that were from Salesforce between 2021-09-03T11:59:40Z and 2021-09-03T12:09:40Z. All it means is that you’ve configured the plugin to check for records that have been deleted from Salesforce and it’s doing that correctly.

    The API log you are going to want to inspect is probably not that one, unless it’s deleted records that are giving you trouble.

    Thread Starter wolfage

    (@wolfage)

    @jonathanstegall It looks that it doesn’t create some special call for Speakers, because if i update Attendee for example i see a full list of calls where it call this Attendee, make query call for it etc. For Speaker nothing similar, just something like this see in log https://mill-all.my.salesforce.com/services/data

    Plugin Author Jonathan Stegall

    (@jonathanstegall)

    In that case, it isn’t running the calls that it needs to run and that is why the records aren’t being updated.

    It’s possible that the plugin still has a last modified date stored for the object that is preventing it from running. If you have access to your database, you might take a backup of it and then try some of these things:

    You might also want to check into the wp_object_sync_sf_field_map table where these fieldmaps are stored, and just do a check on what is being stored for this fieldmap compared to the one that works.

    You might then check and see if there’s a value in the options table called object_sync_for_salesforce_pull_last_sync_Speaker and if there is, delete it. I don’t think that would be the cause of this issue, but it’s worth checking, and if there are any other values in the options table that correspond only to this specific Salesforce object type, you could try deleting those as well.

    I’m not sure what to tell you aside from that, but it would be good to know if any of those things reveal that there is an issue.

    Thread Starter wolfage

    (@wolfage)

    @jonathanstegall ok, for wp_object_sync_sf_field_map only one difference is last field called version, for working instance it is 2.0.0 and not working has 2.0.1. Also i have removed this object_sync_for_salesforce_pull_last_sync_Speaker, but still in Api calls only this https://mill-all.my.salesforce.com/services/data/v52.0/sobjects/Online_Speaker__c/deleted/?start=2021-09-03T15:39:39Z&end=2021-09-03T15:49:20Z

    Plugin Author Jonathan Stegall

    (@jonathanstegall)

    I don’t think the version field should make a difference. You may want to edit your scheduling settings. Maybe try changing the frequency and then changing it back, see if that does a reset for you (in case the old fieldmap still has data that is preventing the new one).

    Essentially, in debug mode you should see a log entry with a SQL query for the object, even if there are no results returned for it. That you don’t see one suggests that either it’s not set up correctly, or it just isn’t running.

    Beyond that, I don’t think I can offer any further support, it seems to me like you’d need a developer to investigate further with code.

    Thread Starter wolfage

    (@wolfage)

    @jonathanstegall ohh, looks finally i find where was a problem and fix it. So i heard third fieldmap called List, which was used very rarely, so i decide to check it and notice that there Date Field to Trigger Pull: was set to Created Date instead instead System Modstamp. I have changed it to the System Modstamp and Speakers start to appears on site. Looks like one fieldmap had bad influence on another fieldmap

    Thread Starter wolfage

    (@wolfage)

    @jonathanstegall Thank you for your help and quick responses!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Pull data problem’ is closed to new replies.

Tags