Retrieving JSON data from external API and updating records daily

[Pedro_A_Lima]

Hi folks,

I’m trying to find a simple way of updating records with data retrieved from JSON data feed.

Ideally, GET requests would be sent daily (or 2x a day) to the feed and records updated accordingly using the AirTable API.

Tried using Zapier Webhooks but I can’t get it working :frowning:

Any ideas?

[Justin_Barrett · Accepted solution]

Have you tried Integromat? I’ve not yet used JSON data directly, but there’s a JSON service in Integromat, and you can create webhooks there as well. Might be worth a shot.

[Pedro_A_Lima]

Nice!! Just tried it and managed to push data from the API to AirTable in less than 10 minutes. Thanks for the tip!

Now just need to explore Integromat docs for a while… :nerd_face:

Thank you, Justin!