Skip to main content

Search by email and get Record ID

  • October 25, 2022
  • 3 replies
  • 22 views
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
  • Kosta_Kondraten
  • Author
  • Inspiring
  • 46 replies
  • October 25, 2022

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
  • Still-Learning
  • Inspiring
  • 5 replies
  • November 6, 2022

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+29
  • kuovonne
  • Brainy
  • 6009 replies
  • November 6, 2022

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.


Terms & ConditionsAccessibility statement