LLodi DB

Last updated 16 days ago

post
To DB

{your llodi DB URL}
/todb?param=value
Request
Response
Headers
content-type
required
string
application/json
llodi-key
optional
string
(if required)
Query Parameters
name
optional
string
one of the DB connected
conn_id
optional
string
one of the DB connected
schema
optional
string
schema name
table
optional
string
table name
operation
optional
string
insert/update/delete/
where
optional
string
use your own db language
truncate
optional
boolean
if insert
ignore
optional
string
if insert
200: OK
404: Not Found
{
"status": "error",
"result": "Connection not found"
}

post
To File

{your llodi DB URL}
/tofile?param=value
Request
Response
Headers
content-type
required
string
application/json
llodi-key
optional
string
(if required)
Query Parameters
type
optional
string
json/csv/xml/text
root
optional
string
path for the file
filename
optional
string
name for the file
extension
optional
string
if different than default
currdate
optional
boolean
filename includes date
csv_separator
optional
string
overrides default
csv_delimiter
optional
string
overrides default
append
optional
boolean
200: OK
Example Request
/tofile?type=csv&csv_separator=null&csv_delimiter=,&filename=llodi
HTTPHEADER: Content-type=application/json
BODY:
[
{"column1":"value1","column2":"value2"},
{"column1":"value3","column2":"value4"}
]
Result file: llodi.csv
column1,column2
value1,value2
value3,value4