VBA-JSON
JSON conversion and parsing for VBA (by VBA-tools)
airtable.js
Airtable javascript client (by Airtable)
Our great sponsors
VBA-JSON | airtable.js | |
---|---|---|
15 | 6 | |
1,650 | 1,918 | |
1.9% | 1.7% | |
0.0 | 2.9 | |
about 2 months ago | 25 days ago | |
Visual Basic | JavaScript | |
MIT License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
VBA-JSON
Posts with mentions or reviews of VBA-JSON.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-04-06.
- FILTER XML and WEBSERVICE Support Please
-
Windows Defender showing Trojan virus in my own created XLSM file [EXCEL]
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.
-
What’s a good stopping point for actively learning VBA?
Integration of user-created modules to assist https://github.com/VBA-tools/VBA-JSON/blob/master/JsonConverter.bas
- How to convert an excel form in a JSON like text using VBA
-
Json to tabular (in excel)
There is also a VBA-JSON library you might look into. It processes the JSON to a series of dictionary/collection objects.
-
Coding Diary 2022-06-17
the JSON parser came from this: VBA-JSON
-
Is there any way to format and stylise an excel file from an json file?
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.
-
Visual Basic 6 + JSON
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
-
API (JSON) call into MsAccess
I've done something similar using a HTTP request and a JSON converter module.
-
Show Data of Record in single cell (JSON Import)
If you're comfortable with VBA, you might want to check out VBA-JSON.
airtable.js
Posts with mentions or reviews of airtable.js.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-10-15.
-
Airtable as directory for website
They have published an example too https://github.com/Airtable/airtable.js/blob/master/test/test_files/index.html
-
Build a full-stack Jamstack Application
Install the Airtable JavaScript SDK to work with Airtable inside a Next.js application.
-
Build a Landing Page using Airtable as a CMS with SyncInc
Initially using the airtable.js package we statically generated a splash page that pulls data from Airtable directly to the page.
-
The ultimate prototyping stack: Six hacks for rapid prototyping on Airtable
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.
- VBA API to get data
-
Using Airtable as a database to store realtime messages
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.
What are some alternatives?
When comparing VBA-JSON and airtable.js you can also consider the following projects:
crypto_vba - An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
next-airtable-splash
ably-airtable-starter-kit - A fully functional starter kit to store realtime messages from Ably into Airtable via WebHooks