Skip to main content
Solved

Retrieving JSON data from external API and updating records daily

  • May 29, 2019
  • 2 replies
  • 39 views

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?

Best answer by Justin_Barrett

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.

2 replies

Justin_Barrett
Forum|alt.badge.img+21
  • Inspiring
  • 4647 replies
  • Answer
  • May 30, 2019

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.


  • Author
  • New Participant
  • 1 reply
  • May 30, 2019

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.


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!