List records API with filterByFormula: find email address with a '+' fails (like bob+1@gmail.com)

Question

Hi,I'm attempting to locate a know record with an email address containing a "+".  I've tried introducing a '\' and '\' before the '+' to no avail.  Tried CURL with your API encoder, no luck.CURL EXAMPLE:curl -H "Authorization: Bearer patZZZZZZ" https://api.airtable.com/v0/appXXXXX/tblYYYYY? filterByFormula=%7BEmail%7D%3D%22bob%5C%2B1%40gmail.com%22I can get results with an email without a '+' character in nodeJS and CURL.How do I specify a filter that enables the retrieval of a record by email address containing a plus?  This does NOT work:const header = {   maxRecords: 1,   filterByFormula: `{Email}="${email}"`,   fields: [      "Record ID"   ],   view: "BulkEmail"}

scubachris · Accepted Answer

@dilipborad: First, thanks so much for looking at this and trying to help!

I was not clear on what I'm trying to accomplish. I want to look up a known email address that has a '+' and retrieve the recordID for that specific email, not all emails. But you gave me a tool that does work -- REGEX_MATCH. Not sure why you have the AND, but the solution in JS is to prepend '\\' before the plus. So bob+1@bob.com --> bob\\+1@bob.com.

var Airtable = require('airtable');

var base = new Airtable({apiKey: 'XXX'}).base('appYYY');

var targetEmail='bob+1@bob.com';

targetEmail = targetEmail.includes('+') ? targetEmail.replace('+', '\\+') : targetEmail;

base('Candidate').select({

maxRecords: 1,

filterByFormula: `REGEX_MATCH({Email},"${targetEmail}")`

}).eachPage(function page(records, fetchNextPage) {

records.forEach(function(record) {

console.log('Found', record.get('Record ID'));

});

}, function done(err) {

if (err) {

console.error(err); return;

}

});

THANK YOU!

dilipborad · Answer

Hello @scubachris This is bit tricky.First of all use this to encode your url and change input parameters accordingly. https://codepen.io/airtable/full/MeXqOgNow let's see what i've tested on my side.This is my created table just for testing purpose.I've used Regular Expression based function with filterByFormula. check it https://support.airtable.com/docs/guide-to-regex-functionsMy testing response image.URL Encoder image.This need a bit of technical knowledge but I hope you get it. Try it on your side.&#128077;

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded