Skip to main content

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!

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


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


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