Hello everyone, the latest project needs to be docked with the interface of a mall, simply to call their various interfaces, such as ordering, commodity inquiry, freight and so on.

in accordance with the previous practice, in order to facilitate statistical analysis, we will use mysql, to create new tables and various fields to store the returned data. However, the format of the return parameters of different interfaces is different, which may lead to the need to create a large number of tables to solve the storage problem; if only one field is used to store the core parameters of the interface (json format), it will become very difficult to facilitate statistical analysis.

does using mongodb to store interface data make things easier, as mongodb uses json to store data and supports rich query expressions. Can the great gods who have used talk about the feasibility of this scheme, or is there a better plan for the storage, processing and analysis of interface data?