🗃️ Dynamic DBs — Solved API

GET /dynamicDbs

List all Dynamic DBs.
Response

[
  { "id": "abc123", "displayName": "Varieties", "optionsLength": 5, "lastUpdated": "2025-04-30T10:23:12.000Z" }
]

GET /dynamicDbs/:dynamicDbId

Get the full content of a specific Dynamic DB.
Response

{
  "id": "abc123",
  "displayName": "Varieties",
  "options": [
    { "id": "401296", "displayName": "401296", "attributes": { "Proveedor": "ELECTRONICA", "Precio": 23.5 } }
  ],
  "updatedAt": "2025-05-01T09:00:00.000Z"
}

PUT /dynamicDbs/:dynamicDbId

Update a Dynamic DB with new options.

Simple Example

{
  "newOptions": [
    { "displayName": "New Option A", "id": "option-a", "default": false },
    { "displayName": "New Option B" }
  ]
}

With attributes

{
  "newOptions": [
    {
      "displayName": "ERP Option",
      "attributes": { "Referencia ERP": "401296", "Proveedor": "ELECTRONICA", "Precio": 23.5 }
    }
  ]
}

Python Example

dbs = requests.get(f"{BASE_URL}/dynamicDbs", headers=auth).json()
db_id = dbs[0]["id"]

full_db = requests.get(f"{BASE_URL}/dynamicDbs/{db_id}", headers=auth).json()
print(full_db)

payload = { "newOptions": [ { "displayName": "ERP Option A", "attributes": {"Precio": 21.0} } ] }
res = requests.put(f"{BASE_URL}/dynamicDbs/{db_id}", headers={**auth, "Content-Type":"application/json"}, json=payload)
print(res.json())

JavaScript Example

const dbs = await (await fetch(`${BASE_URL}/dynamicDbs`, { headers })).json();
const dbId = dbs[0].id;

const fullDb = await (await fetch(`${BASE_URL}/dynamicDbs/${dbId}`, { headers })).json();

const body = { newOptions: [{ displayName: 'Option JS A', attributes: { Precio: 23.5 } }] };
await fetch(`${BASE_URL}/dynamicDbs/${dbId}`, {
  method: 'PUT',
  headers: { ...headers, 'Content-Type': 'application/json' },
  body: JSON.stringify(body)
});