Bug connecting Airtable & Salesforce

Hi everyone,
I am new here and using make. I’ve able to create few scenarios but I am stuck in using the Salesforce connection.

I want to connect Salesforce to an Airtable Database, so that modifications made on one side can be pushed on the other side. My “matching key” would be the email of the person, but everytime I try to retrive it from Salesforce, I’ve got an error 400. I am able to list other info, but every time I try with the mail it blocks. Any idea of how I can debug this?

  • The operation failed with an error. [400] FIELDS(ALL) FROM Contact WHERE LIMIT 10 ^ ERROR at Row:1:Column:39 unexpected token: ‘LIMIT’

Basically, I am trying to create a flow that does the following thing: once my suscriber sent the form, he is created in Salesforce and in Airtable by 2 distincts flow (not using Make).

  • Find an opportunity record in Salesforce and add the opportunity ID in an existing Airtable column
  • Find a contact record in Salesforce and add the contact ID in an existing Airtable column

Thank you for your help!