JSON import/export
Given the widespread use JSON as a data transport, we should have:
Application.ImportJSON
Application.ExportJSON
like we have:
Application.ImportXML
Application.ExportXML
There are a few libraries out there – replacing these with one or a few lines of code would be extremely useful.
Gustav
shared this idea
6 comments
-
Ben Sacheri
commented
It's a no-brainer that Microsoft should add JSON support. It's an industry standard. What are they waiting for?
-
isladogs
commented
I've previously voted for similar suggestions:
a) add a JSON.dll
b) add an Access equivalent of Excel Power Query (Get & Transform)However, its done, the important thing is that it is done.
In the meantime, I will continue / developing using my JATFA (JSON Analyse & Transform for Access) app which is available from http://www.mendipdatasystems.co.uk/json-analyse-transform/4594138310Of course, if MS adds this functionality, my app may well become redundant
-
Krish J
commented
Here is a free plugin that can import and export json. Have a look at my Github project. https://github.com/krishKM/VBA_TOOLS#importjson
-
Mark Burns
commented
I would vote for this (if I had any votes left).
-
Anonymous
commented
Ready Abi
-
Karl Donaubauer
commented
There is also Peter Bryant's older JSON suggestion:
https://access.uservoice.com/forums/319956-access-desktop-application/suggestions/18917560-give-us-a-new-dll-msjson-dll.