How to extract JSON held at webpage and send to spreadsheet

Status: Closed · Asked by demonboy on Mar 28, 2024 · 0 views

demonboy — Question · Mar 28, 2024

Hi,

I have a JSON file held at a public-facing URL. How do I extract the data contained within it and send the multiple entries to a spreadsheet? It seems any of the JSON triggers have to be inline after the first trigger and can't start with the JSON extractor.
Thanks

Fagun Shah — Reply · Mar 28, 2024

Use the scheduler as the trigger and then use API action -

Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/

demonboy — Reply · Mar 28, 2024

That's perfect, thank you @Fagun Shah

Back to all forum threads · Log in to reply