Accessing Order Collections

export function get_orders(request) {
// URL looks like: https://www.mysite.com/_functions/myFunction/John/Doe

let options = {
“headers”: {
“Content-Type”: “application/json”
}
};

let queryOptions = {
“suppressAuth”: true
};

//authorise
const KEY = ‘XXXXXX’;
const apiKey = request.query[“apiKey”];
if (apiKey !== KEY) {
return forbidden;
}
const lastOrder = parseInt(request.query[“lastOrder”]);
// query a collection to find matching items
return wixData.query(“Stores/Orders”)
.ge(‘Number’,lastOrder)
.find(queryOptions)
.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”: No new order(s) after order no:${lastOrder} was not found
};
return notFound(options);
} )
// something went wrong
.catch( (error) => {
options.body = {
“error”: error
};
return serverError(options);
} );
}