json integrating sql insert queries

[ClementSo]

Hello,

I would like to create a json integrating sql insert queries.

Could you help me ?

Thanks

[danilang]

Hi @ClementSo 

Can you provide some simple examples of what you're trying to do?  

Thanks

Dan

[ClementSo]

Hi Danilang,

here is an example :

INSERT INTO safety_training (uuid,name,type,validity_duration,created_at,created_by) VALUES ('cab9ed36-1720-42fe-b36f-4629c4feb524','B2V','security-electric','36','2023-04-07 00:00:00','system');

[danilang]

Thanks @ClementSo 

That's a standard SQL Insert statement. Where does the json fit into all this?

Dan

[ClementSo]

Hi @danilang ,

I would like to wrap this sql request in a json and i have several of the same type to put in the same json.