First, you should know how to read JSON file.
Read JSON file using Python - GeeksforGeeks
Then, put each data into a list or dictionary.
Finally, you can apply data.
Setting Vertex Color via Python - Coding / Python Support - Blender Artists Community