appending json file

[Buddy]

Hi Guys,

I'm really new to python and just starting studying the basics of it. So please forgive me if I'm abit slow in understanding :)

So here is my issue, I have been trying to write a json file using python where the data comes from a API from our vendor. My issue is every time I append it, the file becomes an invalid json file.Using the json viewer, below is a sample of the json file. The API will only allow me to download max 100 data and then I need to use pagination to extract all data from the API. Hope someone can help me with it :)

{}-metadata
[]interactiondata
{}0
{}info
{}sdes
{}surveys
{}campaign
{}linescores
{}transcripts
{}visitorinfo
{}1
{}2
{}3

[buran]

You cannot add to the json file. You can collect all the information in memory in a single data structure and dump it to a file. If file already exists from previous runs of the script and you want to add to it, you need to load it first, update in memory and overwrite it.

[Buddy]

hi buran,
Thank you for the reply..how do it with python? Can you show me the correct way?

[Larz60+]

As buran stated above, you need to load update and dump.
I have an example that does that, look at the customer file in
code here:
https://python-forum.io/Thread-ShoeBot-Problems?page=2 (Last post)
it is loaded at the beginning of the program, and saved whenever an update is
performed with the save_data method.

[Buddy]

thanks larz60 for the code. I will have to read and study it first before i can use it :) Btw what if i want to save multiple json files using python lets say for every page i read?

[Larz60+]

you would just have to give each a name and dump the data.
You need to look at the json documents to get a feel for what is allowed and what is not.

below is a very basic document on how to save and retrieve json data.
see: https://code.tutsplus.com/tutorials/how-...-cms-25758

here on types of structures:
https://www.w3resource.com/JSON/structures.php

Depending on what you want to save, it may or may not be the right choice.