I have JSON data that I need to fetch on a schedule. I need to parse the JSON data into an AirTable or maybe Tableau for Invoicing and Reporting.

The data is from a shipping and fulfillment business. I need to tally up thousands of shipments I fulfilled for each customer over the week and generate invoices to send them. I’d also like to view reports on this data and run analytics and charting etc. in the future if possible.

I’m not sure if AirTable or Tableau is the better solution, or perhaps you have another suggestion?