Reading (GET) and Editing (PUT) in one place through API (JSON)

Question

I really wanted you to give you a better post-title, but I really don't know how to describe my question in other words.

What I'm looking for (and thought it would be a short search), seems to be hard to find. To make it easier to manage data from our webshop, I'm looking for a piece of software / self-hosted solution to:

• Read data
• Change / Update data
• Delete data
• Sort data
• Filter data

by connecting to the database through API (JSON)

I don't know where to look.. It would be great if there's a free / open-source solution

Thank you very much in advance!

[EDIT] I'm actually looking for a Ready to Use software without the need of development skills. Like Postman, but more practical.

We're using Lightspeed HQ as shop-environment which doesn't give direct database access, but it has an API to be used with the right credentials. There's also a Postman library available.

Answer 1

I suggest that you start taking a look at the use of python to interact with databases via JSON APIs there is a nice walk through here that makes use of the installable requests library (pip install requests) and the JSON library (built in to the standard library).

Certainly you should probably also look at Pandas for converting your API responses into data frames for easy filtering, sorting, etc. this can be as simple as:

import requests
import pandas as pd

r = requests.get('http//your-query-url')

j = r.json()

df = pd.DataFrame.from_dict(j)

All of the above software is:

• Free, Gratis & Open Source
• Cross platform
• Permissive licences