Query errors being logged for SF pulls

  • Resolved raphaelzulik

    (@raphaelzulik)


    3 years, 10 months ago

    Hi there,

    I’m trying to create new WordPress users when new contacts are created in SF but when performing a scheduled pull from SF, the following errors get logged:

    
Error: 400: on Salesforce HTTP request

URL: https://testcompany5.my.salesforce.com/services/data/v54.0/query?q=SELECT+Id%2C+Email%2C+%2C+CreatedDate+FROM+Contact+WHERE++%3E+2022-07-26T08%3A23%3A47Z+AND+CreatedDate+%3E+2022-07-26T08%3A23%3A47Z+AND+LastModifiedDate+%3E+2022-07-26T11%3A55%3A49Z+ORDER+BY++ASC+LIMIT+25+OFFSET+275

Message:
SELECT Id, Email, , CreatedDate FROM Contact WHERE
^
ERROR at Row:1:Column:18
unexpected token: ','

Code: 400

    and

    
Error: MALFORMED_QUERY when pulling Contact data from Salesforce

SELECT Id, Email, , CreatedDate FROM Contact WHERE
^
ERROR at Row:1:Column:18
unexpected token: ','

    There appears to be an issue with how these queries get constructed within the plugin, please let me know if there’s anything I can try on my side to remedy?

    Thanks so much!

    The page I need help with: [log in to see the link]

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

    (@jonathanstegall)

    3 years, 10 months ago

    It looks to me like the plugin is trying to add a field to the query but the field is blank. My guess is that your fieldmap has an issue. If you’re able to find it, make sure to clear the plugin cache.

    Thread Starter raphaelzulik

    (@raphaelzulik)

    3 years, 10 months ago

    Thanks for the fast response 🙂

    I see, it must have been an issue with one of the ACF fields I had – I adjusted it and now it’s working fine.

    Thanks so much for your help!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Query errors being logged for SF pulls’ is closed to new replies.