loopmill

Hi Jonathan

It gets stranger!

I do get a result in the developer console!
It lists one single row, which is the exact change I made earlier today.

So for some reason when WP is executing that same query it returns nothing, but in the SF developer console it returns the change I made.

Does this mean it could be a permission issue on the cron job?

When I manually run salesforce_pull from the edit user screen in WP it works as expected and retrieves the latest change(s)!

Best
Chris

Hi Jonathan

Thanks for a fast response!

So far I’m mapping:

Field Map 1 (working both ways)

WP CPT ‘course’ <-> SF Custom object ‘Course’
————————————
post_title <——> Course Name (standard field – name)

Field Map 2 (working one way WP -> SF)

WP User ——> SF Contact
————————-
display_name -> Person Name**
user_email—-> Email Primary (SF custom field)
nickname —–> Nick Name (SF custom field)

Neither fields are being handled by plugins. The course CPT is created in the theme, I’m using the standard user fields.

I turned on debug logging and found that there was a call to get updated contacts:

log title:
Debug: on Salesforce API HTTP Request to URL: https://na24.salesforce.com/services/data/v42.0/query?q=SELECT+Name%2C+Email_Primary__c%2C+Nick_Name__c%2C+Id%2C+LastModifiedDate%2C+CreatedDate+FROM+Person__c+WHERE+LastModifiedDate+%3E+2018-04-06T13%3A09%3A17Z+ORDER+BY+LastModifiedDate+ASC.

log contents:

Array
(
[json] => {“totalSize”:0,”done”:true,”records”:[]}
[code] => 200
[data] => Array
(
[totalSize] => 0
[done] => 1
[records] => Array
(
)
)

Finally, I checked in SalesForce and both my modified contacts and my modified courses are showing similar last modified dates, however I noticed that the field for course name is indexed, whereas the fields for contacts that I was changing (nick name and email primary) are not indexed. I couldn't work out how to index these fields in SF, but I turned on "track history" without success.

I didn't try to change Person name as I assume this would cause an issue with WP not liking user_login to change.

Could indexing of fields be to blame or am I barking up the wrong tree?

Many thanks
Chris

Hi Jonathan
Thanks for a fast response!
<br><br>
So far I’m mapping:
<br><br>
Field Map 1 (working both ways)

WP CPT ‘course’ <-> SF Custom object ‘Course’
———————————–
post_title <-> Course Name (standard field – name)
<br><br><br>
Field Map 2 (working one way WP -> SF)

WP User -> SF Contact
———————————–
display_name -> Person Name**
user_email -> Email Primary (SF custom field)
nickname -> Nick Name (SF custom field)
<br><br><br>
Neither fields are being handled by plugins. The course CPT is created in the theme, I’m using the standard user fields.
<br><br>
I turned on debug logging and found that there was a call to get updated contacts:
<br><br>
log title:
Debug: on Salesforce API HTTP Request to URL: https://na24.salesforce.com/services/data/v42.0/query?q=SELECT+Name%2C+Email_Primary__c%2C+Nick_Name__c%2C+Id%2C+LastModifiedDate%2C+CreatedDate+FROM+Person__c+WHERE+LastModifiedDate+%3E+2018-04-06T13%3A09%3A17Z+ORDER+BY+LastModifiedDate+ASC.
<br><br>
log contents:
Array
(
[json] => {“totalSize”:0,”done”:true,”records”:[]}
[code] => 200
[data] => Array
(
[totalSize] => 0
[done] => 1
[records] => Array
(
)

)
<br><br>
Finally, I checked in SalesForce and both my modified contacts and my modified courses are showing similar last modified dates, however I noticed that the field for course name is indexed, whereas the fields for contacts that I was changing (nick name and email primary) are not indexed. I couldn't work out how to index these fields in SF, but I turned on "track history" without success.
<br><br>
I didn't try to change Person name as I assume this would cause an issue with WP not liking user_login to change.
<br><br>
Could indexing of fields be to blame or am I barking up the wrong tree?
<br><br>
Many thanks
Chris