We need two additional data from Category API …/categories.json
- user - who created the category
- created_at - when it was created
Although in data explorer plugin I can fetch the above additional fields from category table in sql . So data already reside in table only need to fetch in rest api response also.
I believe that you need to create a plugin and add those fields to the serializer.
I got the solution
We can run the rest api on the basis of sql query id saved in data explorer by its sql id.
It will be a post rest api with aoi key and user .
The trade off is having an extra API call in the script vs creating a plugin which could break things and is harder to install and maintain.