Budibase external collection



I want to connect an external collection (BudiBase) via API but an error occurred when calling Get All

I got this message

Could not find any results. Are you sure the Results Key is correct? You can update that by going back and clicking into “Get All”

URL Called:
https://budibase.app/api/public/v1/tables/ta_b3660xxxxxxxxxxxxxxxxxxx

Full Response:

{
  "data": {
    "_id": "ta_b3660xxxxxxxxxxxxxxxxxxx",
    "name": "Eventi",
    "schema": {
      "Auto ID": {
        "name": "Auto ID",
        "type": "number",
        "subtype": "autoID",
        "icon": "ri-magic-line",
        "autocolumn": true,
        "constraints": {
          "type": "number",
          "presence": false,
          "numericality": {
            "greaterThanOrEqualTo": "",
            "lessThanOrEqualTo": ""
          }
        },
        "visible": true,
        "width": 120,
        "lastID": 12
      },
      "Created By": {
        "name": "Created By",
        "type": "link",
        "subtype": "createdBy",
        "icon": "ri-magic-line",
        "autocolumn": true,
        "constraints": {
          "type": "array",
          "presence": false
        },
        "tableId": "ta_users",
        "fieldName": "Eventi-Created By",
        "relationshipType": "many-to-many",
        "order": 3,
        "visible": true,
        "width": 120
      },
      "Created At": {
        "name": "Created At",
        "type": "datetime",
        "subtype": "createdAt",
        "icon": "ri-magic-line",
        "autocolumn": true,
        "constraints": {
          "type": "string",
          "length": {},
          "presence": false,
          "datetime": {
            "latest": "",
            "earliest": ""
          }
        },
        "order": 4,
        "visible": true,
        "width": 120
      },
      "Updated By": {
        "name": "Updated By",
        "type": "link",
        "subtype": "updatedBy",
        "icon": "ri-magic-line",
        "autocolumn": true,
        "constraints": {
          "type": "array",
          "presence": false
        },
        "tableId": "ta_users",
        "fieldName": "Eventi-Updated By",
        "relationshipType": "many-to-many",
        "order": 5,
        "visible": true,
        "width": 120
      },
      "Updated At": {
        "name": "Updated At",
        "type": "datetime",
        "subtype": "updatedAt",
        "icon": "ri-magic-line",
        "autocolumn": true,
        "constraints": {
          "type": "string",
          "length": {},
          "presence": false,
          "datetime": {
            "latest": "",
            "earliest": ""
          }
        },
        "order": 6,
        "visible": true,
        "width": 120
      },
      "Titolo": {
        "type": "string",
        "constraints": {
          "type": "string",
          "length": {
            "maximum": null
          },
          "presence": {
            "allowEmpty": false
          }
        },
        "name": "Titolo",
        "order": 0,
        "visible": true,
        "width": 120,
        "disabled": false
      },
      "Inizio": {
        "type": "datetime",
        "constraints": {
          "type": "string",
          "length": {},
          "presence": {
            "allowEmpty": false
          },
          "datetime": {
            "latest": "",
            "earliest": ""
          }
        },
        "name": "Inizio",
        "ignoreTimezones": true,
        "order": 1,
        "visible": true,
        "width": 120,
        "disabled": false
      },
      "Fine": {
        "type": "datetime",
        "constraints": {
          "type": "string",
          "length": {},
          "presence": {
            "allowEmpty": false
          },
          "datetime": {
            "latest": "",
            "earliest": ""
          }
        },
        "name": "Fine",
        "ignoreTimezones": true,
        "order": 2,
        "visible": true,
        "width": 120,
        "disabled": false
      },
      "Logo": {
        "type": "attachment",
        "constraints": {
          "type": "array",
          "presence": false
        },
        "name": "Logo",
        "order": 8,
        "visible": true,
        "width": 120
      },
      "Access": {
        "type": "options",
        "constraints": {
          "type": "string",
          "presence": false,
          "inclusion": [
            "Pubblico",
            "Riservato"
          ]
        },
        "name": "Access",
        "order": 9,
        "visible": true,
        "width": 120
      },
      "Ticket": {
        "type": "options",
        "constraints": {
          "type": "string",
          "presence": false,
          "inclusion": [
            "Free",
            "Pagamento"
          ]
        },
        "name": "Ticket",
        "order": 10,
        "visible": true,
        "width": 120
      },
      "Programma": {
        "type": "attachment",
        "constraints": {
          "type": "array",
          "presence": false
        },
        "name": "Programma",
        "order": 11,
        "visible": true,
        "width": 120
      },
      "Indirizzo": {
        "type": "string",
        "constraints": {
          "type": "string",
          "length": {
            "maximum": null
          },
          "presence": false
        },
        "name": "Indirizzo",
        "order": 13,
        "visible": true,
        "width": 120
      },
      "Citta": {
        "type": "string",
        "constraints": {
          "type": "string",
          "length": {
            "maximum": null
          },
          "presence": false
        },
        "name": "Citta",
        "order": 14,
        "visible": true,
        "width": 120
      },
      "Provincia": {
        "type": "options",
        "constraints": {
          "type": "string",
          "presence": false,
          "inclusion": [
            "AG",
            "AL",
            "AN",
            "AO",
            "AR",
            "AP",
            "AT",
            "AV",
            "BA",
            "BT",
            "BL",
            "BN",
            "BG",
            "BI",
            "BO",
            "BZ",
            "BS",
            "BR",
            "CA",
            "CL",
            "CB",
            "CI",
            "CE",
            "CT",
            "CZ",
            "CH",
            "CO",
            "CS",
            "CR",
            "KR",
            "CN",
            "EN",
            "FM",
            "FE",
            "FI",
            "FG",
            "FC",
            "FR",
            "GE",
            "GO",
            "GR",
            "IM",
            "IS",
            "SP",
            "AQ",
            "LT",
            "LE",
            "LC",
            "LI",
            "LO",
            "LU",
            "MC",
            "MN",
            "MS",
            "MT",
            "ME",
            "MI",
            "MO",
            "MB",
            "NA",
            "NO",
            "NU",
            "OT",
            "OR",
            "PD",
            "PA",
            "PR",
            "PV",
            "PG",
            "PU",
            "PE",
            "PC",
            "PI",
            "PT",
            "PN",
            "PZ",
            "PO",
            "RG",
            "RA",
            "RC",
            "RE",
            "RI",
            "RN",
            "RM",
            "RO",
            "SA",
            "VS",
            "SS",
            "SV",
            "SI",
            "SR",
            "SO",
            "TA",
            "TE",
            "TR",
            "TO",
            "OG",
            "TP",
            "TN",
            "TV",
            "TS",
            "UD",
            "VA",
            "VE",
            "VB",
            "VC",
            "VR",
            "VV",
            "VI",
            "VT"
          ]
        },
        "name": "Provincia",
        "order": 15,
        "visible": true,
        "width": 120
      },
      "CAP": {
        "type": "string",
        "constraints": {
          "type": "string",
          "length": {
            "maximum": 5
          },
          "presence": false
        },
        "name": "CAP",
        "order": 16,
        "visible": true,
        "width": 120
      },
      "Descrizione": {
        "type": "longform",
        "constraints": {
          "type": "string",
          "length": {},
          "presence": false
        },
        "name": "Descrizione",
        "useRichText": true,
        "order": 17,
        "visible": true,
        "width": 120
      },
      "Location": {
        "type": "string",
        "constraints": {
          "type": "string",
          "length": {
            "maximum": null
          },
          "presence": false
        },
        "name": "Location",
        "order": 12,
        "visible": true,
        "width": 120
      },
      "Cover": {
        "type": "attachment",
        "constraints": {
          "type": "array",
          "presence": false
        },
        "name": "Cover",
        "order": 7,
        "visible": true,
        "width": 120,
        "disabled": false
      },
      "Immagini": {
        "type": "attachment",
        "constraints": {
          "type": "array",
          "presence": false
        },
        "name": "Immagini",
        "order": 18,
        "visible": true,
        "width": 120
      },
      "Status": {
        "type": "options",
        "constraints": {
          "type": "string",
          "presence": {
            "allowEmpty": false
          },
          "inclusion": [
            "Draft",
            "Published"
          ]
        },
        "name": "Status",
        "disabled": false,
        "order": 19,
        "visible": true,
        "width": 120
      }
    },
    "primaryDisplay": "Auto ID"
  }
}```

Hi Alessandro @alex-oss,

To start with: Adalo External collections expect to receive an array of records from external source. There should be some unique ID for each record in this array.

What you are showing is not an array of records but rather a single record.

Judging by what I see in the docs here Create an application, you might need to use another call to get values from a table. This one might work: Search for rows - I didn’t find a classic “get all”. Putting POST request in Adalo for GET ALL type of query should work (although it’s a bit unusual).

Of course testing is required.

Hope this helps.

Best regards, Victor.

Thank you very much Victor @Victor, It works!

I had to set DATA (first) and ROWS (second) as a RESULT KEY for GET ALL but it works perfectly.

Have a nice day :muscle:

1 Like