Get list of active users by plan + How to query DB + How to run nodejs in WIX?

Ask the community
,
1

Hello,

I’m completely new to Wix & Corvid. I’ve got e-commerce platform. I’m looking to understand the following -

  1. How can I query the database of my Wix website? As in, where do I start? How do I figure out the database connection details, where do . I write the DB query & how do I run. Sorry, I know I sound dumb. I just can’t work this out.

  2. I’m in need to know the active subscribed users by plan. Is there a ready to use API or should I write an API to get the detail?

  3. How can I access the Nodejs layer of the existing website please. I’m trying to figure out how to access the coding aspects of the website.

Any help to get me going here would be great please.

Kind Regards

2

Firstly I would suggest that you have a good read of this complete section.
https://support.wix.com/en/corvid-by-wix/basics

As for your questions then please see the following.

  1. Wix Data Query
    https://www.wix.com/corvid/reference/wix-data.WixDataQuery.html
    https://support.wix.com/en/article/corvid-working-with-the-data-api
    https://www.wix.com/corvid/forum/corvid-tips-and-updates/how-to-create-a-search-for-your-database
    https://www.youtube.com/watch?v=Hx7_8-lRsW0&feature=youtu.be

  2. Paid Plans
    https://www.wix.com/corvid/reference/wix-paid-plans.html
    https://www.wix.com/corvid/reference/wix-paid-plans-backend.html
    https://support.wix.com/en/paid-plans/setting-up-paid-plans
    https://www.wix.com/corvid/reference/wix-users.User.html#getPricingPlans

  3. Wix NodeJS
    https://support.wix.com/en/article/corvid-managing-external-code-libraries-with-the-package-manager
    https://www.wix.com/corvid/feature/npm-packages

  4. Extra Info
    If you are wanting to expose your site to another company etc, then you can also look at using Wix Fetch or Wix HTTP Functions if a NodeJS is not available for example.
    https://www.wix.com/corvid/reference/wix-fetch.html
    https://support.wix.com/en/article/corvid-accessing-third-party-services-with-the-fetch-api
    https://www.wix.com/corvid/reference/wix-http-functions.html
    https://support.wix.com/en/article/corvid-exposing-a-site-api-with-http-functions
    Example: https://www.wix.com/corvid/forum/corvid-tips-and-updates/example-myapi-and-myapiclient

Finally, make full use of the search function in this forum as there will no doubt be many other previous posts about your questions above.

Plus, you will find many examples and video tutorials that you can use by going through the Documentation tab in this forum’s header.

You also have a list in the Corvid Support section listed at the top of this reply too.
https://support.wix.com/en/article/corvid-index-of-examples

Any code issues, then simply make a new post here and ask again.

3

Thank you very much. This will keep me engaged for the whole weekend :slight_smile: Owe you a Whisky aye sure :wink:

4

Good Whisky is an expensive taste and potent, too much and you would not remember the weekend :tumbler_glass::wink:

Don’t try to do everything at once, just take it all one step at a time and you should be fine.

5

@givemeawhisky