Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

I'd like to import a figure from an external website, and update it when it changes

Topic Labels: Automations
389 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Barry_Thomas
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all,

Firstly, apologies if this has been asked / answered before, I had a search through and couldn't find it.

I'd like to import a number from an external website and automatically update it when it changes.  Also would I need their permission for this?

The website is transfermarkt.com it gives an estimated market value for individual football / soccer players.  I have a database of players, and I'd like the estimated value for each one in a column.

Is this possible?

Many thanks in advance 

Barry

4 Replies 4
ScottWorld
18 - Pluto
18 - Pluto

Do they have an API that you can tap into? If so, you can either use DataFetcher or Make's HTTP module to automatically bring in the new numbers into Airtable.

Otherwise, can you get a CSV file from them with the new data? If so, you can use Make's CSV modules to automatically bring the new data into Airtable. I give step-by-step instructions on how to do this on this Airtable podcast episode.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

matthew_b
7 - App Architect
7 - App Architect

+1 for Data Fetcher. Assuming transfermarkt.com has an API, Data Fetcher is great for pulling in data to Airtable like this.

Barry_Thomas
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you very much for the informative reply.  I'll give Data Fetcher a try .  Really appreciate it 

Barry_Thomas
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you, really appreciate your response.  I'll have a look at Data Fetcher.