Cannot get data for external DB

Ask the community
,
1

Hello,
I built my environment using AWS RDS as External DB and AppRunner as Adapter with reference to the following URL.
URL: https://support.wix.com/en/article/velo-integrate-your-aws-rds-database-with-your-wix-site

  1. Create the following external collections
    Namespace：wix-velo-externl-db
  2. Successfully accessed external DB (AWS RDS)

  1. Tried to retrieve data from [contacts] table
<dataFunctions.jsw (Backend Web Module)>
import wixData from 'wix-data';

export function getPerson(itemId) {
    wixData.get('contacs', itemId)
        .then((result) => {
            console.log(result);
        })
        .catch((err) => {
            console.log(err);
    })
}

<Home (Frontend)>
import { getPerson } from 'backend/dataFunctions';

let itemId = '3c869432-cd1b-4a24-a083-0e4b4108ecda';
getPerson(itemId);

4.The following error is displayed

WDE0025: The contacts collection does not exist. You cannot work with a collection using the Data API before it is created in the Editor.

Do you have a different way of accessing the external DB?

Thanks,
Won

2

What I want to do is get data from an external DB and display them in a table.

3

I have found a thread that may be helpful.
https://www.wix.com/velo/forum/coding-with-velo/sync-external-db-with-wix-collection

I think it is close to my requirements.
Develop an API of some sort and use [wix-http-functions] to periodically retrieve data.
Is this a similar procedure?

4

I read the [wix-http-functions] documentation.
It was different from what I imagined.
I thought it was an API built on the backend server side and called by Wix Velo, but this is not what it says, is it?
I don’t want to build an API on a site created with Wix.

Could someone please advise me on this?

5

Hi @wys-002 ,

It is not related to the http functions module.

It is still a part of Wix data.

Have you checked the database ID (not the name)?

Certified Code Logo