Can not access the Store "Collections" and "Products" table

Ask the community
, ,
1

Hi,
I’m recently writing an mobile app to show the users of our selling products. I have been looking into the “Wix Data API” and it works fine with new created collection(table). This, however, is not the case when Im trying to fetch data from Store “Collections” and “Products” collections. It says the schemas does not exist. Are we not allowed to fetch these data using javascript codes with wixCode?

This is creating inconvenience for my customers. Can someone help me out with this please? Thank you.

2

Hello Jay,

Can you explain further or show us a piece of code that relates to the problem above?
If you want to query through you’re collection you can use the wix-data API - here .
If you are fetching data from you’re wix website using an external website/application you then use wix-fetch API - here .

Massa

3

I have been using what you suggested, it is fine to fetch table “TestCollection” from Database, but it does not work I try to fetch data from Stores/Collections or Store/Products.

This is how my database looks like.


This is how my code looks like:

import {ok, notFound, serverError} from ‘wix-http-functions’;
import wixData from ‘wix-data’;

export function get_products (request) {
let options = {
“headers”: {
“Content-Type”: “application/json”
}
};
return wixData.query(“Stores/Collections”)
.find()
.then( (results) => {
// matching items were found
if (results.items.length > 0) {
options.body = {
“items”: results.items
};
return ok(options);
}
// no matching items found
options.body = {
“error”: ${request.path[0]} ${request.path[1]} wasn't found
};
return notFound(options);
} )
// something went wrong
. catch ( (error) => {
options.body = {
“error”: error
};
return serverError(options);
} );
}

4

no feedback???

5

Hi Jay,
The code looks ok.
How do you try to fetch it?
Roi.

6

Im trying to fetch the product datas from the store’s ‘default’ products table. But it just does not work with it and shows “schemas does not exist”. It works fine with other tables except for the sotre tables.

7

Hi Jay,
Have you published your site? How do you try to fetch the information? Can you please post here the exact fetch request code? Moreover, can you please send us the site URL?

Thanks,
Tal.

8

Hi Tal,
This is my site url: https://misspandaltd.wixsite.com/misspanda-copy/

And below are my codes:

import {ok, notFound, serverError} from ‘wix-http-functions’;
import wixData from ‘wix-data’;

export function get_products (request) {
let options = {
“headers”: {
“Content-Type”: “application/json”
}
};
return wixData.query(“Stores/Collections”)
.find()
.then( (results) => {
// matching items were found
if (results.items.length > 0) {
options.body = {
“items”: results.items
};
return ok(options);
}
// no matching items found
options.body = {
“error”: ${request.path[0]} ${request.path[1]} wasn't found
};
return notFound(options);
} )
// something went wrong
. catch ( (error) => {
options.body = {
“error”: error
};
return serverError(options);
} );
// options.body = {
// “result”: “Server Error.”
// };
// return ok(options);
}

9

Hi,
In order to query your stores collection as explained here .

wixData.query('Stores/Products')  
.hasSome('collections.id', ['collectionID', ...])  
.find()    
.then(console.log);

Good luck,
Tal.