Json To Sql API
https://api.findutils.com/api/tools/json-to-sql/execute Convert a JSON array of objects into SQL INSERT statements, optionally preceded by a CREATE TABLE. Column types come from the real JSON values, so booleans stay booleans and null becomes NULL rather than the text "null". A nested object or array is stored as JSON text. Identifiers are quoted for the chosen dialect (Postgres, MySQL or SQLite). A single object is treated as one row, and NDJSON is accepted. Nothing is executed against a database.
Request body
application/json-
json
string required
A JSON array of objects, a single object, or NDJSON.
-
table
string optional
Target table name. Default: "my_table". Default
"my_table". -
dialect
string optional
Identifier quoting and type names. Default: postgres. One of
postgres · mysql · sqlite. Default"postgres". -
create_table
boolean optional
Emit a CREATE TABLE before the inserts. Default: true. Default
true. -
batch
boolean optional
Emit multi-row INSERTs instead of one statement per row. Default: false. Default
false.
Example arguments
Verified{
"json": [
{
"id": 1,
"name": "Ada",
"active": true
}
],
"table": "people",
"dialect": "postgres"
}More Data tools
- Api Docs Generator Return API documentation generated from a list of endpoints, as Markdown (with table of contents, request/response examples) or as an OpenAP
- Bookmarks Html To Csv Convert a browser bookmarks.html export from Chrome, Firefox, Edge, Safari or any other browser that writes the Netscape bookmark format int
- Csv To Bookmarks Html Convert a CSV of links into a Netscape bookmarks.html file that Chrome, Firefox, Edge and Safari import.
- Csv To Json Parse CSV text into an array of objects keyed by the header row.
- Csv To Ndjson Convert CSV into newline-delimited JSON (NDJSON, JSON Lines, .jsonl): one JSON object per line, keyed by the header row.
- Csv To Sql Convert CSV text into SQL INSERT statements, optionally preceded by a CREATE TABLE.