VBA-JSON VS airtable.js

I am the creator of the Excel macro-enabled file; it has a bunch of in-built windows references being used & an external JSONConveter module (https://github.com/VBA-tools/VBA-JSON/blob/master/JsonConverter.bas). These references & json module have been in the file since a long time. Until today I didn't receive any sorts of warnings for my xlsm files, all of a sudden "Severe" warnings are popping up for all copies I have of this file. Haven't noticed this virus error so far in any of my users' PCs.

Integration of user-created modules to assist https://github.com/VBA-tools/VBA-JSON/blob/master/JsonConverter.bas

There is also a VBA-JSON library you might look into. It processes the JSON to a series of dictionary/collection objects.

the JSON parser came from this: VBA-JSON

Have you tried the VBA-JSON library? That includes a method that will format your JSON files with indenting, etc. As for styling the output, that again can be done with VBA. I did something just like this a few years ago, I can look for the code if you're interested.

I've used this https://github.com/VBA-tools/VBA-JSON in the past with VBA which may work for your case and it had issues if it was very complicated json but for things like web services worked fine for me

I've done something similar using a HTTP request and a JSON converter module.

If you're comfortable with VBA, you might want to check out VBA-JSON.

They have published an example too https://github.com/Airtable/airtable.js/blob/master/test/test_files/index.html

Install the Airtable JavaScript SDK to work with Airtable inside a Next.js application.

Initially using the airtable.js package we statically generated a splash page that pulls data from Airtable directly to the page.

Even with Airtable.js to help manage retries, reading data through the API is an uphill climb. Between the rate limits, pagination, and Airtable's unique filterBy parameter you'll find many little quirks. The API is especially slow and onerous when you need to make nested calls to source data from several tables to create a complete data view. And, as you leverage Airtable's ease of use to make updates to your base, your API calls can break as columns and tables change.

Airtable comes with a simple REST API to perform the basic CRUD operations on the data stored. You'll need to have a base i.e. a table/ sheet set up before you can check out the documentation. This is for a good reason - their whole documentation is dynamically displayed with real keys, ids, column names etc, along with sample responses, based off your data, making it super easy for you to just copy out the code and use as is. They provide this documentation in cURL and JavaScript. The JS code snippets require using the Airtable JavaScript Client SDK. Here's a look at the documentation for the chat app base.