Skip to main content

Search by email and get Record ID

K
Forum|alt.badge.img+12

Hi,

How can I get a Record ID by a VLOOKUP type situation by specifiying email in other words I want to pass email I want to find to API and get the record id so I could use it to upload a field. Thanks!

3 replies

K
Forum|alt.badge.img+12

Never mind worked it out https://api.airtable.com/v0/appzNOZaonMIXQNnZ/tblHCYvBsWaGJGsr4?fields[]=Email&filterByFormula=Email%3D"random.name%40companyurl.com.au"

S
Forum|alt.badge.img+3
Kosta_Kondraten wrote:

Never mind worked it out https://api.airtable.com/v0/appzNOZaonMIXQNnZ/tblHCYvBsWaGJGsr4?fields[]=Email&filterByFormula=Email%3D"random.name%40companyurl.com.au"


Your url is not in valid format

https://api.airtable.com/v0/enterBaseID/enterTableName?api_key=enterAPIKey&filterByFormula=enterFormula

kuovonne
Forum|alt.badge.img+27
  • kuovonne
  • Brainy
  • 6002 replies
  • November 6, 2022
Still-Learning wrote:

Your url is not in valid format

https://api.airtable.com/v0/enterBaseID/enterTableName?api_key=enterAPIKey&filterByFormula=enterFormula


Can you explain why you think the url is not valid? It was posted as the solution. The main difference that I see in your url is that you include the API key in your url. However, if the API key is sent in the header, it need not be included in the url.

Reply


Most helpful members this week

Terms & Conditions