0

Database look up

Is it possible to look up a table in a different database?

Thanks

3 replies

null
    • blackie
    • 5 yrs ago
    • Reported - view

    Yes, using the REST API

    https://ninoxdb.de/en/manual/api/rest

    • Andrew.1
    • 5 yrs ago
    • Reported - view

    Thanks - of course, that makes sense. The next thing I need to get some help on is how to make this work! I have a working rest api using Postman and can see the data - so my url is like the one in the help section https://api.ninoxdb.de/v1/teams/67mm9vc324bM7x/databases/nk5xt24oixj4/tables/A/records

    How do I now get this data into a table? Or a linked table?

    • Sakshi_Singh
    • 5 yrs ago
    • Reported - view

    Hi Andrew,

    Use this in a button for your URL above,

    -----------------------------------------

    let response := do as server
    http("GET", "YOUR-URL", {
    Authorization: "Bearer YOUR-APIKEY"
    }, null)
    end;

    if response.error then
    alert("oops!" + response.error)
    else
    Text := text(item(response.result, 0))
    end

    -----------------------------------------

    Regards,

    Sakshi- Ninox

Content aside

  • 5 yrs agoLast active
  • 3Replies
  • 2058Views