[Components] mitra

[pipedream-component-development]

mitra

URLs

• https://mitralab.io/docs/api

Actions

get-data

Prompt

Fetches data from the specified table, allowing dynamic filters via query parameters.

insert-data

Prompt

Inserts one or more records into a table.

update-data

Prompt

Updates one or more records in a table.

delete-data

Prompt

Removes a record from a table.

[jcortes]

There is a problem with the Mitra's api Insert Data endpoint because If I run the following command as an example where I previously have created the table Posts with ID as autoincrement and Description as the only text column.

curl -X POST 'https://api.mitrasheet.com:4088/rest/v0/Posts' \
-H 'Authorization: Bearer ${MY_API_KEY}' \
-H 'Content-Type: application/json' \
-d '{"Description": "Test 3"}'

I get the following error:

{
"name":"INTERNAL_SERVER_ERROR",
"code":500,
"date":"2024-10-19T00:28:06.818+00:00",
"tenant":"tenant_10377",
"message":"PreparedStatementCallback; SQL [INSERT INTO DIM_1001 (ID,DESCR) VALUES (?,?)]; 
  Duplicate entry '3' for key 'DIM_1001.PRIMARY'; 
  nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '3' for key 'DIM_1001.PRIMARY'", ...

@malexanderlim I'm moving this as blocked in the meanwhile